Consultant | Oracle Analytics Cloud Service / FAW, ODI | Hyderabad | Oracle
- Job requisition ID : 110646
- Location: Hyderabad
- Entity: Deloitte Touche Tohmatsu India LLP

The team

Enterprise technology must do much more than keep the wheels turning; it is the engine that drives functional excellence and the enabler of innovation and long-term growth. Learn more about ET&P;

Your work Profile

We are looking for an experienced Oracle Data Integrator (ODI) Developer with 3-5 years of expertise in designing, developing, and maintaining enterprise data integration and ETL solutions. The ideal candidate should possess robust knowledge of ODI, Oracle databases, SQL, and PL/SQL, along with experience in data warehousing and ETL best practices.

Key Responsibilities
- Design, develop, and maintain ETL solutions using Oracle Data Integrator (ODI).
- Develop ODI Interfaces/Mappings, Packages, Procedures, Variables, Knowledge Modules (KMs), Load Plans, and Scenarios.
- Design and implement data integration workflows for enterprise data warehouse and reporting solutions.




- Perform source-to-target mapping, data transformation, and data validation activities.
- Develop and optimize SQL queries, PL/SQL packages, procedures, functions, and triggers.
- Troubleshoot ETL failures, performance issues, and data quality problems.
- Optimize ODI mappings and database performance for large-volume data processing.
- Support data migration, reconciliation, and production deployment activities.
- Collaborate with business analysts, architects, and cross-functional teams to understand business requirements and deliver scalable ETL solutions.
- Participate in code reviews and ensure adherence to development standards and best practices.
- Prepare technical design documents, deployment guides, and operational documentation.
- Provide production support, incident resolution, and root cause analysis.

Required Skills
- 3-5 years of hands-on experience in Oracle Data Integrator (ODI) developmen

📌 Consultant | Oracle Analytics Cloud Service (Hyderabad)
🏢 Deloitte
📍 Hyderabad