This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking a highly skilled and experienced SSIS Production Support Lead with 8-10 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.
Job Responsibility:
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
Requirements:
B.E / B.Tech
Minimum of 8 years of experience in SSIS development and administration
Strong knowledge of ETL concepts, data integration methodologies, and best practices
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
Strong analytical and problem-solving skills
Excellent communication and interpersonal skills
Ability to work independently and collaboratively in a team environment
Relevant certifications in SSIS or ETL technologies are a plus
Nice to have:
Relevant certifications in SSIS or ETL technologies are a plus