Oracle Integration Architect

Required Experience & Technical Skills:

• 10+ years of hands-on delivery experience with Oracle technical integrations and implementations.

• At least 3 end-to-end Oracle ERP technical implementations across multiple domains, including ERP, SCM, and HCM.

• Deep proficiency in:

  • Oracle Integration Cloud (OIC)
  • REST/SOAP APIs
  • XSLT Mapping
  • XPath
  • OIC Projects
  • OIC AI capabilities
  • Complex integration patterns
  • Event-based integrations
  • Application-driven orchestrations
  • Scheduled orchestrations
  • PL/SQL
  • DBMS Cloud Jobs

• Deep understanding of OCI integration architectures leveraging multiple PaaS services, including:

  • OCI API Gateway
  • OCI Events
  • OCI Object Storage
  • OCI Notifications
  • Other relevant OCI integration services

• In-depth knowledge of Oracle BI Publisher.

• In-depth knowledge of Oracle bulk-upload technologies, including HDL and FBDI.

• Strong understanding of Oracle SaaS technical architecture and configuration.

• Experience with Oracle Fusion Security.

• Strong understanding of integration security, including OAuth 2.0, JWT, security policies, API rate limiting, OAS 3.0, and data privacy standards.

Key Responsibilities:

Solutions Design & Architecture

• Define end-to-end integration architecture using Oracle Integration Cloud (OIC).
• Establish appropriate integration patterns, including synchronous, asynchronous, event-driven, application-driven, and scheduled/batch orchestrations.
• Define integration design principles, standards, and reusable architecture patterns.
• Design OCI-based integration architectures leveraging services such as API Gateway, OCI Events, Object Storage, Notifications, and other PaaS capabilities.
• Ensure integration solutions align with enterprise architecture, security, scalability, performance, and data privacy standards.

Development & Configuration

• Build and deliver complex OIC integrations and orchestrations across Oracle and non-Oracle applications.
• Configure and utilize a broad range of OIC adapters, including REST, SOAP, Oracle ERP/HCM, Kafka, and other relevant adapters.
• Design and implement complex transformations using XSLT, XPath, XML, and JSON.
• Configure OIC Projects and leverage OIC AI capabilities where appropriate.
• Develop and optimize PL/SQL solutions and utilize DBMS Cloud Jobs where required.
• Design integrations supporting Oracle SaaS business processes across ERP, SCM, and HCM.

Oracle SaaS & Technical Architecture

• Provide technical architecture expertise across Oracle SaaS solutions.
• Work with Oracle SaaS Technical Configuration, Groovy scripting, and SaaS customization.
• Apply knowledge of Oracle Fusion Security within relevant business domains.
• Design and support integrations involving Oracle SaaS applications and enterprise systems.
• Develop and support reporting and data extraction solutions using Oracle BI Publisher and OTBI.
• Design and implement Oracle bulk-load solutions using HDL and FBDI.

Governance & Security

• Establish and enforce enterprise API contracts using OpenAPI Specification (OAS) 3.0.
• Implement and govern API security using OAuth 2.0, JWT, and appropriate security policies.
• Apply API governance practices including rate limiting and access controls.
• Enforce the use of private endpoints for integration connections where required.
• Ensure integration solutions comply with organizational security and data privacy standards.

Integration Delivery & Lifecycle Management

• Lead integration projects and enhancements through the full delivery lifecycle.
• Participate in requirements gathering and technical discovery workshops.
• Translate business processes and requirements into detailed technical specifications and architecture designs.
• Lead integration development, testing, deployment, and production implementation activities.
• Support SIT, UAT, production deployment, and post-production hypercare.
• Provide technical leadership and guidance to integration developers and technical teams.

Technical Troubleshooting

• Triage and resolve complex integration and payload-related errors.
• Troubleshoot integration performance bottlenecks and reliability issues.
• Perform detailed root-cause analysis (RCA) and implement sustainable corrective actions.
• Monitor integration health and identify opportunities for performance and architecture improvements.