Position: ETL Lead ODI Developer Location: Canada/ Remote Duration: Full Time Job Description: · 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 · Flexible to work in Shifts (Rotational) Job Type: Full-time Pay: $19.15-$50.00 per hour Schedule: 8 hour shift