Role & responsibilities

We are seeking an experienced Oracle Data Integrator (ODI) Developer with 5+ years of hands-on experience in designing, developing, and supporting ETL/ELT solutions using Oracle Data Integrator. The ideal candidate should possess strong expertise in data integration, data warehousing concepts, Oracle databases, and performance tuning.

Key Responsibilities
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 and business intelligence 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.
Support deployment activities across development, testing, and production environments.

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.
Solid understanding of Data Warehouse concepts, ETL/ELT methodologies, 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.
Valuable understanding of database design and data modeling.
Experience with Unix/Linux scripting.

Robust analytical, troubleshooting, and problem-solving skills

📌 Odi Developer Bengaluru
🏢 Tata Consultancy Services
📍 Bengaluru