Senior Software Engineer - 2 - Senior OIC Developer

Caratlane; Chennai District; On-site; INR 1,400,000 - 1,800,000; Full time

Job summary

Caratlane is seeking an experienced Oracle Integration specialist in Chennai to design, develop, and implement enterprise ERP integrations and extensions. You will lead technical architecture for scalable solutions across Oracle Fusion modules and external systems.

The role requires strong integration architecture, ERP customization, API-based integrations, and Oracle Cloud tech, with ability to guide teams and collaborate with stakeholders.

Qualifications

• 5 to 9 years of Oracle Fusion Cloud technical experience.
• Hands-on experience with Oracle Integration Cloud (OIC) Gen 2/3.
• Proficiency in Oracle APEX development and PL/SQL.
• Strong BI Publisher report development and OTBI analysis.
• Experience with REST/SOAP APIs and ESS Jobs.

Responsibilities

• Design, develop, and support integrations between Fusion modules and external systems using OIC.
• Build custom applications and extensions with Oracle APEX.
• Develop and optimize BI Publisher reports for Fusion modules.
• Troubleshoot data loads, REST/SOAP services, and ESS job scheduling.
• Collaborate with functional teams to translate requirements into designs.
• Enforce coding standards and security/data access policies.

Skills

Oracle Fusion Cloud

OIC Gen 2/3

Oracle APEX

BI Publisher

OTBI analysis

REST/SOAP APIs

PL/SQL

Oracle OCI basics

OAuth/JWT security

Tools

ORDS

Job description

We are looking for experienced expertise in Oracle Integration Cloud (OIC), Oracle APEX, and Oracle Fusion Applications to design, develop, and implement enterprise ERP integrations and extensions. The candidate will be responsible for driving technical architecture, and delivering scalable integration solutions across Oracle Fusion modules and external systems.

This role requires strong experience in integration architecture, ERP customization, API-based integrations, and Oracle Cloud technologies, along with the ability to guide teams and collaborate with functional stakeholders.

Responsibilities:

• Design, develop, and support integrations between Oracle Fusion, PAAS and legacy systems using OIC.
• Build and maintain custom applications and extensions using Oracle APEX to complement standard Fusion functionality.
• Develop and optimize BI Publisher (BIP) reports for Fusion SCM | FIN | MFG Modules and technical build activities.
• Develop and troubleshoot FBDI templates, REST/SOAP web services, ORDS and ESS job scheduling for data loads and process automation.
• Perform root-cause analysis and resolve integration failures, performance issues, and data discrepancies in production environments.
• Collaborate with functional consultants to translate business requirements into technical design documents (MD50/TD).
• Ensure adherence to coding standards, integration best practices, and security/data access policies (OAuth, roles).

Required Skills:

• 5 to 9 years of Oracle experience in Oracle Fusion Cloud technical.
• Strong hands-on experience in Oracle Integration Cloud (OIC) Gen 2/Gen 3, including Agents, Adapters, connections, orchestration, and error handling.
• Proficient in Oracle APEX application development pages, regions, interactive grids, dynamic actions, PL/SQL.
• Strong expertise in BI Publisher (BIP) report development and OTBI analysis.
• Working knowledge of Oracle Fusion Manufacturing and Procurement modules (functional flows and underlying data model).
• Extensive experience on REST/SOAP APIs, ESS Jobs, SQL and PL/SQL.
• Exposure to Oracle Cloud Infrastructure (OCI) components (ATP, Object Storage, API Gateway) is an added advantage.
• Familiarity with Oracle Fusion security (roles, data access sets, OAuth/JWT).