(14+years) Data Engineer–Oracle HCM, ODI & LLMs

Data Engineer – Oracle HCM, ODI & LLMs (14+years)
Remote

Data Engineers with ERP and ETL background like Oracle HCM and ODI plus knowledge of LLMs.

Role overview

We’re looking for a Data Engineer with a strong background in ERP data and ETL to build and maintain reliable data integrations and pipelines. The ideal candidate has experience working with Oracle HCM data and ODI, alongside an understanding of large language models (LLMs) and how they can support practical data and business workflows.

Responsibilities

• Design, develop, and maintain data pipelines and integrations across Oracle HCM and downstream systems.
• Build and support ETL/ELT workflows using Oracle Data Integrator(ODI) and related tools.
• Extract, transform, validate, and load data from ERP and other enterprise sources.
• Work with HR, business, and technical teams to understand data requirements and translate them into scalable solutions.
• Develop data mappings, transformation logic, reconciliation checks, and error-handling processes.
• Monitor pipeline performance, investigate data quality issues, and resolve production incidents.
• Document data flows, technical designs, dependencies, and operational procedures.
• Identify suitable opportunities to apply LLMs to data engineering or ERP workflows, such as metadata discovery, documentation, data querying, or process automation.
• Evaluate LLM outputs carefully, with attention to data privacy, security, accuracy, and governance.

Required qualifications

• Professional experience in data engineering, ETL development, or enterprise data integration.
• Experience with Oracle HCM data structures, extracts, integrations, or reporting.
• Hands-on experience with ODI and ETL concepts such as mappings, packages, load plans, and error handling.
• Strong SQL skills and experience with relational databases.
• Understanding of data modeling, data quality, reconciliation, and pipeline monitoring.
• Familiarity with APIs, file-based integrations, and common enterprise data formats such as CSV, XML, and JSON.
• Working knowledge of LLMs, including their capabilities and limitations; practical exposure to LLM tools, APIs, or use cases is a plus.
• Strong troubleshooting, communication, and documentation skills.

Preferred qualifications

• Experience with Oracle Fusion HCM Cloud integrations, HCM extracts, or related Oracle tools.
• Knowledge of Oracle Cloud Infrastructure or another cloud data platform.
• Experience with Python or another scripting language for automation and data processing.
• Familiarity with REST APIs, Git, CI/CD, and data governance practices.
• Exposure to retrieval-augmented generation (RAG), embeddings, or vector databases.
• Experience applying AI responsibly to sensitive HR or enterprise data.

Success measures

• Reliable, well-documented integrations that meet business requirements.
• Improved data quality, reconciliation, and pipeline observability.
• Timely resolution of integration issues and production incidents.
• Practical, secure use of LLM capabilities where they add measurable value

 Best Regards,
Praveen