The role involves monitoring , troubleshooting and maintain SSIS packages and ETL (Extract , Transform , Load ) workflows that are critical to business operations .

The ideal candidate should have strong debugging skills , a proactive attitude, and the ability to work on incident management under pressure .

Key Responsibilities :

Monitor production SSIS jobs and ETL pipelines to ensure timely completion .
Investigate , troubleshoot, and resolve issues related to SSIS package .
Provide L3 support by analyzing logs, debugging SQL queries, and identifying root causes.
Proactive approach to resolve all the incidents within SLA
On-call support is required for production incident.
Perform impact analysis and recovery actions for failed jobs.
Coordinate with development and other feature teams for bug fixes and enhancements when required .
Maintain and update job schedules , error handling and retry mechanisms.
Create and update Knowledge Base (KB) articles for common SSIS issues .
Support incident management (Priority ticket handling ) and participate in post-incident reviews .
Ensure adherence to SLAs and escalation protocols.
Suggest automation opportunities to reduce manual monitoring efforts .
Basic knowledge of project management tool . (Jira )

Required Skills :

Strong understanding of SSIS architecture and package execution flow.
Proficient in SQL server ability to debug queries and stored procedures .
Experience in job scheduling
Good understanding of ETL error handling and logging best practices .

More Jobs at Zentek Infosoft

Scala Developer

Hyderabad, Bengaluru

3 - 8 yrs

INR 10 - 20 Lacs

c# Developer

Hyderabad, Pune, Bengaluru

5 - 9 yrs

INR 7 - 10 Lacs

Staff Augmentation Developer

Hyderabad, Chennai, Mumbai (All Areas)

6 - 9 yrs

INR 9 - 13 Lacs

Test Manager

Hyderabad

10 - 17 yrs

INR 15 - 27 Lacs

Scala Developer

Hyderabad, Bengaluru

7 - 9 yrs

INR 6 - 13 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.