Odi Developer

Tata Consultancy Services; Hyderabad, Chennai District, Bengaluru; On-site; INR 1,200,000 - 2,100,000; Full time

Job summary

Tata Consultancy Services is seeking an experienced Oracle Data Integrator (ODI) Developer for Hyderabad. The role focuses on designing, developing and supporting ETL/ELT solutions with ODI, in a data-driven environment.

The ideal candidate has 5+ years of ODI development experience, strong ODI 11g/12c knowledge, and proficiency in Oracle SQL/PL-SQL, data warehousing concepts and performance tuning. You will collaborate with BI teams and data architects to deliver scalable data integration

Qualifications

• 5+ years of experience in ODI development.
• Strong experience with ODI 11g/12c.
• Proficient in Oracle SQL and PL/SQL.
• Data warehousing concepts, ETL/ELT methodologies, and dimensional modeling.

Responsibilities

• Design, develop, test, and deploy ODI ETL/ELT solutions.
• 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.
• Support deployment activities across development, testing, and production environments.

Skills

ODI development

ODI 11g/12c

Oracle SQL

PL/SQL

Data warehousing concepts

ETL/ELT methodologies

Dimensional modeling

Unix/Linux scripting

Performance tuning

Tools

ODI Packages

Load Plans

Interfaces / Mappings

Procedures

Variables

Knowledge Modules

Job description

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.
• Good understanding of database design and data modeling.
• Experience with Unix/Linux scripting.

Strong analytical, troubleshooting, and problem-solving skills