Oracle HCM - OIC Specialist

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 IntegrationDesign, 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 applicationsConfigure and manage Atom Feed subscriptions to capture and process HCM events (e.g., new hire, employee updates) in near real-timeEnsure integrations are performant, scalable, and resilient across enterprise landscapes API & Event-Driven IntegrationDesign and consume real-time REST/SOAP APIs for HCM data exchangeImplement event-driven architectures using Atom Feeds and OIC event-based triggersHandle integration to multiple downstream systems (e.g., payroll, benefits, finance, reporting platforms) Database ManagementWork extensively with Oracle Database, Microsoft SQL Server, and PostgreSQL for staging, extraction, and validation of integration dataDevelop and optimize complex SQL queries, stored procedures, and views to support integration workflowsPerform data validation, reconciliation, and troubleshooting across relational data storesExposure 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 dataWork with data validation, reconciliation, and troubleshooting across integrated systemsLeverage 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 troubleshootingDevelop and maintain shell scripts to automate integration jobs, file transfers, and operational tasksPerform 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 orchestrationFamiliarity with Master Data Management (MDM) concepts and tools for data governance and consistencyExposure 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 requirementsParticipate in design discussions and propose scalable, secure integration solutionsEnsure timely delivery aligned with project goals, HR calendar deadlines, and best practices

Support & Troubleshooting

Monitor OIC integration flows, troubleshoot failures, and perform root cause analysisSupport deployment processes and integration lifecycle management within OICMinimum 4 years of relevant experience in Oracle HCM integration and Oracle Integration Cloud (OIC)Strong hands-on experience with OIC integration flows, adapters, and connectionsProven experience configuring and consuming Oracle HCM Atom FeedsStrong experience with real-time and batch API integrations (REST/SOAP)Experience integrating Oracle HCM data to various downstream systemsGood understanding of ETL/ELT concepts and data integration patterns