ETL TEST ENGINEER WITH GCP BIG QUERY WITH BANKING DOMAIN

We need a data warehouse tester with GCP and BigQuery experience and Banking domain

Job Title              Data Warehouse Test Engineer

Location             Dearborn, MI (Onsite)

Rate – $65/hr Max.

Duration             12 Months

 Must-have profile

Data Warehouse / ETL Testing
GCP + BigQuery — hands-on, not just cloud exposure
Advanced SQL — CTEs, window functions, joins, complex validation queries
Banking domain — deposits, accounts, transactions, AML/KYC, fraud, compliance
API Testing — REST/Postman
Data validation/reconciliation
 

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
 

Maintain and improve monitoring and observability dashboards Droisys is an equal opportunity employer. We do not discriminate based on race, religion, color, national origin, gender, gender expression, sexual orientation, age, marital status, veteran status, disability status or any other characteristic protected by law. Droisys believes in diversity, inclusion, and belonging, and we are committed to fostering a diverse work environment