LiftmyCVLiftmyCV
VA

Oracle ODS Consultant

ValleysoftRemoteCairo, EG

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
Last checked
November 2, 2026
Job source
workable
Workplace
Remote · Cairo, EG
First seen
October 26, 2026
AI match explained

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 in

More at Valleysoft

Similar jobs from this company

Across the market

Similar jobs from other companies

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.