Senior ODI Consultant

KPI Partners; Bengaluru; On-site; INR 1,500,000 - 2,000,000; Full time

Job summary

A technology consulting firm is seeking a Senior ODI Consultant to design and optimize ETL processes with Oracle Data Integrator. The role requires a Bachelor's degree in Computer Science or related field, along with at least 5 years of experience in data integration projects. The ideal candidate will possess strong SQL, PL/SQL, and data warehousing skills, along with excellent problem-solving and communication abilities. This full-time position is located in Bengaluru, Karnataka, India.

Qualifications

• Minimum of 5 years of experience in data integration projects.
• Hands-on experience in Oracle and SQL Server databases.
• Strong understanding of data integration and optimization techniques.

Responsibilities

• Design and develop ETL processes using Oracle Data Integrator.
• Conduct requirements gathering sessions for client needs.
• Optimize existing ODI processes for performance.

Skills

Oracle Data Integrator (ODI)

SQL

PL/SQL

Data warehousing concepts

Problem-solving

Communication

Education

Bachelor's degree in Computer Science or related field

Job description

Senior ODI Consultant

KPI Partners is seeking a highly skilled and experienced Senior ODI Consultant to join our dynamic team. The ideal candidate will possess extensive knowledge and expertise in Oracle Data Integrator (ODI) and will be responsible for designing, implementing, and optimizing ETL processes to support our clients' data integration needs.

Responsibilities

• Design and develop ETL processes using Oracle Data Integrator to facilitate seamless data integration between various sources and targets.
• Conduct requirements gathering sessions to understand client needs and translate them into technical specifications.
• Optimize existing ODI processes for performance and scalability, ensuring data accuracy and efficiency.
• Collaborate with cross-functional teams to implement data management best practices and ensure data quality.
• Troubleshoot and resolve issues related to ODI and data integration workflows as they arise.
• Provide technical guidance and mentorship to junior consultants and team members.
• Stay updated with industry trends and advancements in data integration technologies.
• Prepare documentation for processes, configurations, and data mappings to ensure knowledge transfer and compliance.

Qualifications

• Bachelor's degree in Computer Science, Information Technology, or a related field.
• Minimum of 5 years of experience in data integration projects, with a strong focus on Oracle Data Integrator.
• Proficiency in SQL and PL/SQL, with hands‑on experience in database technologies such as Oracle, SQL Server, or similar.
• Strong understanding of data warehousing concepts and techniques.
• Excellent problem‑solving and analytical skills with a keen attention to detail.
• Strong communication and interpersonal skills, with the ability to work effectively with clients and team members.
• Relevant certifications in ODI or data integration methodologies will be an advantage.

Seniority level

Mid‑Senior level

Employment type

Full‑time

Job function

Consulting and Information Technology

Industries

IT Services and IT Consulting, Climate Data and Analytics, and Data Infrastructure and Analytics

Location: Bengaluru, Karnataka, India