Remote - Senior Oracle Fusion HCM OTL Technical Consultant

HYR Global Source Inc

United States

Remote

USD 140,000 - 180,000

Full time

37 hours ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

HYR Global Source Inc. seeks a highly experienced Oracle Fusion HCM Time & Labor (OTL) Technical Consultant. Must have hands-on Oracle OTL, PL/SQL, OIC REST APIs, ATP, and Redwood/VBCS experience.

This role focuses on time card data processing, validations, and complex integrations. Ideal candidates will troubleshoot production issues, perform data validation, and support end-to-end integrations across OTL, Payroll, and Expenses.

Qualifications

  • 8+ to 12+ years of experience required in Oracle Fusion HCM Time & Labor (OTL).
  • Hands-on technical and functional expertise in OTL, REST APIs, and integrations.
  • Strong SQL/PLSQL development, debugging, and performance tuning.
  • Experience with OIC integrations and Oracle ATP-based processing.

Responsibilities

  • Develop, enhance, and support Oracle Fusion Cloud Time & Labor, Payroll, and Expenses.
  • Build and troubleshoot OTL integrations using REST APIs and OIC.
  • Work with OTL tables/views (HWM_*) for troubleshooting and reporting.
  • Develop VBCS applications and Redwood UI extensions for time entry and approvals.
  • Provide production support and issue resolution for OTL-related deployments.

Skills

Oracle Fusion HCM OTL
SQL / PL/SQL
Oracle Integration Cloud (OIC)
Oracle REST APIs
Oracle ATP
OTL Data Model
VBCS / Redwood
HDL / OTBI / BI Publisher
Oracle Payroll & Expenses
Production Support

Job description

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.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Remote Job - Senior Oracle Fusion HCM OTL Technical Consultant - W2 Only
Remote Job - Senior Oracle Fusion HCM OTL Technical Consultant - W2 Only

HYR Global Source Inc • United States

Remote
USD 140,000 - 190,000
Remote Oracle Fusion HCM OTL Expert & Integrations Engineer
Remote Oracle Fusion HCM OTL Expert & Integrations Engineer

HYR Global Source Inc • United States

Remote
USD 140,000 - 180,000
Remote Oracle Fusion HCM OTL Expert (Time & Labor)
Remote Oracle Fusion HCM OTL Expert (Time & Labor)

HYR Global Source Inc • United States

Remote
USD 140,000 - 190,000
Oracle Fusion HCM Payroll/OTL Functional or Techno-Functional Consultant (Remote from Non-India/Non-Pakistan Locations)
Oracle Fusion HCM Payroll/OTL Functional or Techno-Functional Consultant (Remote from Non-India/Non-Pakistan Locations)

Remote • San Francisco (CA)

Remote
USD 120,000 - 180,000
Oracle HCM Consultant (OTL)
Oracle HCM Consultant (OTL)

Mastek Limited • United States

On-site
USD 100,000 - 140,000
Oracle EBS HRMS Technical Developer specializing in Oracle Payroll and OTL
Oracle EBS HRMS Technical Developer specializing in Oracle Payroll and OTL

Envision Technology Solutions • United States

On-site
USD 120,000 - 160,000
Oracle HCM OTL Consultant - Contract - Remote (100%) at Lorven technologies Remote
Oracle HCM OTL Consultant - Contract - Remote (100%) at Lorven technologies Remote

Lorven Technologies, Inc. • United States

Remote
USD 120,000 - 150,000
Oracle HCM Payroll Benefits and OTL Functional Lead
Oracle HCM Payroll Benefits and OTL Functional Lead

Volantsoft Inc • Lawrenceville (GA)

On-site
USD 120,000 - 190,000
Oracle EBS HRMS Technical Developer
Oracle EBS HRMS Technical Developer

Envision Technology Solutions • United States

On-site
USD 120,000 - 170,000
Remote Oracle Fusion HCM Payroll/OTL Consultant (Techno-Functional)
Remote Oracle Fusion HCM Payroll/OTL Consultant (Techno-Functional)

NextOvation • United States

Remote
USD 14,000 - 28,000