# Senior Data Integration Developer

**Company:** [Unison Group](http://jobs.workable.com/companies/deKpPhPMtQZga7XoPG1tSo.md)
**Location:** Al Khobar, Saudi Arabia
**Workplace:** on site
**Employment type:** Contract
**Department:** Kapil

[Apply for this job](http://jobs.workable.com/view/a6c94921-4d38-4542-ac97-c5a11e511ceb)

## Description

**We are looking for a Senior Data Integration Developer with strong expertise in SSIS, Informatica PowerCenter, Oracle, and Microsoft SQL Server to design, develop, and maintain enterprise-grade data integration and ETL solutions.**

-   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.

## Requirements

-   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.