Job Overview:

We are looking for a skilled Data Warehouse Testing Engineer with deep expertise in Snowflake, Matillion ETL, and automated data validation processes. In this full time role, you will design and execute comprehensive test cases and automation scripts to guarantee data accuracy, integrity, and pipeline performance across our cloud data warehouse environment. This position is built for a detail-oriented quality engineer who excels at SQL reconciliation, pipeline debugging, and end-to-end data governance.

Key Responsibilities:

- Data Warehouse &
- Pipeline Testing: Develop and execute test plans, test cases, and test scripts for Snowflake data warehouse solutions and Matillion ETL pipelines to validate accurate extraction, transformation, and loading.

- Data Quality &

- Reconciliation: Validate data completeness, consistency, and structural accuracy across multiple ingestion sources, transformation layers, and downstream BI reporting views.

- Automation &

- Performance Tuning: Write complex SQL queries for data reconciliation and exception reporting, implement automated ETL test suites, and benchmark query performance against strict SLAs.





- Defect Governance &

- Reporting: Partner closely with data engineers, BI developers, and business analysts to document defects clearly, drive technical resolutions, and deliver timely test sign-off metrics.

Required Skills &

- Qualifications:

- Strong hands-on experience testing Snowflake Data Warehouse ecosystems (complex SQL, query performance tuning, and dimensional data modeling concepts).

- Direct practical experience executing ETL validation on Matillion ETL or equivalent cloud-native data integration tools.

- Deep understanding of core Data Warehousing concepts (Star/Snowflake schemas, Slowly Changing Dimensions Type 1/2, Fact and Dimension tables) alongside functional and regression testing.

- Familiarity with defect tracking platforms (Jira), cloud ecosystems (AWS/Azure/GCP), and foundational scripting (Python/Shell) or BI tools (Tableau/Power BI) for report validation.

- B.E. / B.Tech or equivalent undergraduate degree in Computer Science, Information Technology, or a related engineering discipline.

📌 ETL QA Tester / Data Warehouse Testing Engineer (Chennai)
🏢 Nxtwave Disruptive Technologies (Hiring for a client)
📍 Chennai