Senior Data Engineer - ETL/Python

Description :

- Analyze and debug SQL Server execution plans to optimize query performance and ensure efficient resource usage.

- Create, manage, and maintain indexes aligned with development cycles to improve database performance.

- Develop and maintain SQL Server database objects such as stored procedures, functions, triggers, and views for robust backend support.

- Design and implement highly optimized SQL queries to maintain consistent response times under varying load conditions.

- Convert raw data into structured and usable formats to support business reporting and analytics needs.

- Utilize SQL Server tools for query optimization, transaction handling, and performance tuning.

- Collaborate with development teams on web-based or desktop applications, contributing backend database expertise.

- Support and improve reporting solutions using SQL Server Reporting Services (SSRS), if applicable.

Qualifications :

- Experience in analyzing and debugging execution plans

- Experience in creating and managing indexs based on development cycles

- Strong development experience, preferably on web based applications, however a mix of desktop and web based applications is also acceptable

- A minimum industry experience of 3 years, with significant time spent in the relevant projects

- 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

- Experience in designing and implementing highly optimized queries for consistent response time, under a highly variable and fluctuating processing load

- Experience in converting raw data into usable formats, for reporting and business analytics

- Exposure and practical experience on SQL Server Reporting Services will be an considered an advantage

- Exposure to at least one NoSQL database such as Cosmos DB will be considered an advantage

- 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

- B.Tech./B.E./ M.Tech./BCA/MCA with first class (>60%) throughout in academics, from reputed institutions

- Familiarity with at least one or more source control tools like Github, or Subversion (SVN)

- Exposure and practical working experience on Agile methodology

- 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

Desired Qualifications :