ODI (Oracle Data Integrator) Lead

Role Overview: You will be responsible for leading Oracle Data Integrator (ODI) projects at our Bhopal office. With 4-6 years of experience, you will work on ETL development in DWH Projects using ODI 12C tool. Key Responsibilities: - Configure and setup ODI components such as Master Repository, Work Repository, Projects, Models, Sources, Targets, Packages, Knowledge Modules, Scenarios, Filters & Metadata. - Utilize expertise in knowledge modules like RKM, LKM, CKM, IKM, and JKM for project success. - Develop Facts, Dimensions, Slowly changing Dimensions (SCD), and implement Change data capture (CDC) in DWH projects. - Implement SQL/ PL SQL in Oracle for large data volumes. - Perform Performance Tuning and Optimization of DB SQL Script (Oracle DB) and ODI Packages/ Code. - Design and develop ODI interfaces/packages, load plans, and assist in SIT/UAT including production deployment post UAT sign off. - Optimize execution time of interfaces by following best practices. - Coordinate with BA/Customer to ensure implementation of CRs meets requirements. - Work with OBIEE 12c for creating Analytics Reports & Dashboards. - Have knowledge of the General Insurance Domain. Qualifications Required: - 4-6 years of hands-on experience with Oracle Data Integrator (ODI) 12C tool. - Proficiency in SQL/PL SQL implementation in Oracle for handling large volumes of data. - Experience in Performance Tuning and Optimization of DB SQL Script (Oracle DB) and ODI Packages/ Code. - Knowledge of OBIEE 12c for creating Analytics Reports & Dashboards. - Understanding of the General Insurance Domain will be beneficial.,