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, native ETL tools, advanced SQL, data modeling, orchestration, performance optimization, and cross-functional collaboration.
Job Title
ETL Developer
Location
Jeddah (Onsite)
Experience
8–10 years
Education
Bachelor's Degree in Computer Science, MIS, or a 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 using 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 to enable 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 improvements to enhance 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 ETL and BI teams 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 with 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 data 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 strong 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)
