Vista previa de la oferta
Consultant | Oracle Analytics Cloud Service / FAW, ODI | Hyderabad | Oracle
mid · Consulting
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 strong 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) development.
- Strong expertise in ODI 11g and/or ODI 12c.
- Excellent knowledge of Oracle SQL and PL/SQL.
- Experience with Oracle Database 12c/19c or later.
- Strong understanding of ETL concepts, data integration, and data warehousing methodologies.
- Experience with ODI Knowledge Modules (LKM, IKM, CKM, JKM).
- Hands-on experience with Load Plans, Packages, Variables, Procedures, and Scenarios.
- Experience in performance tuning of ODI mappings and SQL queries.
- Knowledge of data quality, data validation, and reconciliation techniques.
- Familiarity with Unix/Linux shell scripting.
- Experience using Git or other version control tools.
- Experience working in Agile/Scrum environments.
Preferred Skills
- Experience with Oracle Autonomous Data Warehouse (ADW) and Oracle Cloud Infrastructure (OCI).
- Exposure to Oracle Integration Cloud (OIC).
- Knowledge of Oracle Analytics Cloud (OAC) or OBIEE.
- Experience with Oracle GoldenGate or Oracle Data Integrator for real-time integration.
- Exposure to cloud-based data integration and migration projects.
- Familiarity with data governance and data quality tools.
- Oracle ODI Certification is an added advantage.
Qualifications
- Bachelor's degree in Computer Science, Information Technology, Engineering, or a related discipline.
- Oracle Data Integrator (ODI) certification is preferred.
Soft Skills
- Strong analytical and problem-solving skills.
- Excellent communication and stakeholder management abilities.
- Ability to work independently and collaboratively in cross-functional teams.
- Strong documentation and presentation skills.
- Ability to manage multiple priorities and deliver high-quality solutions within project timelines.