Analyst | ETL Testing | Pune | Engineering | Quality Engineering

- Job requisition ID : 107655
- Location: Pune
- Entity: Deloitte Touche Tohmatsu India LLP

The Team

Deloitte’s Technology & Transformation 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.

Your work profile

- Design and implement automated test frameworks for ETL / ELT pipelines.
- Validate source-to-target data reconciliation, transformation logic, and business rules.
- Develop automated test scripts for data completeness, accuracy, timeliness, and integrity checks.
- Perform database, file, and API level testing across structured and semi-structured data.




- Create reusable automation components for row counts, checksum validation, null checks, and referential integrity.
- Execute regression, integration, and system testing for data pipelines.
- Analyze test failures, identify root causes, and work closely with data engineers to resolve issues.
- Validate incremental loads, CDC logic, and historical data migrations.
- Integrate automation tests with CI/CD pipelines.
- Prepare test plans, test cases, defect reports, and execution summaries.

Key skills required

- Exp: 2-3 years
ETL Tools
- - Informatica IICS, Talend, DataStage, Ab Initio
Cloud ETL
- - Azure Data Factory, AWS Glue, S3 Bucket, Lambda, GCP
Data Platforms
- - Snowflake, Databricks, Amazon Redshift, Big query
Data Quality
- - Outstanding Expectations, Soda Core, dbt tests
Programming
- - Python, PySpark, PyTest, UNIX
Scheduling
- - Airflow
Database
- - SQL Server, Oracle, PostgreSQL, Hive, Hadoop

Education

- Bachelor’s degree in computer science, Information Technology, or related field.

📌 Analyst | ETL Testing | Pune | Engineering | Quality Engineering (India)
🏢 Deloitte
📍 India