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.