**Position: ETL Lead ODI Developer**
**Location: Maxico Remote**
**Duration: Full Time**
- 7 + years' experience in building function & store procedure using ODI tool.
- Design Data warehouse table and applicable documentation.
- Develop table creation scripts and execute the scripts for the Database Administrator (DBA).
- Analyse data sources and determine data relationships to pair with the business requirements documentation (BRD).
- Familiarity with data quality issues and Exact, Transform, Load (ETL) processes.
- Design and develop Extract Load Transform (ELT) process and load data from source tables into staging tables and then into target fact and dimension tables utilizing Oracle Data Integrator (ODI).




- Validate data loaded into various tables utilizing Structured Query Language (SQL) and other analysis.
- Knowledge and understanding of the applicable tools and practices used in data governance including query and data profiling techniques.
- Proven skills in data analysis - including queries to calculate data quality.
- Solid written, verbal, and analytical skills
- Strong research and problem determination and solution skills
- Versátil to work in Shifts (Rotational)
**Experience**:
- Oracle Data Integrator: 4 years (required)

📌 Oracle Data Integrator (Xico)
🏢 iLink Systems
📍 Xico