ODI Developer

Job description:

• 4to 8 years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development and system Integration projects.
• Must have worked on end to end implementation of DW and BI projects.
• Good querying skills on Oracle database with ability to understand and debug PL/SQL procedure.
• Design and develop mappings, Process Flows and ETL scripts.
• Experience of performance tuning of mappings.
• Ability to tune mappings at ETL level and provide suggestion of tuning at database level.
• Ability to design ETL unit test cases and debug ETL Mappings.
• Must have done the Development of topology setup, Load Plans, Packages, Mappings/Interfaces, Procedures, and Scheduling Jobs.
• Managing Files, Oracle DB, XML's through ODI
• Create Load-Plans and schedule the same.
• Create email notifications to alert on exceptions and error.
• Must be well versed and hands-on in using and customizing Knowledge Modules (KM) IKM, LKM, CKM and RKM.
• Strong knowledge and experience and implementation of Oracle Data warehouse concepts SCD2, Aggregates, Hierarchy tables, Snapshot fact tables etc.
• BE/BTech, MBA, BCA, MCA (Graduate/Post Graduate) with 2 to 4 years of relevant experience.
• Preferably from a services organization background with prior experience in Onsite-Offshore model