Oracle ODS Consultant
Valleysoft is an IT services provider specializing in enterprise applications, process management, and cloud solutions. The Oracle ODS Consultant role focuses on designing and implementing data initiatives, ensuring data quality, and connecting multiple systems for reliable reporting. Key responsibilities include gathering requirements, designing Oracle database objects, developing ETL/ELT pipelines, and monitoring data quality. Strong collaboration with Saudi-based teams ensures effective service delivery.
Job description
Valleysoft is a regional IT services provider delivering enterprise applications, process management, and cloud and data solutions to global clients. Working across the Information Technology and Services space, the company partners with leading technology vendors including Oracle and AWS to help organizations build dependable, scalable systems that support critical business operations. This role offers the opportunity to contribute to enterprise data initiatives that depend on strong design, integration, and operational discipline. As an Oracle ODS Consultant, you will play a key part in shaping data solutions that connect multiple systems, improve data quality, and support reliable reporting and downstream processes for client environments.
Responsibilities
- Gather business and technical requirements and translate them into ODS designs, data models, source-to-target mappings, and technical specifications.
- Design and maintain Oracle database objects, including tables, views, indexes, constraints, and PL/SQL packages.
- Develop and maintain ETL/ELT pipelines using Oracle Data Integrator (ODI) or comparable enterprise integration tools.
- Implement initial and incremental data loads, change data capture, error handling, and recovery procedures.
- Integrate data from multiple enterprise systems and implement data validation, cleansing, deduplication, and reconciliation.
- Optimize SQL queries, PL/SQL code, and data-loading processes to meet performance and data-freshness requirements.
- Perform unit and integration testing, support UAT, troubleshoot defects, and assist with production deployments.
- Monitor data pipelines, investigate incidents, and resolve data-quality and performance issues.
- Maintain technical documentation, data mappings, lineage, deployment procedures, and support runbooks.
- Collaborate remotely with Saudi-based project teams and stakeholders to deliver agreed milestones and service commitments.
Job details
- Published
- October 26, 2026
- Job source
- jworkable
- Workplace
- Remote · Cairo, EG
- First seen
- October 26, 2026
See how well you match this job
Log in or sign up and Eva will compare your profile with this role, explain your strengths and show what to improve.
Sign up to see your matchAlready have an account? Log inMore at Valleysoft
Similar jobs from this company
- Oracle ODS ConsultantValleysoftCairo, EGRemote
- SAP IS-Auto / Proaxia VSS Functional Consultant (Techno-Functional)ValleysoftCairo, EGRemote
- SAP VSS ConsultantValleysoftCairo, EGRemote
- SAP C4C Consultant - Technical (SDK/PDI) & FunctionalValleysoftCairo, EGRemote
- Dell Boomi / API & Middleware Integration ConsultantValleysoftCairo, EGRemote
- SAP GRC Security ConsultantValleysoftCairo, EGRemote
Across the market
Similar jobs from other companies
- Consultant, OracleGenpact India Pvt. Ltd.Bangalore, INOn-site
- Oracle EPM ConsultantbTranzHyderabad, INOn-site
- Oracle Development ConsultantEva PharmaCairo, EGHybrid
- Oracle HRMS ConsultantVAM SystemsDubai, AEOn-site
- Oracle HCM ConsultantbTranzRiyadh, SAOn-site
- Oracle HCM ConsultantshrikonBengaluru, INOn-site
Third-party content disclaimer
Full job descriptions are sourced directly from third-party applicant tracking systems (ATS), job boards, recruitment platforms, and employer career pages.
LiftmyCV does not claim ownership of this content or guarantee its accuracy or current availability. All original content is the intellectual property of the respective employers or other rights holders.
LiftmyCV hiring intelligence, availability checks, and related-job recommendations are generated from LiftmyCV data and public sources.
If you prefer, you may apply directly via the original listing for transparency.