Elfonze Technologies

In a world of quantity, we offer quality...

ODI Consultant

ConsultantConsultantFull TimeRemoteTeam 201-500Since 2020H1B No SponsorCompany SiteLinkedIn

Location

United States

Posted

38 days ago

Salary

Not specified

6 yrs expEnglishCloudERPETLOracleSQL

Job Description

• Design and develop ODI 12c mappings, packages, and scenarios. • Build ELT/ETL processes for data integration and migration. • Develop integrations between source systems and target databases. • Implement incremental loads using CDC and journalizing. • Customize and manage Knowledge Modules (LKM, IKM, CKM, JKM). • Tune performance for high-volume batch data loads. • Configure and manage ODI Agents and job scheduling. • Monitor executions using ODI Operator and resolve failures. • Implement error handling, restartability, and logging mechanisms. • Support production deployments, enhancements, and issue resolution. • Work with functional and technical teams to gather integration requirements.

Job Requirements

  • 6+ years of experience in Oracle Data Integrator (ODI / ODI 12c)
  • Strong understanding of ELT and ETL concepts.
  • Hands-on experience with ODI mappings, packages, scenarios, and KMs.
  • Experience with CDC, journalizing, and incremental loads.
  • Strong SQL and performance tuning skills.
  • Experience integrating Oracle databases and flat files.
  • Knowledge of data warehousing and batch processing concepts.
  • Good troubleshooting and production support skills.
  • Nice to Have
  • Experience with Oracle Fusion ERP or EBS integrations using ODI.
  • Exposure to ADW and Oracle Cloud.
  • Experience with REST and file-based integrations in ODI.
  • Automation and scheduling experience.

Related Categories

Related Job Pages

More Consultant Jobs

ContractRemoteTeam 51-200

We are seeking a dynamic Pharmacometrics Consultant who will bring extensive expertise in quantitative pharmacology to our clinical stage programs. The ideal candidate will have a strong background in the applications of model-based drug development within the biotechnology or ph...

United States

Principal Consultant, Oracle CPQ

Arbi Arredobagno

The perfect design for every bathroom

Consultant38 days ago
Full TimeRemoteTeam 51-200Since 1987H1B No Sponsor

Oracle CPQ Principal Consultant performing hands-on solution architecture and development tasks

CloudERPOracleSOAP
Texas
$190K / year
Full TimeRemote

Do you want to build an impactful career to change the world for the better? Geosyntec has an exciting opportunity for a Senior Consultant - Air Quality and Environmental in our Energy/Energy Transition Operations. This position has the flexibility to work remotely from Ohio, Pen...

United States
Consultant38 days ago
Full TimeRemoteTeam 10,001+Since 1915H1B Sponsor

Consultant supporting development of pharmacy services for health systems

Pennsylvania