ETL SSIS developer

ETL SSIS Developer

We are seeking an experienced ETL / SSIS Developer to design, develop, optimize, and maintain enterprise data integration solutions using Microsoft SQL Server Integration Services (SSIS) and SQL Server. The ideal candidate will have strong T-SQL development and performance-tuning skills, a solid understanding of data quality and security, and experience applying modern data architecture, DevOps, and database deployment practices.

Key Responsibilities

• Design, develop, enhance, and maintain scalable ETL pipelines using Microsoft SSIS.
• Develop and maintain high-quality T-SQL code, including stored procedures, functions, views, and complex queries.
• Optimize SQL query performance through execution plan analysis, indexing strategies, and query tuning.
• Implement robust error handling, logging, transaction management, and data validation to ensure data accuracy, consistency, and reliability.
• Apply secure SQL development practices, including parameterized dynamic SQL, least-privilege access, and role-based security controls.
• Apply Medallion Architecture principles across Bronze, Silver, and Gold data layers to support organized, reliable, and high-quality data processing.
• Partner with business stakeholders, product owners, and data engineering teams to translate business requirements into effective technical solutions.
• Follow Git-based development practices, including version control, peer code reviews, automated testing, and database CI/CD processes.
• Leverage AI-powered coding assistants to improve development productivity, testing, documentation, and code optimization, while ensuring all outputs are reviewed and validated.
• Support production data operations by monitoring SLAs/SLOs, troubleshooting ETL and database issues, resolving incidents, and conducting root-cause analysis.
• Identify opportunities to improve ETL performance, data quality, maintainability, and operational efficiency.

Required Qualifications

• Strong hands-on experience with Microsoft SSIS and SQL Server.
• Proficiency in T-SQL development, including stored procedures, functions, views, and complex queries.
• Demonstrated experience in SQL performance tuning, execution plan analysis, and indexing.
• Experience developing, deploying, and supporting enterprise-scale ETL pipelines.
• Understanding of data modeling, data validation, data integrity, and database security best practices.
• Familiarity with version control, code review processes, automated testing, and database deployment practices.
• Strong analytical, troubleshooting, problem-solving, and communication skills.
• Ability to work collaboratively with technical teams and business stakeholders.

Preferred Qualifications

• Experience with Talend Data Integration.
• Familiarity with GitHub Copilot or other AI-assisted development tools.
• Experience implementing automated testing and database CI/CD pipelines.
• Knowledge of Medallion Architecture and modern data engineering practices.
• Experience in banking, financial services, or other data-intensive enterprise environments.

WHY JOIN US

Matrix is a global, dynamic, and fast‑growing technology services and consulting company with over 17,000 employees worldwide. Founded in 2001, Matrix has grown through significant organic expansion and strategic acquisitions, executing some of the largest and most impactful technology projects in the market.

We specialize in the design, development, and implementation of advanced technologies, software solutions, and digital products. Our services include infrastructure and consulting, IT outsourcing and offshore delivery, training and assimilation programs, and acting as a trusted implementation and delivery partner for the world’s leading software vendors.

With deep expertise across both the private and public sectors—spanning Finance, Telecom, Healthcare, Hi‑Tech, Education, Defense, and Security—Matrix serves a strong customer base in Israel alongside a continuously expanding global client portfolio.

At Matrix, our people are at the heart of our success. We are a community of talented, creative, and dedicated professionals who are passionate about innovation and excellence. We actively attract, develop, and retain top talent, recognizing that every employee’s contribution is critical to our continued growth and future success.

Matrix’s success is built on a challenging and engaging work environment, competitive compensation and benefits, and meaningful career development opportunities. We foster a diverse, inclusive culture that encourages collaboration, continuous learning, and growth—together.

Join the winning team. Be challenged, grow your career, and enjoy the journey in a highly respected global organization.

To learn more, visit: www.matrix-ifs.com

EQUAL OPPORTUNITY EMPLOYER: Matrix is an Equal Opportunity Employer and Prohibits Discrimination and Harassment of Any Kind. Matrix is committed to the principle of equal employment opportunity for all employees, providing employees with a work environment free of discrimination and harassment. All employment decisions at Matrix are based on business needs, job requirements, and individual qualifications, without regard to race, color, religion or belief, family or parental status, or any other status protected by the laws or regulations in our locations. Matrix will not tolerate discrimination or harassment based on any of these characteristics. Matrix encourages applicants of all ages.



no need to work Rao