Senior Data Integration Developer

Unison Group; Al Khobar; On-site; SAR 240,000 - 360,000; Full time

Job summary

Unison Group is seeking an experienced ETL Architect/Developer to design, implement, and optimize enterprise-grade ETL solutions using SSIS 2019 and Informatica PowerCenter. You will build scalable data pipelines, support data migration, and ensure data quality across large systems.

The role requires strong Oracle PL/SQL and T-SQL skills, extensive data warehousing knowledge, and collaboration with architects, DBAs, and business users in an Agile environment.

Qualifications

• 5+ years designing and deploying ETL solutions with SSIS 2019.
• Expertise in Informatica PowerCenter development and optimization.
• Strong data warehousing knowledge, dimensional modeling, ETL best practices.
• Experience with data migration planning, validation, and reconciliation.

Responsibilities

• Design, develop, test, and maintain enterprise ETL solutions using SSIS and Informatica.
• Build and support data integration workflows meeting business requirements.
• Design scalable data warehousing solutions.
• Troubleshoot ETL failures and address data quality issues.
• Collaborate with stakeholders and architects to deliver solutions.
• Participate in Agile ceremonies and follow coding standards.

Skills

ETL design

Data warehousing

Data migration

SQL optimization

Tools

SSIS

Informatica PowerCenter

Oracle PL/SQL

Microsoft SQL Server

T-SQL

Job description

Key Responsibilities

• Design, develop, test, and maintain enterprise-grade ETL solutions using SQL Server Integration Services (SSIS) and Informatica PowerCenter.
• Build, optimize, and support data integration workflows to meet business and operational requirements.
• Design and implement scalable data warehousing solutions.
• Execute and support large-scale data migration projects while ensuring data quality, consistency, and integrity.
• Develop, optimize, and maintain Oracle PL/SQL packages, procedures, functions, and triggers.
• Develop advanced T-SQL scripts, stored procedures, and optimize performance in Microsoft SQL Server.
• Analyze business and technical requirements and recommend scalable data integration solutions.
• Troubleshoot ETL failures, resolve performance bottlenecks, and address data quality issues.
• Collaborate with business stakeholders, solution architects, database administrators, and development teams to deliver high-quality solutions.
• Adhere to coding standards, documentation best practices, and change management processes.
• Participate actively in Agile ceremonies, including sprint planning, daily stand-ups, sprint reviews, and retrospectives.

Experience

• Min 5+ Years of experience in SQL Server Integration Services (SSIS 2019) for designing, developing, and deploying ETL solutions.
• Extensive experience in Informatica PowerCenter development, including ETL workflows, mappings, and performance optimization.
• Proven expertise in enterprise ETL architecture, design, development, and optimization for large-scale data integration projects.
• Strong understanding of data warehousing concepts, including dimensional modeling, data marts, and ETL best practices.
• Hands-on experience in data migration planning, execution, validation, and reconciliation across enterprise systems.

Database Technologies

• Strong experience with Oracle Database administration and development.
• Expertise in Oracle PL/SQL programming, including packages, procedures, functions, triggers, and performance tuning.
• Extensive experience with Microsoft SQL Server development and administration.
• Advanced proficiency in T-SQL, including query optimization, indexing strategies, stored procedures, and performance tuning.