Job Title: ETL Test Engineer (ETL Data Automation)
Experience: 4 to 10 Years
Location: Chennai / Pune / Bangalore

Job Summary

We are seeking an experienced ETL Test Engineer with solid expertise in ETL/Data Warehouse Testing, Python automation, and SQL. The ideal candidate should have experience validating complex data pipelines, performing data quality checks, and automating ETL testing processes. Experience with cloud data platforms such as Snowflake, Databricks, AWS, or Azure is highly preferred. Relevant internal profiles and requirements reference ETL Testing, Python, SQL, Snowflake, and ETL automation skills.

Mandatory Skills
ETL Testing
Python Automation
Advanced SQL
Data Warehouse Testing
Data Validation & Data Reconciliation
Unix/Linux Commands
ETL Tools (Informatica, DataStage, SSIS, etc.)
Agile Methodology
JIRA

Positive to Have
Snowflake
Databricks
AWS / Azure
Big Data Testing
PyTest
GenRocket / QuerySurge

Roles & Responsibilities




Validate source-to-target data mappings and ETL transformations.
Develop Python automation scripts for ETL testing and data validation.
Create and execute test cases for data migration, ETL workflows, and data warehouses.
Perform backend database validation using SQL queries.
Validate data quality, completeness, accuracy, and integrity.
Analyze ETL job failures and support defect resolution.
Work with business analysts, developers, and data engineers.
Prepare test reports, metrics, and defect summaries.

Required Qualifications
Solid experience in ETL/Data Warehouse Testing.
Hands-on experience with Python and SQL.
Experience in validating large volumes of data.
Knowledge of ETL tools and cloud data platforms.
Good understanding of SDLC/STLC and Agile processes.
Excellent analytical and problem-solving skills.

📌 Etl Test Lead Pune (India)
🏢 Hexaware Technologies
📍 India