Opening For Microsoft Sql Server Integration Services Developer

Tekskills Inc.; Bengaluru; On-site; INR 2,500,000 - 3,900,000; Full time

Job summary

Tekskills Inc. in Bengaluru, India, is seeking a senior SSIS/DataStage Lead to design, develop, and optimize ETL pipelines. You will mentor a team of SSIS developers, collaborate with analysts and architects, and ensure best practices across the data integration lifecycle.

The role requires strong SQL Server/T-SQL skills, data warehousing knowledge, and familiarity with SSRS/SSAS. Agile/Scrum experience is preferred to drive delivery with quality and reliability.

Qualifications

• 8+ years of SSIS development and support experience.

Responsibilities

• Lead design and development of SSIS packages for ETL.
• Collaborate with business analysts, data architects, and stakeholders to understand data requirements.
• Optimize and troubleshoot existing SSIS packages for performance and reliability.
• Manage and mentor a team of SSIS developers, providing technical guidance and support.
• Ensure adherence to best practices in coding, testing, and deployment.
• Develop and maintain documentation for ETL processes and data flows.
• Implement data quality checks and validation mechanisms.
• Participate in code reviews and ensure compliance with organizational standards.
• Coordinate with DBA and infrastructure teams for deployment and maintenance.

Skills

Strong communication

Leadership abilities

Agile/Scrum experience

Problem-solving

Team mentorship

Tools

SSIS

DataStage

SQL Server

SSRS

SSAS

Job description

Lead the design and development of SSIS packages for data extraction, transformation, and loading (ETL).

Collaborate with business analysts, data architects, and stakeholders to understand data requirements.

Optimize and troubleshoot existing SSIS packages for performance and reliability.

Manage and mentor a team of SSIS developers, providing technical guidance and support.

Ensure adherence to best practices in coding, testing, and deployment.

Develop and maintain documentation for ETL processes and data flows.

Implement data quality checks and validation mechanisms.

Participate in code reviews and ensure compliance with organizational standards.

Coordinate with DBA and infrastructure teams for deployment and maintenance.

Required Skills & Qualifications:

8+ years of experience in SSIS development and support .

4 + years of DataStage experience both in Support and Development

Strong proficiency in SQL Server and T-SQL.

Experience with data warehousing concepts and dimensional modeling.

Familiarity with other Microsoft BI tools (SSRS, SSAS) is a plus.

Excellent problem-solving and analytical skills.

Strong communication and leadership abilities.

Experience with Agile/Scrum methodologies is preferred.