Senior Data Integration Developer

About the role

We are seeking a Senior Data Integration Developer to design, develop, and maintain enterprise‑grade ETL solutions. The role involves working with SSIS, Informatica PowerCenter, Oracle, and Microsoft SQL Server to support data warehousing and migration initiatives.

Key responsibilities

• Design, develop, test, and maintain ETL solutions using SSIS and Informatica PowerCenter.
• Build, optimise, and support data integration workflows that meet business requirements.
• Design and implement scalable data‑warehousing solutions.
• Execute large‑scale data migration projects while ensuring data quality and integrity.
• Develop, optimise, and maintain Oracle PL/SQL packages, procedures, functions, and triggers.
• Write advanced T‑SQL scripts, stored procedures, and tune performance in Microsoft SQL Server.
• Analyse business and technical requirements and recommend scalable integration solutions.
• Troubleshoot ETL failures, resolve performance bottlenecks, and address data‑quality issues.
• Collaborate with stakeholders, architects, DBAs, and development teams.
• Participate in Agile ceremonies such as sprint planning, daily stand‑ups, and retrospectives.

Required profile

• Minimum 5+ years of experience with SQL Server Integration Services (SSIS 2019).
• Extensive experience developing in Informatica PowerCenter.
• Strong expertise in enterprise ETL architecture and large‑scale data integration.
• Solid understanding of data‑warehousing concepts, dimensional modelling, and ETL best practices.
• Hands‑on experience with data migration planning, execution, and validation.
• Strong background in Oracle database administration and PL/SQL development.
• Extensive experience with Microsoft SQL Server development and administration.
• Advanced proficiency in T‑SQL and query optimisation.
• Experience working in Agile development environments.

Required skills

• SSIS (SQL Server Integration Services)
• Informatica PowerCenter
• Oracle Database
• Oracle PL/SQL
• Microsoft SQL Server
• T‑SQL
• Data warehousing
• Data migration