ETL QA Engineer(Snowflake, SQL)-Immediate

Kezan Consulting; Gurugram District, Bengaluru; Hybrid; INR 900,000 - 1,300,000; Full time

Job summary

Kezan Consulting is seeking an ETL QA Engineer to join our data testing practice in Bangalore and Gurgaon. You will design and execute ETL, functional and regression tests to validate data across sources and targets.

You will perform backend testing with SQL and Snowflake, identify discrepancies, and collaborate with Data Engineers, Developers and Business teams to ensure high-quality releases.

Qualifications

• Strong experience in ETL/Data Warehouse Testing.
• Hands-on expertise in Snowflake and SQL.
• Strong knowledge of Functional Testing and Regression Testing.
• Experience with Data Validation, Data Reconciliation and Data Quality Testing.
• Understanding of ETL/ELT pipelines and data migration.
• Experience in writing complex SQL queries, joins, subqueries and validations.
• Knowledge of Source-to-Target Mapping (STTM) and ETL workflows.
• Exposure to Defect Management and Test Case Design.
• Familiarity with Agile/Scrum methodology and SDLC/STLC.

Responsibilities

• Design and execute ETL, functional and regression test cases.
• Validate data accuracy, completeness and consistency across source and target systems.
• Perform backend testing using SQL and Snowflake.
• Identify data discrepancies, investigate root causes and track defects to closure.
• Validate ETL/ELT pipelines, transformations and business rules.
• Collaborate with Data Engineers, Developers and Business teams to ensure quality releases.

Skills

ETL/Data Warehouse Testing

Snowflake

SQL

Functional Testing

Regression Testing

Data Validation

Data Reconciliation

Data Quality Testing

ETL/ELT pipelines

Source-to-Target Mapping

Test Case Design

Defect Management

Agile/Scrum

SDLC/STLC

Job description

Job Title: ETL QA Engineer

Experience: 3-6 Years
Location: Bangalore & Gurgaon

Must-Have Skills

• Strong experience in ETL/Data Warehouse Testing
• Hands-on expertise in Snowflake & SQL
• Strong knowledge of Functional Testing & Regression Testing
• Experience with Data Validation, Data Reconciliation & Data Quality Testing
• Understanding of ETL/ELT pipelines and data migration
• Experience in writing complex SQL queries, joins, subqueries and validations
• Knowledge of Source-to-Target Mapping (STTM) and ETL workflows
• Exposure to Defect Management & Test Case Design
• Familiarity with Agile/Scrum methodology and SDLC/STLC

Key Responsibilities

• Design and execute ETL, functional and regression test cases.
• Validate data accuracy, completeness and consistency across source and target systems.
• Perform backend testing using SQL and Snowflake.
• Identify data discrepancies, investigate root causes and track defects to closure.
• Validate ETL/ELT pipelines, transformations and business rules.
• Collaborate with Data Engineers, Developers and Business teams to ensure quality releases.