Job Description

Title: Data engineer
Location: Pune
:

• Understand the business need, develop solutions, Support production systems and

monitoring.

• Proficient in Microsoft BI tool stack and SQL server programming
• Perform root cause analysis on production issues, using data to diagnose bottlenecks and

inefficiencies

• Refine and automate regular processes, track issues, and document changes.
• Requirements Gathering and Analysis for changes in ETL, support and performance

improvements

• Configure and maintain database servers and processes, including monitoring daily

schedule jobs, monitoring of system health and performance, to ensure high levels of
performance, availability, and security.

• Responsible for handling tier 3 support tickets and providing resolution within defined

service level agreements

• Writing ETL jobs to download different types of data from Oracle to SQL Server Data Marts

to support newer or existing reports

• Implemented SSIS package configurations (Environment Variable and SQL Server)
• Designed and Developed reports based on requirements using SQL Server Reporting

Services (SSRS) and deployed them. Extensively worked on cross-tabbed and Matrix
reports using SSRS.

• Experience in working on Azure Services like Azure Data Factory, Azure Data Lake(Good

to have)

• Must have skill sets in writing complex SQL and PLSQL programs and proficient in

performance tuning

• Ontime Coordination and Status Reporting to the client.
• Good communication skills, with the ability to convey technical concepts to both technical

and non-technical customers.

• Ability to work independently work within a team environment.