Data Integration Support Engineer (L2 / L3)Position Title : Data Integration Support Engineer (L2 / L3)
Location : Hyderabad
JD : Data Integration Support Engineer (L2 / L3)
Position Title : Data Integration Support Engineer (L2 / L3)
Experience : 1–4years, Mid-level and Senior
Work Hours : Job Summary
We are seeking a skilled SSIS Support Engineer to monitor, troubleshoot, and maintain SSIS packages in our production and development environments. The role requires strong problem-solving skills, experience with SQL Server, and the ability to analyze and resolve ETL-related issues promptly.
Responsibilities
- Monitor SSIS package executions and troubleshoot failures
- Perform root cause analysis for recurring ETL failures or data issues
- Manage SQL Server Agent jobs and ensure SLAs are met
- Handle support tickets, incident reporting, and communication with business / data teams
- Validate data loads, check data integrity, and perform data reconciliations
- Coordinate with development teams for bug fixes and enhancements
- Maintain logging, alerts, and email notifications in SSIS packages
- Support deployments and configuration management across Lookup environments
Required Skills
3+ years hands-on experience with SSIS development / supportStrong T-SQL scripting and debugging skillsFamiliar with various SSIS components like Script Task, , Merge Join, Conditional Split, etc.Proficient in debugging SSIS packages and reading execution logsExperience in handling flat files, Excel, Oracle, APIs, and other data sourcesGood understanding of error handling and event logging in SSISExperience with job scheduling using SQL Server Agent or similar toolsExposure to ticketing tools (e.g., Jira, ServiceNow)Nice to Have
Knowledge of version control (Git, TFS)Familiarity with PowerShell scriptingExperience with SSRS or SSASUnderstanding of Azure Data Factory (ADF)