ETL ODI Developer

Requirements5 + 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).Analyze data sources and determine data relationships to pair with the business requirements documentation (BRD).Familiarity with data quality issues and Exact, Transform, Load (ETL) processesDesign 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 techniquesProven skills in data analysis – including queries to calculate data quality.Solid written, verbal, and analytical skillsStrong research and problem determination and solution skills

Key Skills

• SQL