Logo
Capgemini USAAvance Consulting

Oracle EBS Techno-Functional Consultant

Capgemini USAAvance Consulting, Dallas, Texas, United States, 75215


Oracle EBS Techno-Functional Consultant (HR & Payroll) specializing in HR and Payroll modules, with in-depth knowledge of PL/SQL, Fast Formulas, payroll tables, and experience in data extraction. Familiarity with Data Lake is a plus. The ideal candidate will be responsible for supporting, configuring, and enhancing Oracle EBS HRMS and Payroll solutions, including the development of technical components and data management. ####

Key Responsibilities : - Provide techno-functional support for Oracle E-Business Suite HRMS and Payroll modules. - Analyze and design solutions to enhance Oracle EBS functionality based on business requirements. - Develop and modify PL/SQL code to support business processes and troubleshoot technical issues. - Configure and maintain Oracle EBS HR and Payroll modules, including elements, balances, payroll rules, and payroll tables. - Develop, maintain, and troubleshoot Fast Formulas for payroll calculations, validations, and reporting. - Collaborate with HR and Payroll teams to understand business requirements and provide system solutions. - Perform system testing, including unit testing, integration testing, and user acceptance testing. - Create technical documentation for custom developments and configurations. - Ensure data integrity, perform data extractions from Oracle EBS payroll tables, and migrate data to reporting tools or Data Lakes. - Work with data integration and extraction processes between Oracle EBS and external systems or Data Lakes. - Provide ongoing support for Oracle EBS HR and Payroll modules, troubleshooting issues and providing timely resolution. - Conduct training and knowledge sharing with end-users and team members. ####

Required Skills and Experience : -

5+ years of experience

working as an Oracle EBS Techno-Functional Consultant, with a focus on HRMS and Payroll modules. - Proficiency in

PL/SQL

for custom development and troubleshooting. - Extensive experience with Oracle EBS

Fast Formulas , including developing and maintaining payroll and HR formulas. - Strong understanding and experience with Oracle EBS

Payroll tables , including data extraction and reporting. - Strong understanding of Oracle EBS HRMS modules, including Core HR, Payroll, Self-Service HR, and Oracle Time and Labor (OTL). - Experience with Oracle EBS payroll processes, including elements, balances, payroll runs, and retro-pay. - Experience in

data extraction

from Oracle EBS and integration with other reporting tools or Data Lakes. - Ability to translate business requirements into technical specifications and configurations. - Familiarity with data migration and integration between Oracle EBS and other systems. - Excellent analytical, problem-solving, and communication skills. - Ability to work collaboratively in a team environment and interact with business users effectively. ####

Preferred Qualifications : - Experience with

Data Lakes

and extracting, transforming, and loading (ETL) data from Oracle EBS into Data Lakes or external reporting systems. - Experience with

Oracle Cloud HCM

or familiarity with migration from Oracle EBS to Cloud. - Knowledge of

BI Publisher , Oracle Reports, and other reporting tools. - Experience with Oracle Workflow and AME (Approval Management Engine). - Oracle EBS certification in HRMS or Payroll is a plus. ####

Education : - Bachelor’s degree in Computer Science, Information Technology, or related field.