Oracle EBS HRMS Technical Developer specializing in Oracle Payroll and OTL

Envision Technology Solutions

United States

On-site

USD 120,000 - 160,000

Full time

45 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

Envision Technology Solutions is seeking an experienced Oracle EBS HRMS Technical Developer specializing in Oracle Payroll and OTL.

You will develop customizations, interfaces, reports, workflows, and integrations within Oracle EBS R12, working closely with functional teams to deliver HRMS solutions using PL/SQL, Fast Formulas, APIs, OAF, and BI Publisher, while providing production support and troubleshooting.

Qualifications

  • 10+ years of hands-on Oracle EBS development with HRMS focus.
  • Strong PL/SQL expertise including packages, procedures, triggers, and tuning.
  • Payroll technical development, Fast Formulas, and OTL components experience.
  • Experience with interfaces, conversions, and integrations (file-based and API-based).

Responsibilities

  • Analyze functional specs for HR, payroll, and time and labor processes and translate to technical designs.
  • Develop and maintain customizations for Oracle EBS HRMS modules including Payroll and OTL.
  • Build and enhance Payroll fast Formulas and time entry rules.
  • Design and develop inbound/outbound interfaces and data conversion programs.
  • Create and tune reports (BI Publisher/XML Publisher, Oracle Reports).
  • Implement HRMS security components and API-based provisioning.
  • Troubleshoot production issues and provide root-cause analyses.

Skills

PL/SQL
Fast Formulas
APIs
OAF
BI Publisher
Oracle Forms
Oracle Reports
Concurrent programs
Payroll
OTL

Tools

Oracle EBS
Oracle Workflow Builder
BI/XML Publisher
Oracle Forms
Oracle Reports
SQL*Loader
UTL_FILE

Job description

Oracle EBS HRMS Technical Developer specializing in Oracle Payroll and OTL

Contract

Role Summary

We are seeking an experienced Oracle EBS HRMS Technical Developer specializing in Oracle Payroll and OTL, responsible for developing customizations, interfaces, reports, workflows, and integrations within Oracle EBS R12. Works closely with functional teams to deliver HRMS solutions using PL/SQL, Fast Formulas, APIs, OAF, and BI Publisher while providing production support and troubleshooting.

Key Responsibilities:
  • Analyze functional specifications for HR, payroll, and time and labor processes and translate them into technical designs.
  • Develop and maintain customizations for Oracle EBS HRMS modules, including Payroll and OTL, using PL/SQL, Oracle Forms, Oracle Reports, and Oracle Application Framework (OAF).
  • Build and enhance Oracle Payroll fast Formulas (element input validation, skip rules, proration, formula results, and balance calculations).
  • Develop OTL technical components, including timecard layout extensions, HXC/HXT time entry rules and validations, retrieval rule extensions, and time transfer processes to Payroll (BEE, Payroll Retro-Notification).
  • Design and develop inbound and outbound interfaces (time clock integrations, bank and payment files, GL and costing interfaces, third-party benefits and statutory feeds) using PL/SQL, concurrent programs, SQL*Loader, UTL_FILE, and web services.
  • Build data conversion and migration programs for employees, assignments, elements, balances, and historical time data, including validation and reconciliation scripts.
  • Develop and customize Oracle Workflow components for timecard approvals, notifications, and HR processes.
  • Create and tune reports (BI Publisher/XML Publisher, Oracle Reports) for payroll registers, statutory reporting, time summaries, and audit needs.
  • Implement HRMS security-related technical components, including custom security profiles, responsibility and data access controls, and API-based user provisioning.
  • Use seeded HR APIs (e.g., hr_assignment_api, hr_person_api, element entry APIs) in place of direct table updates, in line with Oracle best practices.
  • Troubleshoot and resolve production issues, including failed payroll processes, transfer errors, interface failures, and performance bottlenecks, with documented root-cause analysis.
  • Prepare technical design documents, unit test scripts, deployment instructions, and support runbooks, and conduct knowledge transfer to support teams.
  • Follow development standards, version control, and migration processes across environments.
Required Qualifications:
  • 10+ years of hands-on technical development experience with Oracle EBS (R12 or later), with a significant focus on HRMS.
  • Strong command of PL/SQL, including packages, procedures, triggers, APIs, and SQL performance tuning.
  • Proven experience with Oracle Payroll technical development, including Fast Formulas, element and balance setup impacts, payroll process troubleshooting, and costing and payment interfaces.
  • Hands-on experience with Oracle Time and Labor (OTL) technical components, including timecard layouts, time entry rules, approval workflows, and the transfer of time to Payroll.
  • Working knowledge of Core HR data model and APIs (people, assignments, organizations, absence management).
  • Experience with Oracle Workflow Builder, BI/XML Publisher, Oracle Forms and Reports, and concurrent program development.
  • Experience building interfaces and conversions, including file-based and API-based integrations
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Oracle EBS HRMS Technical Developer
Oracle EBS HRMS Technical Developer

Envision Technology Solutions • United States

On-site
USD 120,000 - 170,000
Senior Oracle EBS HRMS Developer — Payroll & OTL
Senior Oracle EBS HRMS Developer — Payroll & OTL

Envision Technology Solutions • United States

On-site
USD 120,000 - 160,000
Senior Oracle EBS HRMS Tech Developer - Payroll & OTL
Senior Oracle EBS HRMS Tech Developer - Payroll & OTL

Envision Technology Solutions • United States

On-site
USD 120,000 - 170,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
Remote - Senior Oracle Fusion HCM OTL Technical Consultant
Remote - Senior Oracle Fusion HCM OTL Technical Consultant

HYR Global Source Inc • United States

Remote
USD 140,000 - 180,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 HCM Consultant (OTL)
Oracle HCM Consultant (OTL)

Mastek Limited • United States

On-site
USD 100,000 - 140,000
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
Oracle EBS Developer (Hybrid Remote)
Oracle EBS Developer (Hybrid Remote)

TECHEAD • Richmond (VA)

Hybrid
USD 103,000 - 109,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