Join Deloitte's Technology & Transformation: EAD: Engineering practice and unlock the value within your data. We provide strategic guidance and implementation services to help companies manage data effectively, transforming it into actionable insights for informed decision-making. Our practice spans business intelligence, data management, performance management, and next-generation analytics, including big data, cloud, cognitive, and machine learning.

This role focuses on ETL Testing, leveraging your expertise to ensure data integrity and accuracy across complex systems.

Validate data integrity, consistency, and accuracy across diverse environments and systems. Write and optimize complex SQL queries for data validation, transformation, and migration in both relational and non-relational databases. Automate data manipulation tasks using Python or Java scripts for efficient handling of large datasets. Develop and execute automated test scripts in Python or Java to support scalable test automation. Design and maintain robust test automation frameworks specifically for database testing and ETL process validation.

Possess 6-9 years of experience in ETL/Data Testing, with a strong grasp of data warehousing, Data Lakes, and UNIX. Expertise in advanced SQL for complex data validation is essential. Proficiency in automation tools like Python, PyTest, Robot Framework, or TestNG is required. Hands-on experience with data platforms such as Databricks, Snowflake, Redshift, Big Query, or Synapse is necessary. Familiarity with ETL tools like Informatica, Ab Initio, Talend, DataStage, or DBT is also key. Experience with cloud environments (AWS, Azure, GCP) is mandatory, with at least one having hands-on application. Knowledge of CI/CD tools like Jenkins, Azure DevOps, or GitHub Actions is beneficial. Understanding of data formats like Parquet, Avro, JSON, CSV, and XML is expected. Experience with AWS is a must. Pharmaceutical industry expertise is a requirement.