Oracle Data Integrator (ODI) Developer

Elfonze Technologies; Bengaluru; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Elfonze Technologies in Bengaluru is seeking an Oracle Data Integrator (ODI) Developer to design, develop, test, and deploy ODI ETL/ELT solutions in a Bangalore-based role. The ideal candidate will have 5+ years ODI experience, ODI 11g/12c, Oracle SQL/PLSQL, data warehousing concepts, and be proficient in ODI packages, load plans, mappings, procedures, variables, and knowledge modules.

Unix/Linux scripting is also desirable.

Qualifications

• 5+ years of ODI development experience.
• Strong ODI 11g/12c experience.
• Proficient in Oracle SQL and PL/SQL.
• Solid data warehouse, ETL/ELT, and dimensional modeling knowledge.
• Experience creating ODI packages, load plans, mappings, procedures, variables, and knowledge modules.
• Experience with ODI performance tuning.
• Strong understanding of database design and data modeling.
• Unix/Linux scripting experience.
• Strong analytical and problem-solving skills.

Responsibilities

• Design, develop, test, and deploy ETL/ELT solutions using ODI.
• Create and maintain ODI repositories, interfaces/mappings, packages, procedures, variables, and load plans.
• Develop data integration solutions for data warehousing and BI projects.
• Perform data analysis, data mapping, and data validation activities.
• Optimize ODI jobs and database queries for performance and scalability.
• Troubleshoot and resolve production issues related to ETL processes.
• Work closely with business analysts, data architects, and application teams to understand requirements and deliver solutions.
• Participate in code reviews and ensure adherence to development standards and best practices.

Skills

Oracle ODI

ODI 11g/12c

Oracle SQL/PLSQL

Data warehousing

ETL/ELT methodologies

Dimensional modeling

ODI packages/load plans

Performance tuning

Unix/Linux scripting

Data analysis/troubleshooting

Job description

Oracle Data Integrator (ODI) Developer

Bangalore North, India | Posted on 08/10/2026

• Design, develop, test, and deploy ETL/ELT solutions using Oracle Data Integrator (ODI).
• Create and maintain ODI repositories, interfaces/mappings,packages, procedures, variables, and load plans.
• Develop data integration solutions for data warehousing andbusiness intelligence projects.
• Perform data analysis, data mapping, and data validationactivities.
• Optimize ODI jobs and database queries for performance andscalability.
• Troubleshoot and resolve production issues related to ETLprocesses.
• Work closely with business analysts, data architects, andapplication teams to understand requirements and deliver solutions.
• Participate in code reviews and ensure adherence to developmentstandards and best practices.

Required Skills

• 5+ years of experience in Oracle Data Integrator (ODI) development.
• Strong experience with ODI 11g/12c.
• Proficient in Oracle SQL and PL/SQL.
• Strong understanding of Data Warehouse concepts, ETL/ELTmethodologies, and dimensional modeling.
• Experience in developing ODI Packages, Load Plans, Mappings,Procedures, Variables, and Knowledge Modules.
• Experience with performance tuning and optimization of ODI jobs.
• Good understanding of database design and data modeling.
• Experience with Unix/Linux scripting.
• Strong analytical, troubleshooting, and problem-solving skills.