IN_ Manager _ ETL Test Manager _Data and Analytics_Advisory_PAN India

<p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);">Job Description & Summary:</span></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-size:10pt;"> </span></p><div style="color:rgb(0,0,0);font-family:'Segoe UI';line-height:20px;">An ETL Test Manager is responsible for planning, managing, and overseeing ETL/Data Warehouse testing activities to ensure data accuracy, integrity, and quality across systems.<br />They lead test strategy development, test case design, defect management, and coordination with business and technical stakeholders.<br />The role involves validating data transformations, migrations, data pipelines, and ensuring compliance with project requirements and quality standards.<br />They also mentor testing teams, track project risks, and provide regular status updates to ensure successful delivery of data integration projects.</div><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="color:rgb(0,0,0);"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);">Job Position Title:</span></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><u><span style="color:rgb(0,0,0);"> </span></u></span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-size:10pt;"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;text-indent:0.5in;line-height:normal;"><span style="font-size:10pt;">IN_ Manager _ ETL Test Manager _Data and Analytics_Advisory_Mumbai</span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-size:10pt;"> </span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-size:10pt;"> </span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);">Responsibilities:</span></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);"> </span></span></p><p class="MsoListParagraphCxSpFirst" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Develop comprehensive test strategies, test plans, and estimates for complex data integration and migration projects.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Ensure accuracy of data transformations, aggregations, and business rules by analyzing complex SQL queries and mapping documents.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Manage and mentor onshore/offshore QA teams, delegate testing tasks, and conduct performance reviews.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Oversee the defect lifecycle, lead triage meetings, identify potential delivery risks, and enforce data quality standards.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Act as the primary liaison between business analysts, data engineers, and project stakeholders to ensure testing aligns with business</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes .</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">An understanding of big data engineering tools and how they can be used strategically (e.g. Spark, Hive, Hadoop, Dask).</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Demonstrated experience of working with automated testing tools.<br />Understanding of information governance principles and how they could apply in a testing capacity.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Demonstrated experience of automating tests across multiple platforms and technologies and understand its application throughout the full development lifecycle.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Knowledge of test case management packages.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Demonstrated experience of hands-on Issue and Defect Management.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Experience in testing systems that capture, verify, and maintain field generated metadata</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Familiarity with multiple back-end and front-end languages and libraries, databases, database design, web servers, web services, APIs, and UI/UX design.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Knowledge and experience with modern testing development practices and integrated testing products such as selenium, mocha and their integration with tools such as Gitlab, etc.</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Experience in working with a wide variety of technologies and on diverse problems .</span></p><p></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Experience of non-functional testing as well as backup and recovery, DR, performance,</span></p><p></p><p class="MsoListParagraphCxSpLast" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Experience of Agile Software Development & Testing methods for deployment in cloud environments.<br /><br /></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);">Mandatory skill sets:</span></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><u><span style="color:rgb(0,0,0);"> </span></u></span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><u><span style="color:rgb(0,0,0);"> </span></u></span></p><p class="MsoListParagraphCxSpFirst" style="margin:0px 0px 10px 1in;text-align:justify;text-indent:-0.25in;"><span style="font-size:10pt;line-height:15.3333px;font-family:Symbol;">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;line-height:16.8667px;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Test Management, ETL/Cloud Testing, SQL,</span></p><p></p><p class="MsoListParagraphCxSpLast" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="color:rgb(0,0,0);"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);">Preferred skill sets:</span></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);"> </span></span></p><p class="MsoListParagraph" style="margin:0in 0in 0in 1in;text-align:justify;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;color:rgb(0,0,0);">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:11pt;font-family:'Aptos Narrow', sans-serif;color:rgb(0,0,0);">Cloud Functions (AWS/Azure), Python</span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);">Years of experience required:</span></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);"> </span></span></p><p class="MsoListParagraph" style="margin:0px 0px 0in;text-align:justify;text-indent:-0.25in;line-height:normal;"><span style="font-size:10pt;font-family:Symbol;">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:10pt;">8- 12 years</span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="color:rgb(0,0,0);"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);">Education qualification:</span></span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="font-weight:bolder;"><span style="color:rgb(0,0,0);"> </span></span></p><p class="MsoListParagraph" style="margin:0px 0px 0in;text-align:justify;text-indent:-0.25in;line-height:normal;"><span style="font-size:10pt;font-family:Symbol;">·<span style="font-variant:normal;font-size:7pt;line-height:normal;font-family:'Times New Roman';"> </span></span><span style="font-size:10pt;">BE/ Btech/ Mtech/ MCA/ MBA (fulltime)</span></p><p></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"></p><p class="MsoNormal"></p><p></p><p> </p>