Lead Oracle HCM ETL Developer

  • Cleveland, OH
  • Posted 9 hours ago | Updated 9 hours ago

Overview

On Site
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 12 Month(s)

Skills

Agile
Data Flow
Data Integration
Data Integrity
Data Structure
Debugging
DevOps
Boomi
Business Process
Cloud Computing
Collaboration
Communication
HR Management System
MuleSoft
Oracle
Oracle Data Integrator
Oracle HCM
Documentation
Extract
Transform
Load
HDL
HR Management
Informatica
Regression Analysis
Regulatory Compliance
SQL
Scripting
Shell
SuccessFactors
PL/SQL
Performance Management
Performance Tuning
Python
Recruiting
SAP
Testing
Workday

Job Details

Lead Oracle HCM Developer Location: Cleveland, OH 44115 (Onsite)


Job Description
The candidate should have experience with Oracle HCM Cloud modules (i.e., Core HR, Workforce Compensation, Performance Management, Goal Setting, Career Development, Recruiting Cloud and Learning Cloud) and hands-on experience with the underlying HCM schema. They should be able to architect, build, and maintain robust data integration solutions for the Oracle HCM Cloud platform. This role is ideal for a hands-on developer with deep technical expertise in ETL frameworks, Oracle HCM data structures, and cloud-based integration tools.

Key Responsibilities

  • Design, develop, and optimize ETL processes to support seamless data flow between Oracle HCM Cloud and internal/external systems.
  • Build and maintain data pipelines using tools such as Oracle Data Integrator (ODI), Informatica, or Oracle Integration Cloud (OIC).
  • Develop and deploy HCM Extracts, HDL (HCM Data Loader) scripts, and BIP reports to support HR data operations.
  • Collaborate with HRIS, IT, and business teams to gather requirements and deliver scalable, secure, and high-performance data solutions.
  • Monitor ETL jobs, troubleshoot issues, and implement performance tuning strategies.
  • Ensure data integrity, compliance, and security across all HCM integrations.
  • Participate in system upgrades, patch testing, and regression validation.


Required Qualifications

  • 10+ years of experience in ETL development, with at least 5 years focused on Oracle HCM Cloud.
  • Strong proficiency in SQL, PL/SQL, and scripting languages (e.g., Shell, Python).
  • Hands-on experience with Oracle HCM APIs, HCM Extracts, HDL, and BIP.
  • Familiarity with cloud integration platforms such as Oracle Integration Cloud, Dell Boomi, or MuleSoft.
  • Strong understanding of HR data models and business processes.
  • Excellent debugging, documentation, and communication skills.


Preferred Qualifications

  • Oracle HCM Cloud certification(s).
  • Experience with Agile development methodologies and DevOps practices.
  • Exposure to other HCM platforms like Workday or SAP SuccessFactors.



Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.