Opening For Microsoft Sql Server Integration Services Developer

Tekskills; Hyderabad; On-site; INR 2,500,000 - 4,500,000; Full time

Job summary

Tekskills in Hyderabad is seeking a senior ETL lead to design and develop SSIS packages for data extraction, transformation, and loading. You will collaborate with business analysts, data architects, and stakeholders to ensure data requirements are met and delivered on time.

You will mentor a team of SSIS developers, enforce coding, testing, and deployment best practices, maintain ETL documentation, implement data quality checks, and participate in code reviews while coordinating with DBA and

Qualifications

• 8+ years of SSIS development and support.
• 4+ years DataStage experience in both support and development.
• Strong proficiency in SQL Server and T-SQL.
• Experience with data warehousing concepts and dimensional modeling.
• Familiarity with SSRS and SSAS is a plus.
• Excellent problem-solving and analytical skills.
• Strong communication and leadership abilities.
• Experience with Agile/Scrum methodologies is preferred.

Responsibilities

• Lead the design and development of SSIS packages for ETL.
• Collaborate with analysts, architects, and stakeholders to understand data requirements.
• Optimize and troubleshoot SSIS packages for performance and reliability.
• Manage and mentor a team of SSIS developers with technical guidance.
• Ensure adherence to coding, testing, and deployment best practices.
• 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 standards.
• Coordinate with DBA and infrastructure teams for deployment and maintenance.

Skills

SSIS development

DataStage

SQL Server/T-SQL

Data warehousing

SSRS/SSAS

Problem solving

Leadership

Agile/Scrum

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.