Cpw Etl Test Engineer I

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 Haagen-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 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 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