ETL Lead ODI Developer

ETL Lead ODI Developer
Canada Remote
contract

Email: mohit@jconnectinc.com

Note:- looking for candidates those who are presently in Canada

Experience – 7+ years

Must have Skills:-
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)