Nxtwave Disruptive Technologies (Hiring for a Client) logo

ETL QA Tester / Data Warehouse Testing Engineer

Nxtwave Disruptive Technologies (Hiring for a Client)

6 - 8 years

32 - 35 Lacs

Hyderabad Chennai

Posted:1 week ago

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.

Skills Required

Data warehousing SQL Bi Automation testing JIRA Snowflake ETL Automation Testing Reporting

Learn the skills this job asks for

See your skill gap for QA / Test Engineer →

Free courses, interview questions and practice for each skill.

Work Mode

Work from Office

Job Type

Full Time

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Nxtwave Disruptive Technologies (Hiring for a Client) logo
Nxtwave Disruptive Technologies (Hiring for a Client)

RecommendedJobs for You

Nxtwave Disruptive Technologies (Hiring for a Client) logo

ETL QA Tester / Data Warehouse Testing Engineer

Nxtwave Disruptive Technologies (Hiring for a Client)

Hyderabad, Chennai

Nxtwave Disruptive Technologies (Hiring for a Client) logo

ETL QA Tester / Data Warehouse Testing Engineer

Nxtwave Disruptive Technologies (Hiring for a Client)

Hyderabad, Chennai