Oracle ODS Consultant

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