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.
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: 08-10 years