Oracle ODS Consultant

🔥 0 minutes ago

🇪🇬 Egypt – Remote

⏰ Full Time

🟡 Mid-level

🟠 Senior

💼 Consultant

👻 Ghost score 11%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Valleysoft | Center of Excellence

WebsiteLinkedInAll Job Openings

51 - 200 employees

💼 Consulting

Consulting

Valleysoft is an IT services company based in Egypt, founded under the Egyptian Investment Law for over 15 years. As a regional provider, Valleysoft serves clients globally, partnering with organizations like IBM to address complex business and technical challenges. Their offerings include consulting, system services, IT infrastructure services, and a range of IBM-specific solutions such as software development services, business process management, and robotic process automation. With a focus on quality delivery and operational discipline, Valleysoft ensures high-quality, predictable outcomes for its clients.

📋 Description

• 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.

🎯 Requirements

• Bachelor's degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience. • 4+ years of experience in Oracle database development and enterprise data integration. • Hands-on experience delivering ODS or comparable enterprise data solutions, including data modelling, relational schemas, source-to-target mapping, mapping specifications, data validation, and reconciliation. • Strong hands-on production experience with incremental-load design, CDC concepts, ETL/ELT error handling and recovery, SQL and PL/SQL optimization, query tuning, and efficient data-loading processes. • Experience with Oracle Data Integrator (ODI) or a comparable enterprise ETL/ELT platform, including pipeline development, scheduling, monitoring, and recovery. • Hands-on production experience with unit and integration testing, UAT support, defect resolution, and controlled production releases with rollback and recovery procedures. • Experience working with both business and technical stakeholders throughout the data-integration lifecycle, from requirements gathering through mapping validation, testing, and production support, with the ability to independently manage requirement clarification, stakeholder coordination, and issue resolution. • Fluency in English and Arabic. • Availability during Saudi business hours and to support planned deployments, production releases, and urgent data-integration issues when needed. • Experience optimizing high-volume data pipelines and supporting near-real-time integrations is a plus. • Experience with Oracle GoldenGate for replication and change data capture is a bonus.

🏖️ Benefits

• Private Health Insurance • Training & Development