Job Location :Onsite in Jeddah . Contract :Yearly Contract .

ETL Developer — Job Description

About the Role

The ETL Developer is responsible for designing, developing, and maintaining robust data ingestion pipelines and ETL processes to support enterprise data integration and analytics initiatives. The role requires deep expertise in SSIS, Informatica BDM, and native tooling, advanced SQL, data modeling, orchestration, performance optimization, and cross-functional collaboration.

Responsibilities

Design and implement data ingestion pipelines and ETL processes using SSIS, Informatica BDM, or native tools to meet functional and non-functional business requirements. Create and manage data workflows in orchestration tools such as Control-M to ensure scalability, optimize data delivery, and automate manual processes. Ensure data quality, integrity, and consistency across all systems, enabling trusted data for decision-making. Develop complex T-SQL and PL/SQL queries, stored procedures, and scripts for data transformation and integration. Monitor performance and recommend configuration or infrastructure changes to improve efficiency and reliability. Troubleshoot and resolve high-impact data issues through in-depth analysis of business and system processes. Design logical and physical data models to support enterprise data architecture. Establish and enforce standards for coding, testing, debugging, and implementation of ETL solutions. Collaborate with stakeholders across multiple functions to understand business processes and data requirements. Support enterprise ETL and BI developers in development and troubleshooting data-related issues; advise on efficient data extraction for reporting and analytics.
Qualifications

8–10 years of experience in ETL development and data engineering, preferably with SSIS, Informatica BDM, SSAS, SQL Server, Oracle, and semi/unstructured data. Proven experience in solution engineering, data modeling, and operations. Hands-on experience with orchestration tools (e.g., Control-M) and data quality frameworks. Familiarity with Hadoop distributions (Cloudera, Map R, Hortonworks) is a plus. Strong T-SQL and PL/SQL skills; ability to optimize and tune queries and ETL jobs.
Required Skills

ETL Tools: SSIS, Informatica BDM. Databases: SQL Server, Oracle, Vertica, NoSQL. Data Modeling: Logical and physical modeling. Big Data & Cloud: Cloudera, Azure, Snowflake, HDFS, Spark. BI Tools: Microsoft Power BI, IBM Cognos.
Preferred Skills

Strong analytical and problem-solving abilities. Excellent communication and collaboration skills. Ability to work in a fast-paced environment and manage multiple priorities. Proactive ownership mindset with attention to detail and documentation.