Sis Support & Production Debugging

Job Description:
Ability to support and troubleshoot SSIS packages in production environments
Hands-on experience with:
Debugging failed jobs and package executions
Analyzing logs (SSISDB catalog, SQL Agent history, custom logging)
Fixing issues related to:
Data flow failures (data type mismatches, truncation errors)
Connection issues (OLE DB, flat files, APIs)
Performance bottlenecks in ETL pipelines
Experience with:
Restartability and checkpoint configuration
Handling partial loads and data consistency issues
Ability to quickly triage production incidents and restore ETL workflows
Familiarity with deployment models (Project Deployment Model / SSISDB)