Location: 100% Remote USA
Work Authorization: U.S. Citizens and Green Card Holders preferred, all valid work authorizations may apply
Working Hours: Must work Eastern Time (ET) business hours
Experience: 8 12+ Years Preferred
Position Summary: We are seeking a highly experienced, hands-on Oracle Fusion HCM Time & Labor (OTL) Technical Consultant with strong expertise in PL/SQL, Oracle Integration Cloud (OIC), REST APIs, Oracle Autonomous Transaction Processing (ATP), VBCS, and Redwood. This is a highly technical, integration-heavy role focused on Oracle Time & Labor, time card data processing, custom validations, integrations, and post-go-live production support.
We are NOT looking for a purely functional Oracle HCM consultant or a generic OIC developer. The ideal candidate must have deep knowledge of Oracle OTL functionality, underlying data structures, time card APIs, and hands‑on experience developing and troubleshooting complex integrations.
Key Responsibilities
Oracle Fusion OTL Technical Development & Support
- Develop, enhance, and support Oracle Fusion Cloud Time & Labor (OTL), Payroll, and Expenses.
- Strong knowledge of OTL architecture, time cards, time entry, calculation rules, processing profiles, and approval workflows.
- Work with OTL tables and views, including HWM_* structures, for troubleshooting and reporting.
- Develop integrations using Oracle HCM REST APIs to create, update, validate, and load time card data.
- Troubleshoot time card import failures, duplicates, calculation errors, approval issues, and Payroll transfer discrepancies.
PL/SQL, OIC, ATP & Integrations
- Develop and optimize complex SQL, PL/SQL procedures, packages, functions, and validations.
- Build Oracle ATP and OIC integrations using REST/SOAP APIs, orchestration, mappings, transformations, and exception handling.
- Integrate external timekeeping systems with Fusion OTL using REST APIs, ATP staging tables, and OIC.
- Implement data validation, error logging, retry, duplicate prevention, and reconciliation mechanisms.
- Support integrations across OTL, Payroll, Expenses, and third-party applications.
VBCS, Redwood, HDL & Reporting
- Develop VBCS applications, Redwood UI extensions, and custom components for time entry, approvals, and exception management.
- Support HDL, HCM Extracts, OTBI, and BI Publisher for data loading, integrations, and reporting.
- Develop SQL-based reports and reconciliation queries for time cards, payroll, and integration monitoring.
Production Support & Troubleshooting
- Handle complex production issues involving OTL, Payroll, Expenses, and integrations.
- Perform root‑cause analysis using SQL, PL/SQL, API payloads, OIC monitoring, ATP, and Oracle HCM diagnostic tools.
- Support production fixes, regression testing, quarterly updates, and deployments.
- Collaborate with functional consultants, Payroll teams, business users, and integration architects.
Required Technical Skills Must Have
- Oracle Fusion HCM Time & Labor (OTL): Strong hands‑on technical and functional understanding.
- SQL / PL/SQL: Expert-level development, debugging, performance tuning, procedures, packages, and custom validations.
- Oracle Integration Cloud (OIC): Extensive hands‑on experience building and troubleshooting complex integrations.
- Oracle REST APIs: Proven experience creating, updating, and processing Oracle HCM time card data through supported APIs.
- Oracle ATP Database: Strong experience with custom tables, PL/SQL packages, staging, validation, and integration processing.
- OTL Data Model: Strong understanding of underlying HWM_* tables/views, time card data structures, and transaction processing.
- VBCS / Redwood: Hands‑on development or extension experience.
- HDL, HCM Extracts, OTBI, BI Publisher: Experience with HCM data integration and reporting.
- Oracle Payroll & Fusion Expenses: Strong understanding of downstream integrations and production troubleshooting.
- Production Support: Proven experience resolving complex OTL technical issues in live enterprise environments.