Oracle Integration Developer

Title: OIC Developer

Location: Remote

Duration: 6-9 months with possibility to extend

We are seeking an experienced Oracle Integration Cloud (OIC) Developer to design, develop, and support enterprise integrations between Oracle E-Business Suite (EBS), Oracle Fusion Financials. The ideal candidate will have strong experience building integrations using Oracle Integration Cloud, working with Oracle Autonomous Transaction Processing (ATP) databases, and developing modern user interfaces leveraging Oracle Redwood framework and JavaScript. This role requires hands-on expertise in integration development, database programming, cloud-based services, and enterprise application integration patterns to support a modern finance and HR systems landscape.

Key Responsibilities

Integration Development

· Design, develop, and support integrations using Oracle Integration Cloud (OIC) connecting Oracle E-Business Suite (EBS), Oracle Fusion Financials, and SaaS applications.

· Design and develop integrations using Oracle Integration Cloud (OIC) including orchestrations, REST/SOAP integrations, file-based integrations, and process automations.

· Architect end-to-end integration solutions leveraging OCI services such as Object Storage, Queue, Streaming, Vault, API Gateway, OCI Functions, Event Service Rules, and ATP.

· Implement secure authentication and authorization using OAuth, API security policies, and secret management via OCI Vault.

· Build event-driven and asynchronous integration patterns using OCI Queue, Streaming, and Event Rules under Observability & Management.

· Develop and maintain VBCS applications for UI extensions.

· Configure and manage SFTP servers for file-based integrations and secure data exchange.

· Work with Object Storage for file ingestion, archival, and integration triggers.

· Implement logging, monitoring, and troubleshooting using OCI Event Logs and OIC monitoring tools.

· Integrate with Autonomous Transaction Processing (ATP) for data persistence, transformations, and transactional workflows.

· Manage user provisioning, including Okta group assignments, role mapping, and access governance for integration components.

· Develop and deploy OCI Functions for serverless compute use cases and custom logic extensions.

· Configure and manage API Gateway for routing, throttling, authentication, and exposure of integration services.

· Ensure best practices for performance, scalability, security, and reusability across all integration components.

· Solid understanding of data encryption and secure transmission protocols, particularly PGP and SSH.

· Hands on Experience in developing banking Integrations

· Communicate with internal stakeholders, external vendors, and cross-functional teams to deliver solutions aligned with business needs.

· Develop and maintain detailed documentation for systems, processes, and integration points.

· Collaborate with solution architects and functional teams to design scalable integration architectures.

· Support system testing, troubleshooting, and issue resolution during implementation and production support.

· Write and maintain modern user interfaces using JavaScript and Oracle Redwood framework, ensuring a seamless user experience across applications.

· Develop database logic using SQL and PL/SQL for data transformation and integration processing.

· Utilize ATP database packages such as DBMS_CLOUD and other ATP utilities to integrate with OCI Object Storage.

· Implement data ingestion and extraction processes between cloud services and enterprise systems.

· Optimize database queries and integration performance for large-scale data processing.

Required Qualifications

· 7+ years of hands-on experience with Oracle Financials R12.2, SQL, PL/SQL, Shell scripting, Python, XML, XSLT, CSS, JavaScript, and BIP.

· 5+ years of hands-on experience with OIC integration development with Fusion and SaaS applications including Coupa, Concur, Engie

· Hands-on experience in syncing fusion data to ATP using BICC or RODS

· Proven experience with Queue, Streaming, Vault, API Gateway, OCI Functions, Event Service Rules, PGP encryption and ATP.

· Strong expertise in SQL and PL/SQL development.

· Experience building integrations using REST APIs, SOAP services, and file-based integration methods.

· Experience participating in and leading OnPrem to Oracle Fusion Cloud migration projects.

· Strong analytical, problem-solving, and interpersonal (verbal and written) communication skills.

· Ability to manage multiple priorities in a fast-paced environment with moderate to low supervision.

· Experience utilizing Fusion integration with Banking institutions like JPM is a plus