Oracle Technical Consultant - Lead

We are seeking a highly experienced Oracle Fusion Technical Consultant with 8-10+ years of expertise in report development (OTBI, BIP and/or OAC), enterprise integration, Oracle Cloud technologies, and large-scale healthcare system implementations. The ideal candidate will serve as a technical consultant within NMC’s Oracle team IT and be responsible for Oracle Fusion report and integration development. This role requires deep expertise in Oracle transactional BI (OTBI), Oracle BI Publisher (BIP), Oracle Analytics Cloud (OAC), Oracle Integration Cloud (OIC), API management, middleware solutions, and enterprise-wide finance/SCM transformation.

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 .

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 .