Oracle Technical Consultant - Lead

• Develop reporting solutions with BI Publisher (BIP), Oracle Transactional Business Intelligence (OTBI), BICC extracts, and Oracle Analytics Cloud (OAC), including custom data models and dashboards.

• Architect and implement scalable integration solutions between Oracle Cloud ERP, Oracle Fusion Applications, and external healthcare systems (e.g., Insta, Cerner, EPIC) .

• Design and build integrations using Oracle Integration Cloud (OIC), including REST/SOAP APIs, adapters, and orchestrations for Fusion-to-external system connectivity.

• Handle data migration support via FBDI/HDL, error handling, performance tuning, and alignment with analytics or migration teams.

• Establish best practices for data consistency, transformation, and validation across Oracle Cloud and third-party systems.

• Collaborate with business and IT stakeholders to gather requirements and translate them into scalable integration designs .

• Monitor, troubleshoot, and optimize integration performance , ensuring minimal downtime and high system availability.

• Lead the impact assessment of Oracle Fusion Cloud updates , ensuring integrations remain functional and aligned with evolving system capabilities.

• Develop technical documentation , including report specifications, integration architecture diagrams, data flow mappings, and API specifications .

Education and Certification:

Essential:

• Bachelor’s or master’s degree in IT, Computer Science, or a related field .
• 10+ years of experience in Integration Solution Architecture and large-scale enterprise implementations .

Desirable:

• Experience with healthcare-specific ERP integrations (e.g., Insta, Cerner, EPIC ).
• Proven track record of leading complex Oracle Fusion Cloud integration projects .

Knowledge Skills and Experience

• Oracle Integration Cloud (OIC) : Strong expertise in OIC, BPEL, and SOA middleware solutions .
• BIP, OTBI, OAC, custom data models
• API Development : Hands-on experience with REST, SOAP, JSON, XML, and Web Services .
• Enterprise Data Integration : Proficiency in Oracle Cloud Infrastructure Data Integration (OCIDI), Autonomous Data Warehouse (ADW), and ETL processes .
• Experience in enterprise-wide finance and SCM system transformation and Oracle Cloud ERP integration .
• Security & Compliance : Knowledge of OAuth2, JWT, SSL, encryption, and compliance frameworks (HIPAA, GDPR) for secure data exchange.
• Integration Monitoring & Performance Optimization : Expertise in error handling, logging, and debugging integration failures .

Cloud Technologies : Understanding of Oracle Cloud Infrastructure (OCI), PaaS, SaaS, and IaaS models .