Oracle Data Integrator (ODI)

Tata Consultancy Services; Bengaluru; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Tata Consultancy Services in Bengaluru is seeking an ODI Developer to design, develop, test, deploy and maintain ODI-based data integration solutions. You will create and optimize complex SQL queries, model logical data structures, and implement robust ETL processes across disparate systems.

You will collaborate with cross‑functional teams to translate business requirements into effective ODI workflows, troubleshoot performance issues and ensure scalable, reliable data movement across

Qualifications

• ODI-based data integration experience.
• Strong SQL query development skills.
• ETL process design and optimization.
• Experience creating logical data models for integration.
• Ability to collaborate with cross-functional teams.

Responsibilities

• Design, develop, test, deploy and maintain ODI solutions.
• Create complex SQL queries using ODI Extract component.
• Create logical data models for integration projects.
• Collaborate with teams to translate business requirements into ODI workflows.
• Troubleshoot ODI workflow failures and performance issues.

Skills

ODI

SQL

ETL

Logical Modeling

Tools

Oracle ODI

Job description

Roles and Responsibilities

• Design, develop, test, deploy, and maintain Oracle Data Integrator (ODI) solutions to integrate various data sources and targets.
  
• Develop complex SQL queries to extract data from disparate systems using ODI's Extract component.
  
• Create logical data models for integration projects using ODI's Logical Modeling feature.
  
• Collaborate with cross-functional teams to identify business requirements and design effective ETL processes.
  
• Troubleshoot issues related to ODI workflow failures, errors, or performance problems.