Oracle EBS HRMS Technical Developer

Envision Technology Solutions; United States; On-site; USD 120,000 - 170,000; Full time

Job summary

Envision Technology Solutions is seeking an experienced Oracle EBS HRMS Technical Developer specializing in Payroll and OTL to design, implement, and optimize HRMS customizations, interfaces, and reports.

You will work with PL/SQL, Fast Formulas, APIs, OAF, and BI Publisher while providing production support and troubleshooting. The role involves close collaboration with functional teams to deliver robust HRMS solutions.

Qualifications

• 10+ years of hands-on development experience with Oracle EBS (R12 or later) focusing on HRMS.
• Strong command of PL/SQL, including APIs and performance tuning.
• Experience with Payroll technical development, including Fast Formulas.
• Hands-on experience with OTL technical components and time to payroll transfers.
• Experience building interfaces and conversions via file-based or API integrations.
• Proficiency with BI Publisher/XML Publisher, Oracle Forms/Reports, and Oracle Workflow.

Responsibilities

• Analyze functional specs for HR, payroll, and time processes and translate to technical designs.
• Develop and maintain customizations for Oracle EBS HRMS Payroll and OTL.
• Build and enhance Payroll fast Formulas and time entry rules.
• Design inbound/outbound interfaces using PL/SQL, web services, and file-based methods.
• Create data conversion programs for employees, assignments, and historical time data.
• Develop and customize Oracle Workflow components and BI/XML reports.
• Ensure security, provisioning, and API-based access control compliance.
• Troubleshoot production issues and provide root-cause analyses.
• Prepare design docs, unit tests, deployment instructions, and runbooks.

Tools

Oracle EBS (R12+)

PL/SQL

Fast Formulas

OAF

BI Publisher/XML Publisher

Oracle Workflow Builder

Oracle Forms and Reports

Job description

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.