Join our team as a Senior Consultant specializing in Oracle Analytics Cloud Service/FAW, and ODI. This role is based in Hyderabad and offers an exciting opportunity to work with Deloitte Touche Tohmatsu India LLP. We seek an experienced Oracle Data Integrator (ODI) Developer with a proven track record of 5–8 years in developing and maintaining enterprise data integration solutions. The ideal candidate will have strong expertise in ODI, Oracle databases, SQL, and PL/SQL, complemented by a solid understanding of data warehousing principles and ETL best practices.

Enterprise technology is vital for driving functional excellence, fostering innovation, and supporting long-term growth. Become a key player in shaping these critical systems.

As a Senior Consultant, you will be instrumental in designing, developing, and maintaining robust ETL solutions using Oracle Data Integrator (ODI). This includes crafting ODI Interfaces, Packages, Procedures, Variables, Knowledge Modules (KMs), Load Plans, and Scenarios.

You will design and implement data integration workflows, perform source-to-target mapping, and conduct data validation. Your expertise will also be crucial in developing and optimizing SQL queries, PL/SQL packages, and troubleshooting ETL issues. Performance optimization for large-volume data processing and supporting data migration activities are key aspects of this role. Collaboration with business analysts and architects to deliver scalable solutions, along with code reviews and documentation, will be essential. Providing production support and incident resolution is also a core responsibility.

We require a minimum of 5–8 years of hands-on experience in Oracle Data Integrator (ODI) development, with strong expertise in ODI 11g and/or ODI 12c. Excellent command of Oracle SQL and PL/SQL is essential, along with experience in Oracle Database 12c/19c or later. A strong grasp of ETL concepts, data integration, and data warehousing methodologies is necessary.

Proficiency in ODI Knowledge Modules (LKM, IKM, CKM, JKM) and experience with Load Plans, Packages, Variables, Procedures, and Scenarios are expected. You should have experience in performance tuning of ODI mappings and SQL queries, along with knowledge of data quality, validation, and reconciliation techniques. Familiarity with Unix/Linux shell scripting, Git or other version control tools, and experience in Agile/Scrum environments are also required.

A Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field is a prerequisite. While an Oracle Data Integrator (ODI) certification is preferred, strong analytical and problem-solving skills, excellent communication, and the ability to work both independently and collaboratively are paramount.