Consultant
Job Description
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