ODI Developer

at  iLink Systems Inc

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

Please refer the Job description for details