Oracle ODS Consultant

This is a fully remote position, open to applicants in Egypt.

📋 Description

• Collect business and technical requirements, converting them into ODS designs, data models, source-to-target mappings, and technical specifications.

• Create and manage Oracle database objects such as tables, views, indexes, constraints, and PL/SQL packages.

• Build and sustain ETL/ELT pipelines utilizing Oracle Data Integrator (ODI) or similar enterprise integration tools.

• Execute initial and incremental data loads, implement change data capture, manage error handling, and develop recovery procedures.

• Merge data from various enterprise systems while establishing data validation, cleansing, deduplication, and reconciliation processes.

• Enhance SQL queries, PL/SQL code, and data-loading methods to fulfill performance and data freshness standards.

• Conduct unit and integration testing, assist with UAT, troubleshoot defects, and support production deployments.

• Oversee data pipelines, investigate incidents, and resolve issues related to data quality and performance.

• Maintain comprehensive technical documentation including data mappings, lineage, deployment protocols, and support runbooks.

• Collaborate remotely with project teams and stakeholders based in Saudi Arabia to achieve agreed milestones and service commitments.

⛳️ Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related discipline, or equivalent practical experience.

• Over 4 years of experience in Oracle database development and enterprise data integration.

• Practical experience in delivering ODS or similar enterprise data solutions that encompass data modeling, relational schemas, source-to-target mapping, mapping specifications, data validation, and reconciliation.

• Solid hands-on production experience with incremental-load design, change data capture concepts, ETL/ELT error handling and recovery, SQL and PL/SQL optimization, query tuning, and efficient data-loading techniques.

• Familiarity with Oracle Data Integrator (ODI) or a comparable enterprise ETL/ELT platform, including pipeline development, scheduling, monitoring, and recovery processes.

• Practical experience in unit and integration testing, UAT support, defect resolution, and managed production releases with rollback and recovery strategies.

• Experience interacting with both business and technical stakeholders throughout the data integration lifecycle, from gathering requirements to mapping validation, testing, and production support, with the capability to independently handle requirement clarification, stakeholder coordination, and issue resolution.

• Proficiency in both English and Arabic.

• Availability during Saudi business hours and readiness to support planned deployments, production releases, and urgent data integration challenges as needed.

• Experience in optimizing high-volume data pipelines and supporting near-real-time integrations is advantageous.

• Familiarity with Oracle GoldenGate for replication and change data capture is a plus.

🏝️ Benefits

• Private Health Insurance

• Training & Development