Consultant- OCRP Job in Bengaluru at Deloitte

Deloitte is hiring for the role of Consultant- OCRP!

Responsibilities of the Candidate:

• Designing and developing ETL/ELT workflows using Oracle Data Integrator (ODI). 
• Creating and optimizing mappings, interfaces, packages, and load plans in ODI. 
• Working with various source and target systems (e.g., Oracle databases, flat files, XML). 
• Ensuring data accuracy, consistency, and integrity during data transformation. 
• Troubleshooting and resolving issues in ODI pipelines. 
• Designing, developing, and managing dashboards, KPIs, and reports in Oracle Analytics Cloud (OAC). 
• Working with business users to gather requirements and translate them into technical specifications. 
• Ensuring data accuracy and consistency in OAC visualizations. 
• Troubleshooting and resolving issues in OAC dashboards and reports. 
• Collaborating with other team members, including data analysts, database administrators, and business stakeholders. 
• Participating in all phases of the Systems Development Lifecycle, from planning to support and improvement. 
• Understanding and applying data modeling and data warehouse design principles. 
• Having strong SQL and PL/SQL skills. 
• Being familiar with Oracle databases and Oracle Cloud Infrastructure (OCI). 

Requirements:

• Oracle Data Integrator (ODI): Hands-on experience with ODI topology, designer, operator, and agent modules.
• Oracle Analytics Cloud (OAC): Experience in developing dashboards, KPIs, and reports in OAC.
• SQL and PL/SQL: Strong proficiency in SQL and PL/SQL for data manipulation and querying.
• ETL/ELT: Proven experience in designing and implementing ETL/ELT workflows.
• Data Modeling: Sound knowledge of data modeling and data warehouse design principles.
• Communication: Excellent communication and interpersonal skills.