Oracle Data Integrator Developer

As an Oracle Data Integrator, you will be responsible for developing medium to complex ODI interfaces using various transformation packages and knowledge modules. Your role will involve diagnosing and debugging data reconciliation issues in the PRODUCTION environment and deploying code to multiple environments. It is essential to have a working knowledge of ODI packages/interfaces and KMs. Key Responsibilities: - 1 to 3 years of proven experience in design and development of Data Warehouse solutions, ETL, Software Development, and system Integration projects. - Strong experience in Oracle Data Integrator (ODI) 12c with knowledge of data modeling and ETL design. - In-depth knowledge of Oracle Data Integrator (ODI) 12c concepts. - Development of topology setup, Load Plans, Packages, Mappings/Interface, Procedures, Scheduling Jobs, and ODI tools. - Experience working with multiple technologies including Oracle, SAP HANA, and file-based systems (CSV/XML). - Good querying skills on Oracle database with the ability to understand and debug scripts (Groovy \ Python). - Hands-on experience with managing ODI Agents and job deployments across environments. - Experience in performance tuning and optimization of ETL processes. - Ability to design ETL unit test cases and debug ETL Mappings. - Managing Files, Oracle DB, SAP HANA, XMLs through ODI. - Well versed and hands-on in using and customizing Knowledge Modules (KM) IKM, LKM, CKM. - Strong understanding and implementation experience of Slowly Changing Dimensions (SCD) Type 1 and Type 2 mappings. Qualifications Required: - Hands-on experience in Oracle Data Integrator (ODI) for at least 2 years. - Proficiency in 12C concepts for 2 years. Please note that this is a Full-time, Permanent position that requires in-person work.,