Senior Data Engineer - ETL/Python

<p><p><b>Description :</b><br/><br/>- Analyze and debug SQL Server execution plans to optimize query performance and ensure efficient resource usage.<br/><br/></p><p>- Create, manage, and maintain indexes aligned with development cycles to improve database performance.<br/><br/></p><p>- Develop and maintain SQL Server database objects such as stored procedures, functions, triggers, and views for robust backend support.<br/><br/></p><p>- Design and implement highly optimized SQL queries to maintain consistent response times under varying load conditions.<br/><br/></p><p>- Convert raw data into structured and usable formats to support business reporting and analytics needs.<br/><br/></p><p>- Utilize SQL Server tools for query optimization, transaction handling, and performance tuning.<br/><br/></p><p>- Collaborate with development teams on web-based or desktop applications, contributing backend database expertise.<br/><br/></p><p>- Support and improve reporting solutions using SQL Server Reporting Services (SSRS), if applicable.<br/><br/><b>Qualifications :</b><br/><br/></p><p>- Experience in analyzing and debugging execution plans<br/><br/></p><p>- Experience in creating and managing indexs based on development cycles<br/><br/></p><p>- Strong development experience, preferably on web based applications, however a mix of desktop and web based applications is also acceptable<br/><br/></p><p>- A minimum industry experience of 3 years, with significant time spent in the relevant projects<br/><br/></p><p>- Strong hands on skills on SQL Server 2012/2016/2019, including use of analyzing and debugging tools, query optimization, transaction handling, stored procedures, functions, triggers and views<br/><br/></p><p>- Experience in designing and implementing highly optimized queries for consistent response time, under a highly variable and fluctuating processing load<br/><br/></p><p>- Experience in converting raw data into usable formats, for reporting and business analytics<br/><br/></p><p>- Exposure and practical experience on SQL Server Reporting Services will be an considered an advantage<br/><br/></p><p>- Exposure to at least one NoSQL database such as Cosmos DB will be considered an advantage<br/><br/></p><p>- Exposure to applications hosted on one of the leading cloud hosting platforms (Microsoft Azure, Amazon AWS, Google Cloud), and having practical ideas towards designing solutions to minimize resource usage<br/><br/></p><p>- B.Tech./B.E./ M.Tech./BCA/MCA with first class (&gt;60%) throughout in academics, from reputed institutions<br/><br/></p><p>- Familiarity with at least one or more source control tools like Github, or Subversion (SVN)<br/><br/></p><p>- Exposure and practical working experience on Agile methodology<br/><br/></p><p>- The job requires some overlapping with the US based teams, so the candidate should be flexible to work in afternoon shift 1 PM 10 PM<br/><br/><b>Desired Qualifications :</b></p><p><p><b><br/></b></p>- Strong communication skills<br/></p><br/></p> (ref:hirist.tech)