Oracle Data Integration
Core
Design, develop, and debug complex ETL/ELT mappings and data warehouse implementations using Oracle Data Integrator (ODI).
Role type
Senior Data Integration Engineer (ODI)
Builds
End-to-end Data Warehouse implementations and ETL pipelines
Domain
Data Engineering / Enterprise Data Integration
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
ETL/ELT design, PL/SQL, ODI (Master/Work repositories, Designer, Operator), Knowledge Modules (KM) customization, topology and model layer setup, load planning, job scheduling, performance tuning, exception handling, data modeling
Preferred skills
Experience with flat files, Excel, XML, JSON, Oracle Database, SQL Server
Technologies
Oracle Data Integrator (ODI), OWB, PL/SQL, Oracle Database, SQL Server
Responsibilities
Design and develop complex ODI mappings, packages, and procedures; customize Knowledge Modules; set up topology and model layers; build objects in Designer and monitor Operator; develop load plans and schedule jobs; perform performance tuning of ODI mappings; handle exceptions in ODI; debug ETL mappings and unit test cases.
Seniority
Senior, hands-on IC