Data Warehouse Test Engineer at ZENITH INFOTEK LLC in NC-Research Triangle Park-27709 Hybrid - US
- Company: ZENITH INFOTEK LLC
- Location: NC-Research Triangle Park-27709 Hybrid - US
- Posted: Sep 17, 2026
- Type: Independent Contractor
- Salary: $50.00 - $55.00 per hour
- Experience: 5+ years
Overview
We are looking for an experienced Data Warehouse Test Engineer with strong skills in SQL, BigQuery, API Testing, Data Warehouse Testing, and Python. Data Warehouse Test Engineer role involving QA/Test Engineering, functional, regression, integration, and negative testing, API testing, data warehouse…
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.
Responsibilities
- Data Warehouse Test Engineer role involving QA/Test Engineering, functional, regression, integration, and negative testing, API testing, data warehouse testing, and data quality testing.
Requirements
- 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.
- Deposits
- Accounts
- Transactions
- AML/KYC
- Fraud
- Compliance
- Strong analytical and problem-solving 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.
Skills
Required
- SQL
- BigQuery
- API Testing
- Data Warehouse Testing
- Python
- Functional testing
- Regression testing
- Integration testing
- Negative testing
- REST API testing
- Postman
- pytest
Preferred
- Cortex
- Looker
- ThoughtSpot
- GCP
- Cloud Run
- Firestore
- Dataplex
- IAP
Benefits
- Flexible work from home options available.
- Compensation: $50.00 - $55.00 per hour