ODI Developer

• 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