Oracle Integration Architect

Oracle Integration Cloud technical architect

The Oracle Integration Cloud Architect is responsible for designing, governing, and delivering enterprise grade integrations using Oracle Integration Cloud. The role focuses on scalable, secure, and resilient integration architectures across Oracle SaaS, on prem systems, and third party platforms.

Architecture & Design

• Define end to end integration architecture using Oracle Integration Cloud (OIC Gen2)
• Design integration patterns including synchronous/asynchronous, event driven, and batch
• Establish canonical data models, transformation standards, and API design principles
• Design hybrid integrations across Oracle SaaS, on prem systems, and cloud platforms (Azure/AWS/GCP)

Integration Development Oversight

• Lead development of:
  • App Driven Integrations
  • Scheduled Integrations
  • Basic and Publish/Subscribe Integrations
• Define standards for lookup usage, packages, reusable integrations, and adapters
• Guide teams on error handling, fault policies, retries, and compensation logic

• Lead Design, development and implementation of integrations using Oracle Integration Cloud (OIC).
• Build App Driven, Scheduled, and Basic integrations.
• Develop REST/SOAP-based integrations with internal and external systems.
• Configure adapters (ERP Cloud, REST Adapter, FTP Adapter, ServiceNow, etc.).
• Design and implement orchestration, routing, transformations, and enrichment logic.

• Create and maintain data mappings using OIC mapper.
• Handle complex transformations (XSLT, lookups, enrich actions).
• Implement fault-tolerant transformations and null-handling logic.

• Implement end-to-end error handling, fault policies, and retries.
• Configure activity stream, tracking fields, and business identifiers.
• Monitor integrations using OIC Insight/Tracking dashboards.
• Troubleshoot and resolve runtime integration failures.

2. Security & Connectivity

• Configure secure connectivity using OCI Streaming, VPN, or FastConnect (as applicable).
• Manage OIC security artifacts: certificates, OAuth tokens, and integration security policies.
• Ensure integrations comply with enterprise security and compliance standards.

3. File-Based Integrations

• Develop inbound and outbound file-based integrations using OIC FTP adapter.
• Handle large files, batch processing, and scheduling.
• Implement file validation, archival, and purging mechanisms.

4. Testing & Deployment

• Perform unit testing and support SIT/UAT cycles.
• Prepare deployment artifacts and migrate integrations across environments (DEV → TEST → PROD).
• Support deployment activities and post-deployment validation.

5. Documentation & Knowledge Transfer

• Create and maintain technical design documents (TDDs).
• Document integration flows, mappings, endpoints, and error scenarios.
• Provide KT sessions and handover documentation to support teams.

6. Collaboration & Agile Delivery

• Participate in sprint planning, daily stand-ups, and backlog grooming.
• Collaborate with functional teams, ERP teams, and downstream system owners.
• Provide accurate effort estimates and delivery timelines.
• Support release cycles, patches, and OIC upgrades.
• Follow Oracle OIC best practices and enterprise integration standards.
• Ensure reusability of integrations and adherence to naming/versioning standards.
• Participate in design reviews and architecture governance forums.