Job Information

- Date Opened 10/15/2026
- Job Type Full time
- Industry IT Services
- Remote Job

This is a remote position.

Senior SSIS Developer – Job Description

Experience: 7–9 Years Primary 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 experience with 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.

- Solid ownership and accountability.

📌 Senior SSIS Developer (India)
🏢 ElfOnze Technologies
📍 India