Remote Data Warehouse QA Engineer | SQL & AI Testing

ZENITH INFOTEK LLC; United States; Remote; USD 100,000 - 160,000; Full time

Benefits offered by this job

Remote work option

Job summary

ZENITH INFOTEK LLC is seeking a Data Warehouse Test Engineer to join our team in Dearborn, MI with remote options. The role focuses on designing and executing functional, regression, integration, and negative test suites for data warehousing systems, including AI/ML components and bank data contexts.

The ideal candidate has 5+ years in test engineering, strong API testing skills, advanced BigQuery SQL, and experience with defect reporting and interpreting retail banking KPIs and rules.

Qualifications

• Test Engineering: 5+ years designing and executing functional, regression, integration, and negative test suites. Experience with AI/ML system testing, or conversational AI testing strongly preferred.
• API Testing: REST API testing using tools such as Postman, pytest, or equivalent. Experience validating JSON schemas, HTTP error codes, and streaming responses (SSE).
• SQL / Big Query: Advanced SQL authoring in Big Query Standard SQL; window functions, CTEs, date arithmetic, SAFE functions, STRUCT/ARRAY handling. Must be able to independently write complex validation queries against a multi-table star schema.
• Defect Documentation: Ability to write precise, reproducible defect reports that include expected SQL, actual SQL, expected result set, and actual result set.
• Bank Domain Knowledge: 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.

Job description

ZENITH INFOTEK LLC is seeking a Data Warehouse Test Engineer to join our team in Dearborn, MI with remote options. The role focuses on designing and executing functional, regression, integration, and negative test suites for data warehousing systems, including AI/ML components and bank data contexts.

The ideal candidate has 5+ years in test engineering, strong API testing skills, advanced BigQuery SQL, and experience with defect reporting and interpreting retail banking KPIs and rules.