OIC Senior Technical Consultant

Tata Consultancy Services; Dadri, Pune District, Bengaluru; On-site; INR 1,400,000 - 2,000,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced Oracle Integration Cloud (OIC) Consultant in India to design, develop, and support integrations across Oracle Fusion ERP, HCM, SCM, EPM, and external apps. You will implement end-to-end integrations, configure adapters, and develop APIs, with strong emphasis on data mappings and monitoring.

Ideal candidates have hands-on OIC experience, REST/SOAP API skills, and exposure to BI Publisher OTBI, SQL/PLSQL, and end-to-end cloud implementations.

Qualifications

• Hands-on experience with Oracle Integration Cloud (OIC)
• Experience integrating Oracle Fusion ERP/HCM/SCM/EPM applications
• REST APIs and SOAP Web Services expertise
• Experience with Oracle ERP Adapter, FTP/SFTP, Stage File and File Server adapters
• Knowledge of XML, JSON, XSLT, XPath
• Experience with BI Publisher (BIP) and OTBI
• Experience with SQL and PL/SQL
• Hands-on integration monitoring, error handling, and reprocessing frameworks
• Experience in at least one end-to-end Oracle Cloud implementation project

Responsibilities

• Design, develop, and implement end-to-end integrations using OIC
• Build App-Driven, Scheduled, File-Based, and Event-Based integrations
• Develop integrations between Oracle Fusion Cloud and external applications
• Configure and use OIC adapters (ERP, REST, SOAP, FTP/SFTP, Stage File, HCM)
• Develop and consume REST and SOAP APIs
• Work on data transformations using XML, JSON, XSLT, XPath and OIC Mapper
• Support SIT, UAT, deployment, Hypercare, and production support
• Troubleshoot integration failures, monitor OIC instances, and perform root cause analysis
• Collaborate with functional teams and stakeholders for solution design

Skills

Oracle Integration Cloud

REST APIs

SOAP Web Services

Oracle ERP Adapter

FTP/SFTP Adapter

Stage File Adapter

XML

JSON

XSLT

XPath

BI Publisher

OTBI

SQL

PL/SQL

End-to-end Oracle Cloud

Tools

Oracle Fusion ERP

OTBI

BI Publisher

Job description

We are looking for an experienced Oracle Integration Cloud (OIC) Consultant with strong expertise in designing, developing, and supporting integrations across Oracle Fusion ERP, HCM, SCM, EPM, and third-party applications. The ideal candidate should have hands-on experience with OIC integrations, REST/SOAP APIs, Oracle adapters, and enterprise integration architecture.

• Design, develop, and implement end-to-end integrations using Oracle Integration Cloud (OIC).
• Build App-Driven, Scheduled, File-Based, and Event-Based integrations.
• Develop integrations between Oracle Fusion Cloud (ERP/HCM/SCM/EPM) and external applications.
• Configure and use OIC adapters including:
  • ERP Adapter
  • REST Adapter
  • SOAP Adapter
  • FTP/SFTP Adapter
  • Stage File Adapter
  • HCM Adapter
• Develop and consume REST and SOAP APIs.
• Work on data transformations using XML, JSON, XSLT, XPath, and OIC Mapper.
• Support SIT, UAT, deployment, Hypercare, and production support activities.
• Troubleshoot integration failures, monitor OIC instances, and perform root cause analysis.
• Collaborate with functional teams and business stakeholders for solution design and implementation.

Mandatory Skills

• Strong hands-on experience with Oracle Integration Cloud (OIC).
• Experience integrating Oracle Fusion ERP/HCM/SCM applications.
• Strong expertise in REST APIs and SOAP Web Services.
• Experience with Oracle ERP Adapter, FTP/SFTP, Stage File, and File Server adapters.
• Knowledge of XML, JSON, XSLT, XPath.
• Experience with BI Publisher (BIP) and OTBI.
• Experience with SQL and PL/SQL.
• Hands-on experience with integration monitoring, error handling, and reprocessing frameworks.
• Experience in at least one end-to-end Oracle Cloud implementation project.