Home

Data Warehouse Test Engineer in Dearborn MI at Dearborn, Michigan, USA
Email: [email protected]
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=3582075&uid=83309df5cb1f445da8a6ccbb3a78e0bd

From:

Himanshu Singh,

Quantum World

[email protected]

Reply to: [email protected]

Job Title: Data Warehouse Test Engineer

Location: Dearborn, MI (Onsite)

10+ years

Local 1st Preference

Required Skills:

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 / BigQuery: Advanced SQL authoring in BigQuery 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 hand-holding.

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.

Preferred Skills:

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

Himanshu Singh

Keywords: artificial intelligence machine learning information technology Michigan
Data Warehouse Test Engineer in Dearborn MI
[email protected]
http://bit.ly/4ey8w48
https://jobs.nvoids.com/job_details.jsp?id=3582075&uid=83309df5cb1f445da8a6ccbb3a78e0bd
[email protected]
View All
04:13 AM 06-Aug-26


To remove this job post send "job_kill 3582075" as subject from [email protected] to [email protected]. Do not write anything extra in the subject line as this is a automatic system which will not work otherwise.

Pages not loading, taking too much time to load, server timeout or unavailable, or any other issues please contact admin at [email protected]


Time Taken: 17

Location: Dearborn, Michigan