Consultant

RAC is hiring a Functional consultant to produce integration design documentation for Oracle HCM implementations. This is a functional — not a developer — role. You will map HR data flows between Oracle HCM and third-party systems, produce Interface Design Documents, support integration testing, and maintain the interface inventory for your assigned engagement.

WHAT YOU WILL DO

• Elicit integration requirements from client HR and IT stakeholders — running interface workshops that go beyond what data flows where to capture trigger, frequency, error ownership, rejection handling, and the business consequence of a delayed or failed interface

• Produce complete Interface Design Documents for every in-scope integration — covering source and target systems, trigger, direction, frequency, field-level mapping with transformation rules and code conversions, error handling approach, volume estimates, and the reconciliation method

• Map Oracle HCM data objects to target system fields — knowing what is available via REST API, HCM Extract, and SOAP service respectively, and flagging mapping gaps where Oracle does not hold the attribute the target system needs

• Validate built integrations against IDD specifications — working with OIC developers to confirm the build matches the design, raising formal defects with evidence when it does not, and documenting approved deviations

• Prepare and execute integration test cases — positive, negative, and volume scenarios — and drive defects to resolution

Requirements

• 2–3 years of Oracle HCM or HRIS functional experience with integration exposure on at least one implementation project — has contributed to or produced IDDs in a delivery context

• Demonstrated ability to produce complete, developer-usable field mapping documents

• Working knowledge of Oracle HCM data model — knows what fields are available for integration across Core HR, Absence, Payroll, and Talent modules

• Experience working alongside OIC or middleware developers and understanding what they need from a functional specification to build without re-engagement

• Integration test case development experience