← Back to jobs

Kaizen Technologies, Inc Logo
Data Warehouse Test Engineer

Kaizen Technologies, Inc

 

Dearborn, MI, USA

Posted On: Just posted
Experience: 5+ years
Availability: Onsite
Openings: 1
Category: Data Warehouse Engineer
Tenure: Contract - Corp-to-Corp
Related Jobs

No related jobs found

Description

You will own the testing of AI-driven data warehouse systems, focusing on SQL validation, API integrity, and semantic correctness of NL-to-SQL outputs.

This role is on-site.

Responsibilities

  • Design and execute functional, regression, integration, and negative test suites for data warehouse applications.
  • Write complex SQL queries in BigQuery to validate multi-table star schemas, ensuring semantic and syntactic accuracy.
  • Test REST APIs using Postman or pytest, validating JSON schemas, HTTP error codes, and streaming responses.
  • Document precise, reproducible defect reports with expected versus actual SQL and result sets.
  • Analyze business rules in banking operations (deposits, AML, KYC) to independently verify AI-generated answers.

Required Skills

  • 5+ years of test engineering experience designing comprehensive test suites.
  • Advanced BigQuery SQL skills: window functions, CTEs, SAFE functions, STRUCT/ARRAY handling.
  • Proficiency in API testing tools (Postman, pytest) and JSON schema validation.
  • Strong understanding of retail/commercial banking operations and compliance (AML, KYC, fraud).
  • Ability to interpret business KPIs and determine correct SQL answers without extensive guidance.
  • Experience with defect documentation standards including expected/actual result sets.
  • Python scripting skills for test automation.

Preferred Skills

  • Experience testing LLM-based or NL-to-SQL systems (Cortex, Looker, ThoughtSpot).
  • Familiarity with GCP services: BigQuery, Cloud Run, Firestore, Dataplex, IAP.
  • Knowledge of data warehousing concepts (SCD2, bitemporal tables) and regulatory frameworks (GLBA, FCRA, SOX).

Education

Any Gradute

Related Jobs

No related jobs found

← Back to jobs