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.
- Strong 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.

Strong analytical, troubleshooting, and problem-solving skills

📌 Odi Developer (Bengaluru)
🏢 Tata Consultancy Services
📍 Bengaluru