Data Warehouse Test Engineer

Job Title: Data Warehouse Test Engineer
Location: (Remote)
Duration: 6+ Months (Contract)
Interview: Video Interview

Job DescriptionWe are looking for an experienced Data Warehouse Test Engineer with strong skills in SQL, BigQuery, API Testing, Data Warehouse Testing, and Python.Required Skills

• 5+ years of experience in QA/Test Engineering.
• Strong experience with functional, regression, integration, and negative testing.
• Experience testing AI/ML, LLM, Conversational AI, or NL-to-SQL systems.
• Strong REST API testing using Postman, pytest, or similar tools.
• Advanced SQL and BigQuery Standard SQL.
• Experience with CTEs, Window Functions, Joins, Date Functions, STRUCT/ARRAY, and complex queries.
• Strong Data Warehouse and Data Quality Testing experience.
• Experience with data reconciliation and validation.
• Strong Python scripting/automation skills.
• Good experience writing clear and detailed defect reports.
• Strong banking/financial services domain knowledge including:
  • Deposits
  • Accounts
  • Transactions
  • AML/KYC
  • Fraud
  • Compliance
• Strong analytical and problem-solving skills.

Preferred Skills

• Experience with Cortex, Looker, ThoughtSpot, or similar AI/NL-to-SQL platforms.
• GCP experience with BigQuery, Cloud Run, Firestore, Dataplex, and IAP.
• Experience with pytest, SQLAlchemy, and Google Cloud BigQuery SDK.
• Knowledge of SCD2, Bitemporal tables, and Data Warehousing.
• Knowledge of GLBA, FCRA, BSA/AML, BCBS 239, and SOX.
• Knowledge of Knowledge Graphs and Ontology concepts.

Flexible work from home options available.