Requirements :

- 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).

- 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) 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)