Consultant | ETL Testing | Chennai | Engineering | Quality Engineering

Deloitte & Touche GmbH Wirtschaftsprüfungsgesellschaft; Chennai District; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Deloitte Touche Tohmatsu India LLP in Chennai seeks a Senior QA ETL Automation Engineer to design and maintain automation for end-to-end ETL testing. You will implement PySpark and Airflow-based pipelines, validate data integrity, and collaborate with cross-functional teams to ensure quality.

The role requires 3–7 years of hands-on experience with ETL tools, Azure Databricks, Python, and SQL, plus CI/CD integration and strong communication skills.

Qualifications

• BE / BTech degree is required.
• 3–7 years of ETL testing experience.
• Hands-on experience with end-to-end ETL testing.
• Strong knowledge of Python and SQL for data validation.
• Experience with CI/CD pipelines and Git.
• Experience with Azure Databricks and PySpark.
• Familiarity with Power BI and data visualization.
• Excellent communication and collaboration skills.

Responsibilities

• 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 Databricks (Mandatory).
• Proficiency in Python programming language and SQL.
• Integrate and execute automation tests within CI/CD pipelines.
• Report, track, and validate defects; adhere to quality standards.
• Collaborate with product, development, and QA teams; mentor juniors.
• Participate in test planning, estimation, and automation strategy.

Skills

ETL Testing

Python

Azure Databricks

SQL

CI/CD

Git

Power BI

PySpark

Apache Airflow

Automation Frameworks

Education

BE / BTech

Tools

Git

CI/CD pipelines

Power BI

Azure Databricks

Apache Airflow

Job description

Select how often (in days) to receive an alert:

Job Title: Consultant | ETL Testing | Chennai | Engineering | Quality Engineering

Consultant | ETL Testing | Chennai | Engineering | Quality Engineering

• Job requisition ID : 112017
• 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
• 3-7 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