Data Warehouse Test Engineer
ZENITH INFOTEK LLC
- Location
- Remote (Research Triangle Park, NC)
- Compensation
- $50 - $55/hr
- Employment
- Contract
- Level
- Senior Level
Posted 3 weeks ago
About the Role
Zenith Infotek LLC is seeking a Data Warehouse Test Engineer to ensure data quality and integrity within complex financial systems. The role focuses on validating data reconciliation, testing AI/ML components, and supporting banking domain operations through rigorous QA processes.
Skills
SQL
BigQuery
API Testing
Data Warehouse Testing
Python
QA Engineering
Functional Testing
Regression Testing
Integration Testing
REST API
Postman
Pytest
Data Reconciliation
Banking Domain Knowledge
Financial Services
Data Quality
Perks
- Remote Work
Full job details
Job Title: Data Warehouse Test Engineer
Location: (Remote)
Duration: 6+ Months (Contract)
Interview: Video Interview
Location: (Remote)
Duration: 6+ Months (Contract)
Interview: Video Interview
Job Description
We are looking for an experienced Data Warehouse Test Engineer with strong skills in SQL, BigQuery, API Testing, Data Warehouse Testing, and Python.
Required Skills
- 5+ years of experience in QA/Test Engineering.
- Strong experience with functional, regression, integration, and negative testing.
- Experience testing AI/ML, LLM, Conversational AI, or NL-to-SQL systems.
- Strong REST API testing using Postman, pytest, or similar tools.
- Advanced SQL and BigQuery Standard SQL.
- Experience with CTEs, Window Functions, Joins, Date Functions, STRUCT/ARRAY, and complex queries.
- Strong Data Warehouse and Data Quality Testing experience.
- Experience with data reconciliation and validation.
- Strong Python scripting/automation skills.
- Good experience writing clear and detailed defect reports.
- Strong banking/financial services domain knowledge including:
- Deposits
- Accounts
- Transactions
- AML/KYC
- Fraud
- Compliance
- Strong analytical and problem-solving skills.
Preferred Skills
- Experience with Cortex, Looker, ThoughtSpot, or similar AI/NL-to-SQL platforms.
- GCP experience with BigQuery, Cloud Run, Firestore, Dataplex, and IAP.
- Experience with pytest, SQLAlchemy, and Google Cloud BigQuery SDK.
- Knowledge of SCD2, Bitemporal tables, and Data Warehousing.
- Knowledge of GLBA, FCRA, BSA/AML, BCBS 239, and SOX.
- Knowledge of Knowledge Graphs and Ontology concepts.
Flexible work from home options available.