Job Title:  Senior Consultant | ETL Testing | Bengaluru | Engineering | Quality Engineering

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.

Your work profile:

• Experience in database testing, with expertise in validating data integrity, consistency, and accuracy across multiple environments and systems
• Proven expertise in writing and optimizing complex SQL queries for data validation, transformation, and migration in both relational and non-relational databases
• Proficient in automating data manipulation tasks with custom Python or Java scripts for efficient handling and preparation of large datasets
• Experience with AWS is a must
• Pharmaceutical industry expertise is required
• Advanced knowledge of data preprocessing techniques (data cleansing, transformation, and aggregation)
• Extensive experience in developing and executing automated test scripts using Python or Java to support efficient and scalable test automation
• Strong experience in designing and maintaining test automation frameworks focused on database testing and ETL process validation

Key skills required:

• 6-9 years of experience
• ETL / Data Testing: Strong understanding of ETL concepts, data warehousing, Data lakes and UNIX.
• Automation: Python / PyTest / Robot Framework / TestNG
• SQL: Advanced SQL for complex data validation
• Data Platforms: Databricks, Snowflake, Redshift, Big Query, Synapse
• ETL Tools: Informatica, Ab Initio, Talend, DataStage, DBT (any)
• Cloud: AWS / Azure / GCP (hands-on experience with at least one)
• CI/CD: Jenkins, Azure DevOps, GitHub Actions
• Data Formats: Parquet, Avro, JSON, CSV, XML
• Bonus: Great Expectations, Deequ, Soda, Monte Carlo

Qualifications:

• B. E. / B. Tech / MCA / M.E / M. Tech / MSc in Computer Science.