Etl Test Lead

Role & responsibilities

We are seeking a highly skilled ETL Data Automation Engineer with strong expertise in ETL Testing, Data Automation, Snowflake, Python, and PyTest. The ideal candidate will be responsible for validating complex data pipelines, building automation frameworks, ensuring data quality, and supporting cloud-based data warehouse testing initiatives. This role requires strong analytical, SQL, and automation skills along with experience in large-scale data migration and transformation projects.

Key Responsibilities

• Design and execute ETL and Data Warehouse testing strategies.
• Validate data extraction, transformation, and loading processes across multiple systems.
• Develop and maintain automation frameworks using Python and PyTest.
• Perform Snowflake data validation, reconciliation, and transformation testing.
• Create automated scripts for data quality checks and regression testing.
• Analyze source-to-target mapping documents and business requirements.
• Write complex SQL queries for backend data validation.
• Identify, track, and resolve defects throughout the testing lifecycle.
• Work closely with Data Engineers, Business Analysts, and Development teams.
• Support CI/CD implementations for test automation.

Mandatory Skills

• ETL Testing
• Data Automation Testing
• Snowflake
• Python
• PyTest
• SQL
• Data Warehouse Testing
• Data Validation
• Backend Testing
• Agile Methodology

Good to Have

• Cloud platforms (AWS/Azure/GCP)
• Airflow
• DBT
• Informatica
• Talend
• Azure Data Factory (ADF)
• CI/CD Tools
• Git/GitHub
• API Testing

Preferred Candidate Profile

• Strong experience in ETL/Data Warehouse Testing.
• Hands-on experience with Snowflake data validation.
• Expertise in Python scripting and PyTest framework.
• Experience working on data migration and transformation projects.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management skills.