SSIS Production Support -Module Lead at Sopra Steria

Noida, Uttar Pradesh, India -

Full Time

Start Date

Immediate

Expiry Date

31 Aug, 26

Salary

0.0

Posted On

02 Jun, 26

Experience

5 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SSIS, ETL, SQL Programming, Query Optimization, Performance Tuning, Microsoft SQL Server, Data Warehousing, Dimensional Modelling, Data Governance, Data Quality, Production Support, Stakeholder Management, Root Cause Analysis, Technical Troubleshooting, Team Leadership, System Documentation

Industry

Information Technology & Services

Description

Company Description About Sopra Steria Sopra Steria, a major Tech player in Europe with 51,000 employees in nearly 30 countries, is recognised for its consulting, digital services and solutions. It helps its clients drive their digital transformation and obtain tangible and sustainable benefits. The Group provides end-to-end solutions to make large companies and organisations more competitive by combining in-depth knowledge of a wide range of business sectors and innovative technologies with a collaborative approach. Sopra Steria places people at the heart of everything it does and is committed to putting digital to work for its clients in order to build a positive future for all. In 2025, the Group generated revenues of €5.6 billion. The world is how we shape it. Job Description We are seeking a highly skilled and experienced SSIS Production Support Lead with 6+ years of hands-on experience to join our team. In this role, you will be responsible for supporting and maintaining our SSIS (SQL Server Integration Services) and ETL (Extract, Transform, Load) processes. Your expertise will contribute to the successful implementation and optimization of data integration solutions within our organization. The ideal candidate has a solid background in SSIS development and administration, along with excellent troubleshooting and problem-solving abilities. Responsibilities: Provide technical support and troubleshooting for SSIS and ETL-related issues in a production environment. Collaborate with cross-functional teams to understand business requirements and translate them into effective SSIS/ETL solutions. Design, develop, test, and deploy SSIS packages for data extraction, transformation, and loading processes. Monitor and maintain the performance, availability, and integrity of SSIS and ETL jobs. Identify and resolve performance bottlenecks and optimize ETL workflows for efficient data processing. Conduct root cause analysis for production incidents and implement preventive measures. Develop and maintain documentation, including system specifications, data mappings, and process flow diagrams. Stay up to date with industry trends and best practices in SSIS, ETL, and data integration technologies. Collaborate with database administrators, developers, and other stakeholders to ensure data quality and consistency. Participate in on-call support rotations and respond to critical issues in a timely manner. Leadership & Soft Skills: Strong ownership mindset for production stability Excellent communication and stakeholder management Experience leading support teams and on-call rotations Ability to work under pressure in critical production incidents Total Experience Expected: 04-06 years Qualifications Bachelor's degree in Computer Science, Information Technology, or a related field. Minimum of 8 years of experience in SSIS development and administration. Proficient in SQL programming and query optimization. Experience with performance tuning and optimization of SSIS packages. In-depth understanding of database systems, particularly Microsoft SQL Server. Solid understanding of data warehousing concepts and dimensional modelling. Familiarity with data governance and data quality principles. Relevant certifications in SSIS or ETL technologies are a plus. Additional Information Candidate should be open to short-term travel and participation in on-call support activities as required. At our organization, we are committed to fighting against all forms of discrimination. We foster a work environment that is inclusive and respectful of all differences. All of our positions are open to people with disabilities.

Responsibilities

The role involves providing technical support and troubleshooting for SSIS and ETL processes in a production environment. Responsibilities include designing, deploying, and optimizing data integration packages while leading support teams and on-call rotations.