IN_ Senior Associate _ ETL Test Engineer _Data and Analytics_Advisory_Pune

<div class="title" style="margin:0px;padding:1.5rem 1.5rem 0px;font-size:1.2rem;font-weight:600;">Job Description</div><div class="jd" style="margin:0px;font-size:16px;padding:1rem 1.5rem 1.5rem;"><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;color:rgb(0,0,0);">Job Description & Summary:</span></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-size:10pt;"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-size:10pt;">We are seeking an experienced Test engineer specializing in autonomous <span style="font-family:'Aptos Narrow', sans-serif;margin:0px;color:rgb(0,0,0);font-size:14.6667px;text-indent:-24px;">SQL queries and ETL</span> to join our team. The ideal candidate will help design, develop, and optimize agents that can perform complex tasks autonomously while maintaining reliability and safety.</span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;color:rgb(0,0,0);"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;color:rgb(0,0,0);">Job Position Title:</span></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><u style="margin:0px;"><span style="margin:0px;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="margin:0px;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="margin:0px;font-size:10pt;">IN_ Senior assoicate _ ETL Test _Data and Analytics_Advisory_Mumbai</span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-size:10pt;"> </span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-size:10pt;"> </span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;color:rgb(0,0,0);">Responsibilities:</span></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;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;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Develop comprehensive test strategies, test plans, and estimates for complex data integration and migration projects.</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;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 style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Manage and mentor onshore/offshore QA teams, delegate testing tasks, and conduct performance reviews.</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Oversee the defect lifecycle, lead triage meetings, identify potential delivery risks, and enforce data quality standards.</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;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 style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Experience in testing data validation scenarios and Data ingestion, pipelines, and transformation processes .</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;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 style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Demonstrated experience of working with automated testing tools.<br style="font-family:DarwinSans, 'Noto Sans Variable';margin:0px;" />Understanding of information governance principles and how they could apply in a testing capacity.</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;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 style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Knowledge of test case management packages.</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Demonstrated experience of hands-on Issue and Defect Management.</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Experience in testing systems that capture, verify, and maintain field generated metadata</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;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 style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;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 style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Experience in working with a wide variety of technologies and on diverse problems .</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpMiddle" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Experience of non-functional testing as well as backup and recovery, DR, performance,</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpLast" style="margin:0px 0px 0in;text-indent:-0.25in;line-height:normal;"><span style="font-family:Symbol;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Experience of Agile Software Development & Testing methods for deployment in cloud environments.<br style="font-family:DarwinSans, 'Noto Sans Variable';margin:0px;" /><br style="font-family:DarwinSans, 'Noto Sans Variable';margin:0px;" /></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;color:rgb(0,0,0);">Mandatory skill sets:</span></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><br style="margin:0px;" /></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><br style="margin:0px;" /></p><p class="MsoListParagraphCxSpFirst" style="margin:0px 0px 0px 1in;text-align:justify;text-indent:-0.25in;"><span style="font-family:Symbol;margin:0px;font-size:10pt;line-height:15.3333px;">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;line-height:16.8667px;color:rgb(0,0,0);">Test Management, ETL/Cloud Testing, SQL,</span></p><p style="margin:0px;"></p><p class="MsoListParagraphCxSpLast" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;color:rgb(0,0,0);"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;color:rgb(0,0,0);">Preferred skill sets:</span></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;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;margin:0px;color:rgb(0,0,0);">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="font-family:'Aptos Narrow', sans-serif;margin:0px;font-size:11pt;color:rgb(0,0,0);">Cloud Functions (AWS/Azure), Python</span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;color:rgb(0,0,0);">Years of experience required:</span></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;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-family:Symbol;margin:0px;font-size:10pt;">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="margin:0px;font-size:10pt;">4-6 years</span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;color:rgb(0,0,0);"> </span></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;color:rgb(0,0,0);">Education qualification:</span></span></p><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"><span style="margin:0px;font-weight:bolder;"><span style="margin:0px;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-family:Symbol;margin:0px;font-size:10pt;">·<span style="font-family:'Times New Roman';margin:0px;font-variant:normal;font-size:7pt;line-height:normal;"> </span></span><span style="margin:0px;font-size:10pt;">BE/ Btech/ Mtech/ MCA/ MBA (fulltime)</span></p><div><span style="margin:0px;font-size:10pt;"><br /></span></div><p style="margin:0px;"></p><p class="MsoNormal" style="margin:0px 0px 0in;text-align:justify;line-height:normal;"></p><p class="MsoNormal" style="margin:0px;"></p></div>