Oracle HCM - OIC Specialist

Ford Business Solutions; Chennai District; On-site; INR 1,200,000 - 2,000,000; Full time

Job summary

Ford Business Solutions seeks an experienced Oracle HCM OIC Integration Specialist to design, develop, and support integrations between Oracle HCM and enterprise applications. The role focuses on OIC, REST/SOAP APIs, Atom Feeds, and ETL workflows to enable HR data exchange and reporting.

You will work with Unix/Linux scripting, SQL databases, and middleware like Informatica, MDG/MDM as advantageous, contributing to scalable, reliable HR technology integrations.

Qualifications

• Minimum 4 years of relevant experience in Oracle HCM integration and Oracle Integration Cloud (OIC).
• Strong hands-on experience with OIC integration flows, adapters, and connections.
• Proven experience configuring and consuming Oracle HCM Atom Feeds.
• Strong experience with real-time and batch API integrations (REST/SOAP).
• Experience integrating Oracle HCM data to various downstream systems.
• Good understanding of ETL/ELT concepts and data integration patterns.

Responsibilities

• Design, develop, and maintain integrations between Oracle HCM and downstream/upstream systems using OIC.
• Build real-time and batch integration flows leveraging OIC adapters for Oracle Fusion applications.
• Configure Atom Feed subscriptions to capture HCM events in near real-time.
• Ensure integrations are performant, scalable, and resilient across enterprise landscapes.
• Design and consume real-time REST/SOAP APIs for HCM data exchange.
• Collaborate with cross-functional teams to deliver reliable HR technology integrations.
• Monitor OIC flows, troubleshoot failures, and support deployment processes.

Skills

OIC (Oracle Integration Cloud)

REST APIs

SOAP APIs

Atom Feeds

Unix/Linux scripting

SQL & Databases

ETL concepts

Tools

Informatica

MDM

MongoDB

Job description

We are seeking an experienced Oracle Integration Cloud (OIC) Specialist to design, develop, and support integrations between Oracle HCM and enterprise applications. The ideal candidate will have strong expertise in OIC, REST/SOAP APIs, Oracle HCM Atom Feeds, database technologies, and Unix/Linux scripting.

This role involves building scalable integration solutions, troubleshooting complex issues, and collaborating with cross-functional teams to deliver reliable HR technology integrations.

Experience with Informatica, MDM, ETL processes, and AI-enabled HCM capabilities will be an added advantage.

4-6 Years of Experience

Key Responsibilities

Oracle HCM OIC Integration

• Design, develop, and maintain integrations between Oracle HCM and downstream/upstream systems using Oracle Integration Cloud (OIC)
• Build and manage real-time and batch integration flows leveraging OIC pre-built adapters for Oracle Fusion applications
• Configure and manage Atom Feed subscriptions to capture and process HCM events (e.g., new hire, employee updates) in near real-time
• Ensure integrations are performant, scalable, and resilient across enterprise landscapes

API Event-Driven Integration

• Design and consume real-time REST/SOAP APIs for HCM data exchange
• Implement event-driven architectures using Atom Feeds and OIC event-based triggers
• Handle integration to multiple downstream systems (e.g., payroll, benefits, finance, reporting platforms)

Database Management

• Work extensively with Oracle Database, Microsoft SQL Server, and PostgreSQL for staging, extraction, and validation of integration data
• Develop and optimize complex SQL queries, stored procedures, and views to support integration workflows
• Perform data validation, reconciliation, and troubleshooting across relational data stores
• Exposure to MongoDB or other NoSQL databases is a plus, where downstream systems require document-based storage

Data Integration ETL

• Support data integration workflows, including extraction, transformation, and loading (ETL/ELT) of HCM data
• Work with data validation, reconciliation, and troubleshooting across integrated systems
• Leverage middleware tools (e.g., Informatica) where applicable for complex data movement and transformation

Unix/Linux Scripting

• Work in Unix/Linux environments for job execution, scheduling, monitoring, and troubleshooting
• Develop and maintain shell scripts to automate integration jobs, file transfers, and operational tasks
• Perform log analysis and root cause diagnostics using command-line tools

Middleware, MDM AI Exposure (Added Advantage)

• Exposure to Informatica or similar middleware platforms for integration orchestration
• Familiarity with Master Data Management (MDM) concepts and tools for data governance and consistency
• Exposure to AI/ML capabilities within Oracle HCM (e.g., Oracle HCM AI features) or broader integration intelligence is a plus

Collaboration Delivery

• Collaborate with HR business stakeholders, architects, and cross-functional teams to gather integration requirements
• Participate in design discussions and propose scalable, secure integration solutions
• Ensure timely delivery aligned with project goals, HR calendar deadlines, and best practices

Support Troubleshooting

• Monitor OIC integration flows, troubleshoot failures, and perform root cause analysis
• Support deployment processes and integration lifecycle management within OIC

• Minimum 4 years of relevant experience in Oracle HCM integration and Oracle Integration Cloud (OIC)
• Strong hands-on experience with OIC integration flows, adapters, and connections
• Proven experience configuring and consuming Oracle HCM Atom Feeds
• Strong experience with real-time and batch API integrations (REST/SOAP)
• Experience integrating Oracle HCM data to various downstream systems
• Good understanding of ETL/ELT concepts and data integration patterns