Consultant | Oracle Analytics Cloud Service / FAW, ODI | Hyderabad | Oracle (Hyderabad, IN)
Deloitte
Deloitte
Join our dynamic team as an Oracle Data Integrator (ODI) Developer, focusing on Oracle Analytics Cloud Service, FAW, and ODI. This role is based in Hyderabad and offers an exciting opportunity to contribute to enterprise technology solutions. We are seeking an experienced professional to design, develop, and maintain robust data integration and ETL processes, driving functional excellence and innovation.
This position is ideal for someone with a strong background in data warehousing and ETL best practices, looking to make a significant impact within a leading organization.
Key responsibilities include designing and developing ETL solutions using Oracle Data Integrator (ODI), creating ODI Interfaces, Packages, Procedures, and Load Plans. You will also be responsible for implementing data integration workflows, performing source-to-target mapping, data transformation, and validation. The role involves optimizing SQL queries and PL/SQL for performance, troubleshooting ETL issues, and supporting data migration activities. Collaboration with business analysts and architects to deliver scalable ETL solutions, participate in code reviews, and prepare technical documentation are also integral parts of this role.
Additionally, you will provide production support, including incident resolution and root cause analysis, ensuring the smooth operation of data integration systems. Adherence to development standards and best practices will be crucial for success in this role.
We are looking for an accomplished Oracle Data Integrator (ODI) Developer with 3-5 years of dedicated experience. A strong command of ODI 11g/12c, Oracle SQL, and PL/SQL is essential, complemented by expertise in Oracle Database 12c/19c or later. A solid understanding of ETL concepts, data integration principles, and data warehousing methodologies is required. Experience with ODI Knowledge Modules, Load Plans, Packages, Variables, Procedures, and Scenarios is also a must.
Candidates should possess proven skills 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, version control tools like Git, and experience in Agile/Scrum environments are highly valued. A Bachelor's degree in Computer Science, IT, Engineering, or a related field is required for this position.
Deloitte
IT Consulting