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.
Robust experience with ODI 11g/12c.
Proficient in Oracle SQL and PL/SQL.
Robust 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

📌 Oracle Data Integrator Developer Bengaluru (India)
🏢 Tata Consultancy Services
📍 India