ETL Developer

Total-TECH Co.; Jeddah; On-site; SAR 300,000 - 420,000; Full time

Job summary

A leading technology company in Jeddah is looking for an experienced ETL Developer with strong skills in data engineering and ETL tools like SSIS and Informatica BDM. The role involves designing and implementing data ingestion pipelines, managing data workflows, ensuring data quality, and collaborating with stakeholders. Qualified candidates should have 8–10 years of experience in related fields and familiarity with databases and big data technologies. Competitive compensation package offered.

Qualifications

• 8–10 years of experience in ETL development and data engineering.
• Proven experience in solution engineering and data modeling.
• Hands-on experience with orchestration tools such as Control-M.
• Hands-on experience with orchestration tools (e.g., Control-M) and data quality frameworks.
• Familiarity with Hadoop distributions (Cloudera, MapR, Hortonworks) is a plus.
• Strong T-SQL and PL/SQL skills; ability to optimize and tune queries and ETL jobs.

Responsibilities

• Design and implement data ingestion pipelines.
• Create and manage data workflows in orchestration tools.
• Ensure data quality, integrity, and consistency across all systems.
• Develop complex T-SQL and PL/SQL queries, stored procedures, and scripts for data transformation.
• Monitor performance and recommend improvements to infrastructure and configurations.
• Troubleshoot and resolve high-impact data issues through in-depth analysis.
• Design logical and physical data models to support enterprise data architecture.

Skills

ETL development

Data engineering

T-SQL

PL/SQL

Data quality frameworks

Orchestration tools

Data modeling

Hadoop distributions

BI Tools

Solution engineering

Tools

SSIS

Informatica BDM

Microsoft Power BI

IBM Cognos

Azure

Cloudera

Spark

Job description

Overview

The Job Description

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

Required 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, MapR, Hortonworks) is a plus.
• Strong T-SQL and PL/SQL skills; ability to optimize and tune queries and ETL jobs.
• 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 Certifications (Optional)

• Microsoft Certified: Azure Data Engineer Associate.
• Informatica Cloud/BDM Professional.