Digile - Oracle Consultant - ODI/OIC Modules

Description :

About the Role :

We are looking for an experienced Oracle Consultant with strong expertise in Oracle Data Integrator (ODI) and Oracle Integration Cloud (OIC).

The ideal candidate will have hands-on experience in enterprise Oracle ERP integration and migration projects, with a proven ability to lead integrations from source systems to Oracle ERP Cloud, handling both master and transactional data flows.

Key Responsibilities :

- Design, develop, and implement robust integration solutions using ODI and OIC.

- Develop and optimize ETL/ELT workflows, troubleshoot issues, and ensure high-performance ODI processes.

- Build and manage OIC integration flows, adapters, orchestration processes, and error-handling mechanisms.

- Implement integration patterns using FBDI, UCM, APIs, and other Oracle Cloud integration tools.

- Collaborate with business and technical teams to gather requirements and deliver comprehensive documentation (HLD, LLD, FSD, TSD).

- Leverage Oracle Database 19c, SQL, and PL/SQL for data extraction, transformation, and loading.

- Work with scheduler/orchestration tools like Airflow or Control-M to automate data workflows.

- Support data warehouse and data mart initiatives by ensuring smooth data integration across systems.

- Participate in technical discussions, problem-solving sessions, and knowledge sharing within the team.

Required Skills & Expertise :

- Strong hands-on experience with ODI and OIC in enterprise Oracle ERP integrations.

- Proficiency in Oracle Database 19c, SQL, and PL/SQL.

- Solid understanding of data warehousing, data mart, and enterprise integration concepts.

- Experience preparing HLD, LLD, FSD, TSD documentation.

- Excellent problem-solving, communication, and documentation skills.

Preferred Qualifications :

- Oracle certifications in ODI and/or OIC.

- Experience integrating with third-party systems such as banking platforms, tax engines, procurement systems, CRM, or legacy ERP solutions.

- Familiarity with Oracle UCM, BI Publisher, and OTBI.

- Exposure to Agile and Waterfall methodologies and enterprise integration patterns.