Join our Technology & Transformation: Engineering practice as a Senior Consultant specializing in ETL Testing. You will be instrumental in helping companies unlock the value hidden within their data. Our global network offers strategic guidance and implementation services to manage data from various sources, transforming it into actionable information for informed decision-making and gaining an insight-driven advantage. This role focuses on business intelligence, data management, performance management, and advanced analytics technologies including big data and cloud platforms.

Validate data integrity, consistency, and accuracy across diverse environments and systems using your database testing expertise. Develop and optimize complex SQL queries for data validation, transformation, and migration in both relational and non-relational databases. Automate data manipulation tasks for efficient handling of large datasets using Python or Java scripts. Leverage your AWS experience and pharmaceutical industry knowledge to drive impactful solutions. You will also be responsible for advanced data preprocessing, including cleansing, transformation, and aggregation, and developing/executing automated test scripts for scalable test automation.

This role requires 6-9 years of experience with a strong foundation in ETL concepts, data warehousing, Data Lakes, and UNIX. Proficiency in advanced SQL for complex data validation is essential. You should have hands-on experience with automation tools like Python (PyTest, Robot Framework, TestNG) and a solid understanding of data platforms such as Databricks, Snowflake, Redshift, BigQuery, or Synapse. Experience with ETL tools like Informatica, Ab Initio, Talend, DataStage, or DBT is expected, along with cloud exposure (AWS, Azure, or GCP) and CI/CD tools (Jenkins, Azure DevOps, GitHub Actions). Familiarity with data formats like Parquet, Avro, JSON, CSV, and XML is necessary.