Oracle Integration Cloud Developer

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

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.