Assistant Consultant - Oracle Fusion

Oracle Integration Cloud (OIC) Consultant 6+ Years Experience • India Job Title Oracle OIC Consultant (Senior / Lead) Experience Required 6+ Years Employment Type Full-Time / Contract Location India (Pan-India / Remote / Hybrid) Education B.E. / B.Tech / MCA / M.Tech or equivalent Notice Period Immediate to 30 Days Preferred Role Summary We are seeking an experienced Oracle Integration Cloud (OIC) Consultant with 6+ years of hands-on expertise in designing, developing, and deploying enterprise integration solutions. The ideal candidate will have deep proficiency in Oracle Integration Cloud (OIC Gen 2 / Gen 3), Oracle SOA Suite, and related Oracle middleware technologies. You will work closely with cross-functional teams, architects, and business stakeholders to deliver scalable, high-quality integrations. Key Responsibilities Integration Design & Development • Design, develop, and deploy integrations using Oracle OIC (Gen 2 and Gen 3) leveraging REST, SOAP, FTP, and database adapters. • Build orchestration and scheduled integration flows, process automation, and visual builder applications. • Develop and configure Oracle Integration Cloud connections, lookups, and libraries. • Implement B2B integrations and EDI transactions using Oracle OIC B2B capabilities. Architecture & Solution Design • Define integration architecture and best practices aligned with Oracle middleware standards. • Participate in solution design discussions, technical POCs, and architecture reviews. • Evaluate and recommend integration patterns (point-to-point, hub-and-spoke, event-driven). Technical Expertise • Integrate Oracle ERP Cloud, HCM Cloud, SCM Cloud, and third-party SaaS applications via OIC. • Work with Oracle Autonomous Database (ATP/ADW), Oracle Object Storage, and OCI services. • Configure error handling, fault policies, retry logic, and monitoring dashboards in OIC. • Develop XSLT/XPath transformations and data mapping for complex integration scenarios. Stakeholder Collaboration & Delivery • Gather and analyze business requirements and translate them into technical integration specifications. • Collaborate with Oracle ERP/HCM functional consultants, solution architects, and project managers. • Provide effort estimates, technical documentation, and integration design documents (IDD). • Support UAT, production cutover, and hypercare post-go-live activities. Operations & Support • Monitor, troubleshoot, and resolve integration issues in production environments. • Perform performance tuning and optimization of OIC integrations. • Maintain version control and deployment pipelines for OIC artifacts. Required Skills & Qualifications Mandatory Technical Skills • 6+ years of overall IT experience with minimum 4 years hands-on in Oracle OIC / ICS. • Strong expertise in Oracle OIC Gen 2 and Gen 3 (OIC3) platform. • Proficiency with OIC adapters: REST, SOAP, Oracle ERP Cloud, Oracle HCM Cloud, FTP, File, Database, Salesforce, ServiceNow, Slack adapters. • Hands-on experience with XSLT, XPath, XQuery, JSON, XML, and Groovy scripting. • Good knowledge of Oracle SOA Suite 12c or Oracle Service Bus (OSB). • Experience integrating with Oracle Fusion Cloud (ERP, HCM, SCM, PPM). • Familiarity with REST API design, OAuth 2.0, JWT, and API security best practices. Cloud & Platform Skills • Working knowledge of Oracle Cloud Infrastructure (OCI) — compute, networking, storage. • Experience with OCI API Gateway, OCI Streaming, or Oracle Event Hub is a plus. • Exposure to CI/CD tools (Git, Jenkins, or OCI DevOps) for OIC deployment automation. Soft Skills • Strong analytical and problem-solving abilities. • Excellent communication skills for stakeholder and client-facing interactions. • Ability to work independently and manage multiple integrations simultaneously. • Team player with mentoring skills for junior developers. Good to Have • Oracle OIC certification (Oracle Certified Professional – OIC). • Experience with Oracle Process Automation (OPA) / Workflow. • Knowledge of Oracle Analytics Cloud (OAC) or BI Publisher integration. • Exposure to MuleSoft, Dell Boomi, or Informatica for migration scenarios. • Understanding of microservices architecture, Kubernetes, and containerization. • Experience in healthcare (HL7/FHIR), BFSI, or manufacturing domain integrations. Preferred Certifications (not mandatory) • Oracle Cloud Infrastructure (OCI) Foundations Associate or higher. • Oracle Integration Cloud (OIC) Certified Implementation Specialist. • Oracle SOA Suite 12c Certified Implementation Specialist. • AWS / Azure Associate certification (for multi-cloud exposure) — advantageous.