Role Overview:
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.
Job Title : ETL Developer
Location: Jeddah (Remote)
Experience: 8–10 years
Education: Bachelor’s Degree in Computer Science, MIS, or related field
Key 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.
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.
Technical 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.
Soft 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.
Preferred Certifications (Optional):
- Microsoft Certified: Azure Data Engineer Associate.
- Informatica Cloud/BDM Professional.
Key Performance Indicators (KPIs):
- ETL job success rate and SLA adherence.
- Data pipeline throughput and latency improvements.
- Number of incidents resolved and mean time to recovery (MTTR).
- Query and job performance tuning impact (e.g., runtime reduction).
- Data quality metrics (completeness, consistency, accuracy).
Note: This job description outlines core responsibilities and qualifications. Actual duties may evolve based on business needs and technology landscape