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.
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
Skills Required
- Bachelor's degree in Computer Science, Information Systems, Engineering, 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
- Experience with data modeling, relational schemas, source-to-target mapping, mapping specifications, data validation, and reconciliation
- 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
- Experience with Oracle Data Integrator or a comparable enterprise ETL/ELT platform, including development, scheduling, monitoring, and recovery
- Production experience with unit and integration testing, UAT support, defect resolution, controlled releases, rollback, and recovery procedures
- Experience working with business and technical stakeholders throughout the data-integration lifecycle
- Ability to independently manage requirements clarification, stakeholder coordination, and issue resolution
- Fluency in English and Arabic
- Availability during Saudi business hours and for planned deployments, production releases, and urgent integration issues
- Experience optimizing high-volume data pipelines and supporting near-real-time integrations
- Experience with Oracle GoldenGate for replication and change data capture
What We Do
- Valleysoft is a regional IT services provider serving clients around the world. Since 2006, Valleysoft has been working with global partners, such as IBM, in different industries to solve complex business and technical problems ranging from enterprise-class application development and maintenance to worldwide process management. - As client-focused and process-oriented company, Valleysoft stands as a vendor neutral and capability rich professional organization. Our maturity in quality delivery and operational discipline shows through our work. Our operational maturity enables us to provide high-quality services with repeatable and predictable results at optimized efficiency in both level of efforts and economic model. As a result, we are able to deliver to our clients world-class services at best values.
