Oracle EBS 12.2.9 Payroll & Benefits Technical Consultant

Pentangle Tech Services | P5 Group; Estado de México; On-site; MXN 1,122,334 - 1,496,445; Full time

Job summary

A leading tech consulting firm is seeking a skilled Oracle EBS 12.2.9 Payroll Technical Consultant in Mexico, Estado de México. This full-time role requires extensive experience in Oracle EBS Payroll solutions, specifically focusing on development, integration, and troubleshooting technical aspects. Ideal candidates will possess strong skills in SQL, PL/SQL, and API integration, along with 8+ years in Oracle EBS, ensuring efficient payroll operations. Join us to enhance payroll functionalities and customer satisfaction.

Qualifications

• 8+ years of technical experience in Oracle EBS, focusing on Payroll.
• Experience developing RICE components for Payroll & Benefits functionality.
• Strong analytical and troubleshooting skills in a technical Payroll context.

Responsibilities

• Develop and customize Oracle EBS Payroll and Benefits solutions.
• Design, build, and manage interfaces between Oracle EBS Payroll and other systems.
• Resolve technical issues in Payroll & Benefits and conduct root cause analysis.

Skills

Oracle EBS Payroll

SQL

PL/SQL

APIs

Problem-solving

Technical troubleshooting

Education

Bachelor’s degree in Computer Science or related field

Tools

Oracle EBS

REST/SOAP APIs

MuleSoft

Putty

WINSCP

Job description

Overview

Oracle EBS 12.2.9 Payroll & Benefits Technical Consultant

We are looking for a highly skilled Oracle EBS 12.2.9 Payroll Technical Consultant with expertise in developing, coding, and managing interfaces within the payroll and benefits module, specifically for US Payroll. The role focuses on the technical side of Payroll, including development of custom solutions, integrations, and interface management.

Key Responsibilities

• Payroll Technical Development: Develop and customize Oracle EBS Payroll & Benefits solutions through coding and configuration, focusing on earnings, deductions, tax calculations, and costings.
• Create and maintain RICE components (Reports, Interfaces, Conversions, Extensions) within the payroll & benefits module to meet business and regulatory needs.
• Perform development tasks using SQL, PL/SQL, and Oracle EBS APIs specific to Payroll & Benefits functionalities.
• Experience in User Hooks, Web ADI and APIs in HRMS.
• Proficient in writing stored procedures, packages, triggers using PL/SQL, SQL, and shell scripting.
• Experience in Putty and WINSCP shell scripting.
• Development of outbound interfaces from scratch as per business requirements.
• Experience in XML bursting as per business requirements and file attachment mail sent using bursting.
• Experience in writing Payroll, Benefits & Absence Accrual new Fast Formulas and debugging those formulas.
• Developing interfaces to integrate employees and master data from SaaS HCM to Oracle EBS using MuleSoft/OIC and pushing them to other downstream applications (outbound interfaces).

• Interface and Integration Management: Design, build, and manage interfaces between Oracle EBS Payroll and other HR, Financial, and external systems, ensuring seamless data flow.
• Collaborate with cross-functional teams to develop integration points and resolve interface-related issues.
• Use web services, REST/SOAP APIs, and other tools to integrate Oracle Payroll with third-party systems.

• Technical Troubleshooting & Support: Resolve technical issues in Payroll & Benefits, including performance tuning, data discrepancies, and calculation errors.
• Conduct root cause analysis for Payroll interface issues and implement long-term fixes.
• Provide production support for technical aspects of Payroll, troubleshooting errors and ensuring smooth functionality.

• Testing & Documentation: Prepare and execute test scripts for Payroll & Benefits configurations and customizations, ensuring robust integration and accurate calculations.
• Document technical specifications, configurations, and code for interfaces and custom Payroll solutions.
• Ensure solutions are tested, documented, and meet compliance requirements.

Required Skills

• Technical Proficiency in Oracle Payroll: Advanced skills in SQL, PL/SQL, and Oracle EBS APIs specific to Payroll and Benefits.
• Hands-on experience developing RICE components, particularly for Payroll & Benefits functionality.
• Strong understanding of Oracle Workflow, Oracle Forms, and XML Publisher for report generation.
• Interface & Integration Skills: Experience with Payroll & Benefits-related interfaces and integration tools.
• Familiarity with REST/SOAP APIs, data mapping, and ETL tools for integration.
• Problem-Solving & Communication: Strong analytical and troubleshooting skills in a technical Payroll context.
• Ability to work closely with functional teams, translating technical solutions effectively.

Experience

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• 8+ years of technical experience in Oracle EBS, with at least 5 years focused on EBS Payroll & Benefits development, particularly for US.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Finance