ETL QA Tester / Data Warehouse Testing Engineer

Nxtwave Disruptive Technologies (Hiring for a Client); Hyderabad, Chennai; On-site; INR 1,000,000 - 1,500,000; Full time

Job summary

Nxtwave Disruptive Technologies (Hiring for a Client) is seeking a Data Warehouse Testing Engineer to validate Snowflake environments and Matillion pipelines. You will write test cases, automate data validation, and ensure data accuracy across ingestion, transformation, and reporting layers.

The role emphasizes SQL reconciliation, pipeline debugging, and end-to-end data governance in a cloud data warehouse setup. Strong collaboration with engineers and BI teams is required.

Qualifications

• BE/BTech or equivalent in CS/IT or related field.
• Hands-on experience testing Snowflake data warehouses.
• ETL validation experience with Matillion or similar tools.

Responsibilities

• Design and execute test plans for Snowflake and Matillion ETL pipelines.
• Develop data validation tests and SQL-based reconciliation checks.
• Automate ETL tests and benchmark query performance against SLAs.
• Collaborate with data engineers and BI teams to track defects.

Education

B.E./B.Tech or equivalent

Tools

Snowflake

Matillion ETL

SQL

Python/Shell

Tableau/Power BI

Jira

AWS/Azure/GCP

Job description

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.