Data Warehouse Test Engineer at ZENITH INFOTEK LLC in MI-Dearborn-48101 Fully Remote - US
- Company: ZENITH INFOTEK LLC
- Location: MI-Dearborn-48101 Fully Remote - US
- Posted: Sep 17, 2026
- Type: Full-time
- Salary: $40.00 - $50.00 per hour
- Experience: 5+ years
Overview
Designing and executing functional, regression, integration, and negative test suites REST API testing using tools such as Postman, pytest, or equivalent Validating JSON schemas, HTTP error codes, and streaming responses (SSE)
Responsibilities
- Designing and executing functional, regression, integration, and negative test suites
- REST API testing using tools such as Postman, pytest, or equivalent
- Validating JSON schemas, HTTP error codes, and streaming responses (SSE)
- Writing complex validation queries against a multi-table star schema
- Writing precise, reproducible defect reports
- Interpreting bank KPIs and business rules
- Validating whether an AI system answered correctly, not just syntactically but semantically
Requirements
- · 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.
- · 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
Skills
Preferred
- Knowledge Graph or ontology concepts
- Automotive finance domain knowledge
Benefits
- Compensation: $40.00 - $50.00 per hour