7-10 years
Mumbai, Delhi/Ncr, Bangalore / Bengaluru
Lead ETL ODI Developer
Kovan Tech Solutions
posted 13hr ago
Key skills for the job
ETL Lead ODI Developer
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)
Location- Delhi NCR, Bangalore, Chennai, Pune, Kolkata, Ahmedabad, Mumbai, Hyderabad, Work from Home - Anywhere in (Rotational Shift)
Employment Type: Full Time, Permanent
Read full job description