ETL Testing (Contract)

Saaki Argus And Averil Consulting; Chennai; On-site; INR 600,000 - 1,000,000; Full time

Job summary

Saaki Argus And Averil Consulting seeks an experienced ETL Test Engineer in Chennai to validate data pipelines, ingestion and transformation processes, and ensure data quality. The role emphasizes SQL-driven validation, Python scripting, and automation within a GxP-regulated environment.

Ideal candidates will have hands-on experience with Snowflake, Fivetran, and dbt, and understand CI/CD practices as they apply to data testing workflows.

Qualifications

• Hands-on ETL testing experience in data warehousing environments.
• Strong SQL skills with complex queries for data validation and reconciliation.
• Proficiency in Python scripting for data validation and test automation.

Responsibilities

• Perform ETL testing across extraction, transformation, loading, and data validation.
• Develop and execute ETL test scenarios covering data completeness and accuracy.
• Create and maintain automated test solutions and frameworks for data pipelines.

Skills

ETL Testing

SQL

Python scripting

Test Automation

Data Warehousing

CI/CD

Data validation

GxP compliance

Tools

Snowflake

Fivetran

dbt

Job description

We are looking for an experienced ETL Test Engineer with strong expertise in ETL testing, SQL, Python scripting, and test automation. The candidate will be responsible for validating data pipelines, data ingestion and transformation processes, ensuring data quality and integrity, and developing/maintaining automated test solutions. The ideal candidate should have hands-on experience with modern data platforms and orchestration/ingestion tools such as Fivetran, Snowflake, and dbt, along with a good understanding of CI/CD practices. Experience working in a GxP-regulated environment.Key Responsibilities : Perform ETL testing across data extraction, transformation, loading, and data validation processes. Develop and execute comprehensive ETL test scenarios and test cases covering data completeness, accuracy, consistency, integrity, and transformation logic. Perform complex SQL queries for source-to-target data validation and reconciliation. Develop and maintain Python scripts for data validation, test automation, and ETL testing activities. Contribute to and maintain test automation frameworks for data and ETL testing. Validate data pipelines and workflows involving data ingestion, transformation, and orchestration. Work with modern data technologies such as Fivetran, Snowflake, and dbt. Perform source-to-target validation, record count validation, data type validation, duplicate checks Support integration of automated tests into CI/CD pipelines. Participate in defect management, test reporting, and quality governance activities. Ensure testing activities comply with applicable GxP standards.Mandatory Skills : 68 years of hands-on ETL Testing experience Strong knowledge of ETL concepts and data warehousing Strong SQL skills, including complex queries for data validation and reconciliation Strong Python scripting skills Must Have Experience with test automation frameworks Hands-on or good working knowledge of Snowflake Knowledge of data ingestion/orchestration tools such as Fivetran and dbt Strong understanding of data validation and ETL testing scenarios Understanding of CI/CD pipelines and DevOps practices Good analytical and problem-solving skills Python scripting is a mandatory skill for this position.