Data Warehouse Test Engineer

ZENITH INFOTEK LLC

6d • $40 - $50 • Remote

About The Position

This is a remote position for a Data Warehouse Test Engineer. The role involves designing and executing test suites, performing API testing, writing complex SQL queries, documenting defects, and applying critical thinking and business analysis skills within the banking domain.

Requirements

• 5+ years of Test Engineering experience designing and executing functional, regression, integration, and negative test suites.
• Experience with AI/ML system testing, or conversational AI testing strongly preferred.
• REST API testing using tools such as Postman, pytest, or equivalent.
• Experience validating JSON schemas, HTTP error codes, and streaming responses (SSE).
• Advanced SQL authoring in Big Query Standard SQL; window functions, CTEs, date arithmetic, SAFE functions, STRUCT/ARRAY handling.
• Ability to independently write complex validation queries against a multi-table star schema.
• Ability to write precise, reproducible defect reports that include expected SQL, actual SQL, expected result set, and actual result set.
• Understanding of retail/commercial bank operations: deposits, accounts, transactions, AML, KYC, fraud, compliance.
• Ability to interpret bank KPIs and business rules without extensive handholding.
• Critical Thinking & Business Analysis: Ability to read a business question, understand the intended meaning, independently determine the correct SQL answer, and validate whether an AI system answered correctly, not just syntactically but semantically.

Nice To Haves

• Experience testing LLM-based or NL-to-SQL systems (Cortex, Looker, ThoughtSpot, or similar)
• Familiarity with GCP services: BigQuery, Cloud Run, Firestore, Dataplex, IAP
• Python scripting for test automation (pytest, SQLAlchemy, google-cloud-bigquery SDK)
• SCD2 / data warehousing concepts (bitemporal tables, slowly changing dimensions)
• Regulatory knowledge: GLBA, FCRA, BSA/AML, BCBS 239, SOX data quality
• Experience with data quality testing and data reconciliation
• Knowledge Graph or ontology concepts
• Automotive finance domain knowledge

Responsibilities

• Design and execute functional, regression, integration, and negative test suites.
• Perform REST API testing using tools such as Postman, pytest, or equivalent.
• Validate JSON schemas, HTTP error codes, and streaming responses (SSE).
• Author advanced SQL queries in Big Query Standard SQL, including window functions, CTEs, date arithmetic, SAFE functions, and STRUCT/ARRAY handling.
• Write complex validation queries against a multi-table star schema.
• Write precise, reproducible defect reports that include expected SQL, actual SQL, expected result set, and actual result set.
• Understand retail/commercial bank operations: deposits, accounts, transactions, AML, KYC, fraud, compliance.
• Interpret bank KPIs and business rules without extensive handholding.
• Read a business question, understand the intended meaning, independently determine the correct SQL answer, and validate whether an AI system answered correctly, not just syntactically but semantically.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior
• Education Level: No Education Listed