Etl Test Lead

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 strong 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

Good 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

• Strong 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.