Consultant | ETL Testing | Chennai | Engineering | Quality Engineering

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft; Coimbatore District; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Deloitte Touche Tohmatsu India LLP is seeking a Senior QA ETL Automation Engineer in Chennai. The role focuses on building scalable automation for ETL testing using Python, PySpark, and Airflow, with strong SQL and data validation across data pipelines.

You will work with cross-functional teams, contribute to CI/CD, and mentor junior engineers. The ideal candidate has 4-6 years of hands-on ETL testing experience, proficiency in Python, SQL, and cloud platforms like Azure Databricks, and a solid

Qualifications

• BE / BTech is required.
• Strong automation testing experience with ETL.
• Hands-on Python programming and SQL skills.

Responsibilities

• Design, develop, and maintain automation frameworks for ETL testing.
• Analyze requirements and identify test scenarios suitable for automation.
• Hands-on experience with Azure Databricks is mandatory.
• Collaborate with product, dev, and QA teams to ensure data quality.
• Integrate and execute automation tests within CI/CD pipelines.
• Report, track, and validate defects and ensure quality standards.

Skills

ETL Automation

Python

SQL

CI/CD

Communication

Mentoring

Education

BE / BTech

Tools

Pyspark

Apache Airflow

Azure Databricks

Power BI

Git

CI/CD Tools

Job description

Consultant | ETL Testing | Chennai | Engineering | Quality Engineering
• Job requisition ID : 114233
• Location: Chennai
• Entity: Deloitte Touche Tohmatsu India LLP

The Team

Deloitte’s Technology & Transformation: EAD: Engineering practice can help you uncover and unlock the value buried deep inside vast amounts of data. Our global network provides strategic guidance and implementation services to help companies manage data from disparate sources and convert it into accurate, actionable information that can support fact-driven decision-making and generate an insight-driven advantage. Our practice addresses the continuum of opportunities in business intelligence & visualization, data management, performance management and next-generation analytics and technologies, including big data, cloud, cognitive and machine learning.

• We are looking for a highly skilled Senior QA ETL Automation Engineer with strong expertise in automation testing using Python framework.
• The ideal candidate should have hands‑on experience in modern ETL tools (Pyspark, Apache air flow), solid programming knowledge, and strong experience with databases and CI/CD pipelines.
• You will collaborate with cross-functional teams to build scalable automation solutions and ensure high-quality product delivery.Design, develop, and maintain automation frameworks for ETL testing
• Analyze requirements and identify test scenarios suitable for automation
• Hands on experience in cloud platforms - Azure, Data bricks
• Hands on Experience in Power BI
• Strong understanding of ETL processes, including data extraction, transformation, and loading.
• Proficiency in writing and optimizing complex SQL queries.
• Solid experience in validating data flows, transformations, and ensuring data integrity across systems.
• Collaborate with product, development, and QA teams
• Participate in test planning, estimation, and automation strategy
• Integrate and execute automation tests within CI/CD pipelines
• Report, track, and validate defects
• Ensure adherence to quality standards and best practices
• 4-6 years of experience
• Strong hands‑on experience in:
• End to end ETL testing
• Experience working with Azure Databricks (Mandatory)
• Proficiency in Python programming language:
• Strong hands‑on experience with SQL and database testing
• Hands‑on experience in CI/CD tools and pipeline integration, including:
• Strong experience with version control systems (Git)
• Experience in:
• Test case design and analysis
• Identifying test cases for automation
• Maintaining and optimizing automation scripts
• Good understanding of:
• Software Testing Life Cycle (STLC)
• Soft Skills:
• Strong communication and collaboration skills
• Ability to interact effectively with product and business stakeholders
• Excellent analytical and problem‑solving skills
• Ability to work independently and mentor junior team members

Nice to Have:

• Experience building automation frameworks from scratch
• Exposure to test reporting and monitoring tools

Qualifications:

• The candidate should have an educational background of BE / BTech