Data Engineer ODI
Core
Design and develop ETL/ELT processes using Oracle ODI to integrate data from multiple sources into Data Warehouse models.
Role type
Data Engineer (Oracle ODI)
Builds
Data Warehouse models and integrated data pipelines
Domain
Data Engineering / Oracle Ecosystem
Deliverable
production ML models | product features | dashboards & analysis
Required skills
Oracle Data Integrator (ODI), Advanced SQL, PL/SQL, Oracle Database, Dimensional modeling (Star/Snowflake), Incremental processes (SCD), Performance optimization, Troubleshooting
Responsibilities
Design and develop ETL/ELT processes, Build and maintain Mappings, Packages, Procedures, Variables and Load Plans, Integrate data from multiple sources, Optimize SQL loads and queries, Implement data quality controls and validation processes, Participate in deployments and support across DEV, QA and PROD environments