Location: Saudi Arabia???? Work Type: Full-Time, Onsite
???? Key Responsibilities:Design, build, and maintain hashtag#ETL/ELT processes to integrate data from multiple sources (Databases, APIs, Flat Files, etc.) into the Data Warehouse. Develop and maintain Fact Tables and Dimension Tables within the Data Warehouse. Design data models using Star Schema and Snowflake Schema methodologies. Monitor ETL jobs, troubleshoot errors, and ensure pipeline stability and reliability. Optimize ETL workflows, mappings, and jobs to improve performance. Ensure data quality, consistency, and accuracy by implementing validation and quality rules. Collaborate with BI and Analytics teams to understand business and reporting requirements. Prepare and maintain technical documentation for ETL processes and data models. Contribute to improving the overall Data Warehouse architecture.
???? Technical Skills & Qualifications:5+ years of experience as a Data Warehouse Developer or hashtag#ETL_Developer. Strong hands-on experience with Oracle Data Integrator (ODI). Solid understanding of ETL / ELT concepts. Strong experience in Dimensional Modeling (Facts & Dimensions). Advanced SQL and PL/SQL skills. Experience with Oracle Database or similar enterprise databases. Good understanding of Data Pipelines and Workflows. Experience in performance tuning for ETL jobs or databases.
???? Soft Skills:Strong analytical and problem-solving skills. Logical thinking and attention to detail. Ability to work collaboratively with cross-functional teams. Clear and structured documentation skills.