> Markdown version of [/jobs/ext/3753466-oracle-ebs-hcm-payroll-techno-functional-consultant](https://www.wearedevelopers.com/jobs/ext/3753466-oracle-ebs-hcm-payroll-techno-functional-consultant). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Oracle EBS HCM/Payroll Techno-Functional Consultant

- **Company:** Usc, Inc.
- **Location:** United States (Remote available)
- **Experience:** Expert
- **Contract:** Contract
- **Skills:** Business Logic, Data Conversion, Extract Transform Load (ETL), Software Debugging, Human Resources Information System (HRIS), Oracle Databases, Oracle SQL Developer, E2e Testing, Standard Sql, SQL Databases, Oracle Ebusiness, Code Restructuring
- **Published:** October 15, 2026
- **Apply:** https://www.dice.com/job-detail/d027540d-f810-4417-9e98-d6a767198e05

## About the Role

* 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.

## Description

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.