Job Title: Oracle EBS HCM/Payroll TechnoFunctional Consultant
Location: Dallas TX (Hybrid)
Duration: 12 Months
New Capgemini Onboarding Process Updates:
Due to additional onboarding requirements a meet and greet is required for all new hires.
Selected candidates must be willing to go to the closest Capgemini/Client office location as indicated by the project team to meet and greet with a Capgemini team member prior to starting their assignment.
If the candidate is not local Capgemini will pay the expenses.
Job Description:
Specializing in HR and Payroll modules with indepth 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 TechnoFunctional Support for Oracle EBusiness 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 endusers and team members.
Required Skills & Experience:
5 years of experience working as an Oracle EBS TechnoFunctional 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 SelfService HR and Oracle Time and Labor (OTL).
Experience with Oracle EBS payroll processes including elements balances payroll runs and retropay.
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 problemsolving 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:
Bachelors degree in Computer Science Information Technology or related field.