Data Warehouse Test Engineer

ZenithInfotek LLC is seeking a Data Warehouse Test Engineer to validate data warehouse, API, and AI/ML systems. The role involves designing and executing comprehensive test suites, authoring complex BigQuery SQL validation queries, documenting defects, and assessing AI responses for technical and semantic correctness within banking operations.

Requirements:

• 5+ years designing and executing functional, regression, integration, and negative test suites
• 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
• Must be able 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
• 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
• Experience with AI/ML system testing, or conversational AI testing strongly preferred