Senior Software Engineer - II

CaratLane Trading Private Limited; Chennai District; On-site; INR 3,500,000 - 5,000,000; Full time

Job summary

CaratLane Trading Private Limited in Chennai invites a senior Oracle integration specialist to design, develop, and implement enterprise ERP integrations using OIC and APEX.

You will drive technical architecture, deliver scalable integrations across Fusion modules and external systems, and guide teams with security-conscious, API-based solutions.

The role demands hands-on experience with REST/SOAP, BIP/OTBI, and OCI components, with strong collaboration with functional stakeholders.

Qualifications

• 6–10 years of Oracle Fusion Cloud technical experience.
• Hands-on Oracle Integration Cloud Gen 2/3 with agents, adapters, connections, orchestration, and error handling.
• Proficient in Oracle APEX 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).

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).

Skills

Oracle Fusion Cloud

Oracle Integration Cloud

Oracle APEX

BI Publisher

OTBI analysis

REST APIs

SOAP APIs

PL/SQL

SQL

OCI

OAuth/JWT

Security roles

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:

• 6–10 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).