Join Deloitte's Technology & Transformation: Engineering practice as a Senior Consultant specializing in ETL Testing. This role is critical in helping organizations unlock the potential of their data. You will be instrumental in managing data from various sources and transforming it into actionable insights that drive informed decision-making.

Our practice focuses on business intelligence, data management, performance management, and advanced analytics, including big data, cloud, and machine learning technologies. Contribute to a team that thrives on innovation and leverages cutting-edge solutions.

Validate data integrity, consistency, and accuracy across diverse environments and systems through expert database testing.

Develop and optimize advanced SQL queries for comprehensive data validation, transformation, and migration in both relational and non-relational databases.

Automate data manipulation tasks using custom Python or Java scripts, ensuring efficient handling and preparation of large datasets.

Leverage your expertise in AWS and pharmaceutical industry knowledge to address project requirements.

Implement advanced data preprocessing techniques, including data cleansing, transformation, and aggregation.

Design, develop, and execute automated test scripts using Python or Java to support scalable and efficient test automation processes.

Build and maintain robust test automation frameworks tailored for database testing and ETL process validation.

A minimum of 6-9 years of experience in ETL and Data Testing is required, demonstrating a strong understanding of ETL concepts, data warehousing, data lakes, and UNIX.

Proficiency in automation tools and languages such as Python, PyTest, Robot Framework, or TestNG is essential.

Advanced SQL skills are necessary for complex data validation scenarios.

Experience with data platforms like Databricks, Snowflake, Redshift, Big Query, or Synapse is expected.

Familiarity with ETL tools including Informatica, Ab Initio, Talend, DataStage, or DBT is required.

Hands-on experience with at least one cloud platform (AWS, Azure, GCP) is a must.

Knowledge of CI/CD tools like Jenkins, Azure DevOps, or GitHub Actions is beneficial.

Understanding of various data formats such as Parquet, Avro, JSON, CSV, and XML is needed.

Candidates with experience in Great Expectations, Deequ, Soda, or Monte Carlo will have an added advantage.