Oracle EBS 12.2.9 Payroll & Benefits Technical Consultant

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

Experience

Seniority level

Employment type

Job function

#J-18808-Ljbffr