Senior SSIS Developer

This is a remote position.

Senior SSIS Developer – Job Description

Experience:7–9 YearsPrimary Skill:SSIS (SQL Server Integration Services)Role:Senior SSIS Developer / Technical Consultant

Key Responsibilities

• Design, develop, test, deploy, and maintain SSIS packages for enterprise ETL and data integration.
• Develop ETL solutions to extract, transform, and load data from multiple source systems.
• Support and enhance existing SSIS interfaces and integrations.
• Troubleshoot SSIS package failures, data issues, and production incidents.
• Develop and optimize complex SQL queries, stored procedures, functions, views, and database objects.
• Integrate data from SQL Server, Oracle, flat files, CSV/Excel files, and SFTP locations.
• Implement error handling, logging, auditing, notifications, and restart/recovery mechanisms.
• Schedule and monitor SSIS jobs using SQL Server Agent.
• Perform SSIS package and SQL query performance tuning for high-volume data processing.
• Conduct impact analysis, effort estimation, code reviews, and technical documentation.
• Support deployments across development, UAT, and production environments.
• Provide L2/L3 production support, root-cause analysis, and permanent fixes for recurring issues.
• Collaborate with functional teams, application teams, DBAs, and business stakeholders.
• Mentor junior developers and provide technical guidance when required.

Mandatory Technical Skills

• 7–9 years of overall IT experiencewith strong hands-on expertise in SSIS and SQL Server.
• Strong experience in ETL development, data integration, and data migration.
• Advanced knowledge of T-SQL and Microsoft SQL Server.
• Experience with stored procedures, functions, views, joins, indexing, query optimization, and performance tuning.

Hands-on experience with SSIS components

• Data Flow Tasks and Control Flow Tasks
• Lookup, Merge, and Conditional Split
• Derived Column and Execute SQL Task
• Script Task and File System Task
• Knowledge of SSIS configurations, parameters, variables, connection managers, and deployment models.
• Experience implementing logging, exception handling, audit controls, and failure/restart mechanisms.
• Experience with SQL Server Agent jobs and scheduling.
• Strong troubleshooting, root-cause analysis, and production support experience.

Preferred Skills

• SSIS integration with Oracle and heterogeneous data sources.
• SFTP and automated file-based integrations.
• Git, Azure DevOps, or other source-control and CI/CD tools.
• Exposure to Azure Data Factory (ADF).
• Agile/Scrum delivery experience.
• Knowledge of ITIL processes, including Incident, Problem, and Change Management.

Soft Skills

• Strong analytical and problem-solving skills.
• Good verbal and written communication.
• Ability to independently resolve complex technical and production issues.
• Effective coordination with technical, functional, business, and client teams.
• Strong ownership and accountability.