Teamware Solutions

We are hiring Senior SSIS Developer
Experience: 7-9Years
Mode: Hybrid
Location: Bangalore
Notice Period: Immediate to 15 Days
**Primary Skill:** SSIS (SQL Server Integration Services)
**Role:** Senior SSIS Developer / Technical Consultant
## Role Summary
We are looking for an experienced **SSIS Developer with 7–9 years of hands-on
experience** in designing, developing, enhancing, and supporting enterprise data
integration solutions using Microsoft SQL Server Integration Services (SSIS).
The candidate should have strong expertise in **ETL development, SQL Server, data
integration, performance optimization, troubleshooting, and production support**. The
resource will be responsible for supporting existing SSIS interfaces as well as developing
and implementing enhancements based on business requirements.
## Key Responsibilities
<ul>
<li>Design, develop, test, deploy, and maintain **SSIS packages** for enterprise data</li>
</ul>
integration and ETL requirements.
<ul>
<li>Develop ETL solutions to extract data from various source systems, transform the data</li>
</ul>
based on business requirements, and load it into target systems.
<ul>
<li>Support and enhance existing **SSIS-based interfaces and integrations**.
</li>
<li>Analyze and troubleshoot SSIS package failures, data issues, performance issues, and
</li>
</ul>
production incidents.
<ul>
<li>Develop and optimize complex **SQL queries, stored procedures, functions, views, and</li>
</ul>
database objects**.
<ul>
<li>Work with different data sources such as **SQL Server, Oracle, flat files, CSV/Excel files,</li>
</ul>
SFTP locations, and other enterprise systems**.
<ul>
<li>Implement appropriate **error handling, logging, auditing, restart/recovery, and</li>
</ul>
notification mechanisms** within SSIS packages.
<ul>
<li>Schedule, monitor, and troubleshoot SSIS jobs using **SQL Server Agent** or equivalent</li>
</ul>
enterprise scheduling tools.
<ul>
<li>Perform performance tuning and optimization of SSIS packages and SQL queries for highvolume data processing.
</li>
<li>Perform impact analysis and provide technical estimates for enhancements and change
</li>
</ul>
requests.
<ul>
<li>Participate in code reviews and ensure adherence to development standards and best</li>
</ul>
practices.
<ul>
<li>Support deployments across development, test/UAT, and production environments.
</li>
<li>Monitor scheduled interfaces and proactively identify and resolve integration failures.
</li>
<li>Provide **L2/L3 production support**, perform root-cause analysis, and implement
</li>
</ul>
permanent fixes for recurring issues.
<ul>
<li>Work closely with functional teams, application teams, database administrators, and</li>
</ul>
business stakeholders to resolve integration issues.
<ul>
<li>Prepare and maintain technical documentation, deployment documents, support</li>
</ul>
procedures, and knowledge-transfer materials.
<ul>
<li>Mentor junior team members and provide technical guidance when required.</li>
</ul>
<h2>Required Technical Skills</h2>
**7–9 years of overall IT experience**, with strong hands-on experience in SSIS and
Microsoft SQL Server technologies.
<ul>
<li>Strong expertise in **SQL Server Integration Services (SSIS)**.
</li>
<li>Strong knowledge of **ETL concepts, data integration, data transformation, and data
</li>
</ul>
migration**.
<ul>
<li>Advanced knowledge of **T-SQL and Microsoft SQL Server**.
</li>
<li>Experience with stored procedures, functions, views, joins, indexing, query optimization,
</li>
</ul>
and performance tuning.
<ul>
<li>Experience with SSIS components such as **Data Flow Tasks, Control Flow Tasks,</li>
</ul>
Lookup, Merge, Conditional Split, Derived Column, Execute SQL Task, Script Task, and File
System Task**.
<ul>
<li>Good understanding of SSIS package configurations, parameters, variables, connection</li>
</ul>
managers, and deployment models.
<ul>
<li>Experience in implementing **logging, exception handling, audit controls, and</li>
</ul>
failure/restart mechanisms**.
<ul>
<li>Experience with **SQL Server Agent jobs and scheduling**.
</li>
<li>Strong troubleshooting and root-cause analysis skills.
</li>
<li>Experience working in **production support and application maintenance
</li>
</ul>
environments**.
## Preferred Skills
<ul>
<li>Experience integrating SSIS with **Oracle databases and other heterogeneous data</li>
</ul>
sources**.
<ul>
<li>Knowledge of **SFTP/file-based integrations** and automated file processing.
</li>
<li>Experience with **Git, Azure DevOps, or other source-control/CI/CD tools**.
</li>
<li>Exposure to cloud-based data integration technologies, particularly **Azure Data Factory
</li>
</ul>
(ADF)**, would be an advantage.
<ul>
<li>Experience working in an **Agile/Scrum delivery model**.
</li>
<li>Familiarity with ITIL processes such as Incident, Problem, and Change Management.
</li>
</ul>
## Soft Skills
<ul>
<li>Strong analytical and problem-solving capabilities.
</li>
<li>Good verbal and written communication skills.
</li>
<li>Ability to independently analyze and resolve complex production issues.
</li>
<li>Ability to coordinate effectively with business, functional, technical, and client teams.
</li>
<li>Strong ownership and accountability for assigned deliverables.
</li>
<li>Ability to work effectively in an application support and enhancement environment.
</li>
</ul>

Senior SSIS Developer

Senior SSIS Developer

This job is no longer available

Talents

Recruiters

About