CPW ETL Test Engineer I

Job Description

Position Title ETL Test Engineer Function/Group CMI(Consumer & Market Insights) Location Mumbai Shift Timing 11 AM ? 8 PM Role Reports to Manager Remote/Hybrid/in-Office Hybrid About General Mills We make food the world loves: 100 brands. In 100 countries. Across six continents. With iconic brands like Cheerios, Pillsbury, Betty Crocker, Nature Valley, and H?agen-Dazs, we?ve been serving up food the world loves for 155 years (and counting). Each of our brands has a unique story to tell. How we make our food is as important as the food we make. Our values are baked into our legacy and continue to accelerate us into the future as an innovative force for good. General Mills was founded in 1866 when Cadwallader Washburn boldly bought the largest flour mill west of the Mississippi. That pioneering spirit lives on today through our leadership team who upholds a vision of relentless innovation while being a force for good.For more details check out http://www.generalmills.com General Mills India Center is our global capability center in Mumbai that works as an extension of our global organization delivering business value, service excellence and growth, while standing for good for our planet and people. With our team of 1800+ professionals, we deliver superior value across the areas of supply chain, digital & technology, innovation, technology & quality, consumer & market intelligence, sales strategy & intelligence, global shared services, finance shared services and Human Resources Shared Services.For more details check out https://www.generalmills.co.in CPW ETL Test Engineer I CPW is the joint venture of Nestle and General Mills. CPW, Data Engineering team at CMI works on harmonization of data across 52+ markets to produce one consolidated Global data warehouse hosted on MS Azure which is used for Global performance evaluation of our brands & track the competitive space, build Analytical solutions and share insights on Business Performances across the Globe. We are looking for an experienced ETL Test Engineer to join our data engineering team with good data handling, problem solving and communication skills. This role is critical to ensuring the accuracy, consistency, and reliability of datasets published by our engineers. The candidate will be responsible for validating datasets, monthly data harmonization outputs, and ensuring alignment with business requirements. Job Overview Validate the datasets published by the Data engineering team. Validate monthly harmonization processes and outputs. Lead data enhancements initiatives for mapping and harmonization Understand requests from business teams and translate them into testing scenarios. Functionally and technically validate ETL processes and outputs against business rules. Write complex SQL + Python queries to validate transformations, aggregations, and reconciliations. Use advanced Excel skills for data validation and analysis. Document test results, raise defects, and track resolutions effectively. To Be Successful, This Individual Must Demonstrate The Following Pragmatic and solution driven mindset Learning agility to understand data from a business lens Strong technical and conceptual skillset on ETL and Data Wrangling Effective Team player Required Qualifications Minimum 5+ years of hands-on experience in ETL / Data Warehouse testing Must have basic experience on Azure Cloud Strong SQL (non-negotiable), Python & Excel skills with proven ability to write complex queries Strong understanding of data flows, ETL processes, and data validation techniques Ability to interpret business requirements and translate them into functional and technical test cases. Good communication in articulating the defects clearly documenting the required evidence and to re-test the issues until closure Strong attention to detail, problem-solving, and analytical skills Great communication skills - speaks, reads and writes English fluently Prior experience working with variety of data sources - FMCG preferred Experience in Azure Databricks is a plus