Oracle Consultant

7+ years of hands-on experience with ODI and OIC in enterprise Oracle ERP integration and migration projects.

Proven experience leading integrations from source systems to Oracle ERP Cloud, including master and transactional data flows.

Strong expertise in :

ODI ETL / ELT development and performance tuning

OIC integration flows, adapters, orchestration, and error handling

FBDI, UCM, and API-based integration patterns

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

Working knowledge of scheduler / orchestration tools such as Airflow or Control-M.

Solid understanding of data warehouse and data mart concepts.

Experience delivering HLD, LLD, FSD, and TSD documentation.

Strong problem-solving, communication, and documentation skills.

Preferred Qualifications

Oracle certifications in ODI and / or OIC.

Experience integrating with third-party systems (e.g., banking, tax engines, procurement platforms, CRM, legacy ERP).

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

Exposure to waterfall, agile methodologies and enterprise integration patterns.