Required Skills
| Skill | Years of Experience | Expertise Level | Skill Requirement Level |
|---|---|---|---|
| ORACLE | 5+ | 4 | Required |
| HCM | 5+ | 4 | Required |
| Cloud | 5+ | 4 | Required |
| PL/SQL | 5+ | 4 | Required |
Job Description
Oracle Cloud Technical Resource
Minimum Requirements
Bachelor’s degree in Computer Science, Information Technology, Engineering, or a related field.
Five years of related experience in application programming, application development, or enterprise systems integration.
At least Five years of hands-on Oracle HCM Cloud technical experience, including:
HCM Data Loader (HDL)
BI Publisher (BIP) reports and data models
HCM Extracts
Oracle HCM tables, views, and data structures
Development and troubleshooting of HCM integrations and data loads
At least three years of hands-on SQL and PL/SQL development experience, including:
Writing and troubleshooting complex SQL queries
Developing PL/SQL packages, procedures, functions, and scripts
Data analysis, validation, and troubleshooting using SQL/PLSQL
Experience with Oracle Integration Cloud (OIC) or an equivalent integration platform, including development and support of integrations between Oracle HCM and external systems.
Demonstrated ability to independently analyze Oracle HCM data and identify appropriate tables, views, and relationships for integrations, reporting, and troubleshooting.
In lieu of the experience requirement, additional related education above and beyond what is required may be substituted on an equivalent year-for-year basis.
Additional Skills / Experience
Designs, develops, tests, and supports integrations for new and existing application functionality, with a strong focus on Oracle HCM Cloud and related enterprise applications, including ERP, EPM, and Salesforce.
Develops and supports Oracle HCM technical solutions, including HCM Data Loader (HDL), HCM Extracts, BI Publisher (BIP) reports and data models, and inbound and outbound HCM integrations.
Demonstrates strong knowledge of Oracle HCM tables, views, data structures, and effective-dated data, with the ability to identify appropriate data sources and relationships for integrations, reporting, and troubleshooting.
Demonstrates strong SQL and PL/SQL development skills, including writing and troubleshooting complex SQL queries and developing PL/SQL packages, procedures, functions, and scripts.
Designs, develops, and troubleshoots integrations using Oracle Integration Cloud (OIC), including integrations between Oracle HCM and internal or external applications.
Evaluates business requirements and translates them into effective technical designs and specifications.
Participates regularly in solution design and development efforts, providing technical expertise and recommendations throughout the development lifecycle.
Supports quality assurance activities, including unit and regression testing, development and documentation of test scripts, and use of Jira-based requirements and test-management processes.
Participates in code reviews and follows established development standards, source-code management practices, and change-control processes.
Troubleshoots complex application, integration, data, and performance issues and performs root-cause analysis to develop sustainable solutions.
Conducts regular reviews of systems and integrations to identify opportunities to improve performance and capabilities, reduce technical debt, and deliver additional business value.
Designs solutions that leverage shared and common services and establishes reusable components using service-oriented and API-based approaches.
Identifies technical and project risks and effectively communicates feasibility concerns, solution alternatives, dependencies, and potential impacts to project and senior management.
Collaborates with functional, application, infrastructure, security, and enterprise technology teams to ensure technical solutions meet organizational technology, security, supportability, architecture, and control standards.
Preferred Qualifications
Experience working in a hands-on development and production support role, with responsibility for designing, developing, deploying, maintaining, and supporting solutions throughout their lifecycle.
Demonstrated ability to independently troubleshoot and resolve production issues, perform root-cause analysis, implement fixes, and provide ongoing application and integration support.
Experience working in a small or lean technical team environment, with the ability to independently manage development assignments as well as day-to-day production support responsibilities.
Experience working across multiple Oracle HCM functional areas, preferably including Core HR, Payroll, Benefits, Absence, and Talent Management.
Experience designing and implementing end-to-end integrations between Oracle HCM and third-party/vendor systems, including inbound and outbound integrations.
Experience working with and transforming data from heterogeneous sources and formats, including flat files, XML, JSON, Excel, relational databases, REST/SOAP APIs, and external applications.
Experience developing and troubleshooting complex BI Publisher reports and data models spanning multiple HCM functional areas.
Experience with additional Oracle HCM technical capabilities such as Fast Formula, HCM Extracts, REST/SOAP APIs, and scheduled HCM processes.
Ability to work directly with functional and business teams to understand requirements, investigate issues, develop solutions, test changes, and support implementations.
Experience designing technical solutions for complex business requirements and recommending scalable, maintainable, and supportable solutions.