Oracle EBS HCM/Payroll Techno-Functional Consultant

Environment: The client has established extraction and ETL logic, but functional gaps and defects have surfaced across HRMS and Payroll conversion extracts. Additional hands-on Oracle EBS expertise is needed to remediate issues, validate configurations, and support testing and reconciliation efforts., * Troubleshoot and resolve defects within existing Oracle EBS HRMS and Payroll SQL extracts.

• Review and refactor extraction logic across employee/person data, assignments, positions, jobs, benefits, compensation, and payroll.
• Analyze Payroll configurations including recurring/nonrecurring elements, deductions, garnishments, tax profiles, and YTD balances.
• Independently navigate Oracle EBS tables, relationships, and configurations to identify data discrepancies.
• Review functional requirements and conversion mappings; recommend and implement updates to extraction logic.
• Partner with Informatica Data Architects to transition corrected SQL extracts into automated routines (IDMC/CDI).
• Support end-to-end testing, reconciliation, and defect closure.

• 8+ years of work experience with SQL
• 8+ years of work experience with Oracle Database
• Deep Oracle EBS HCM & Payroll functional and technical expertise.
• Advanced Oracle SQL development, debugging, and extraction experience.
• Strong understanding of HR and Payroll data structures, dependencies, and business logic.
• Experience troubleshooting ERP/HCM data conversion issues.
• Ability to independently investigate, diagnose, and resolve complex technical/functional problems.
• Functional expertise: Payroll elements, deductions, compensation, employee data.
• Technical expertise: Advanced Oracle SQL for debugging, refactoring, and remediation.