Senior ETL & Data Integration Architect

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

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.