ODI Developer

Job Description

Position: ODI Developer Experience Required: Minimum 2 to 4 Years Location: Mumbai only Job Type: Permanent/ Full Time Notice Period: Immediate only Working Days: Monday to Friday Interviews: First Round- Virtual, 2nd round- Face to Face 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. Must have done the 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 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. Must be 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. Functional Skills/Competencies: Proficient in writing and optimizing SQL queries. Good to have knowledge on SAP HANA data extraction methods. Good to have knowledge on DBT and Fivetran (ETL tools). Strong follow-up skills: ability to organize applicable department timelines and follow up with internal and external customer needs. Ability to debug run time issues in PROD efficiently. Job Types: Full-time, Permanent Pay: ₹400,000.00 - ₹1,200,000.00 per year Benefits: Health insurance Provident Fund Schedule: Day shift Work Location: In person