Senior Consultant | (BI Reports, OTBI, FRS, SmartView) | Pune | Oracle

Senior Consultant | (BI Reports, OTBI, FRS, SmartView) | Pune | Oracle

• Job requisition ID: 106066


• Location: Pune


• 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

• Integration Delivery & Solution Leadership


• Architect and implement complex integrations using Oracle Integration Cloud (OIC), SOA, and REST/SOAP APIs to seamlessly connect Oracle SaaS with external boundary systems.


• Define and govern technical architecture across OIC, APEX, VBCS, and business processes/workflow solutions.


• Establish robust integration patterns, reusable templates/libraries, coding standards, and delivery governance frameworks.


• Lead development across multiple patterns, including app-driven orchestrations, scheduled orchestrations, file transfers (MFT), and event-based architectures.


• Design advanced configurations utilizing OIC Cloud Adapters (ERP Cloud, SCM Cloud, REST, SOAP, FTP, ServiceNow) and configure secure on-premise OIC Connectivity Agents.


• Enforce strict security practices, including OAuth 2.0, SSL certificates, Basic Authentication, and Oracle Cloud Security frameworks.


• Team Management & Quality Assurance


• Lead a team of technical developers, effectively coordinating task allocations, sprint deliverables, and resource capacity.


• Provide expert technical guidance and mentorship to junior consultants, actively fostering skill development and professional growth.


• Conduct rigorous technical code reviews to verify code quality, data alignment, error-handling mechanisms, and system performance standards.


• Direct the creation of custom technical components across the wider RICEFW scope (Reports, Interfaces, Conversions, Extensions, Forms, and Workflows) using Oracle best practices.


• Client Engagement & Execution Excellence


• Act as the primary integration point of contact for client stakeholders, leading technical workshops, architecture reviews, and fit-gap analysis.


• Collaborate closely with functional consultants to map complex business requirements into high-performing, scalable technical designs.


• Manage end-to-end implementation lifecycle phases, including estimation, technical documentation, System Integration Testing (SIT), User Acceptance Testing (UAT), and Go-Live hypercare support.


• Troubleshoot complex environment issues, driving root-cause analysis (RCA) and implementing quick, effective resolutions for payload errors or performance bottlenecks.


•  


• Key Skills & Qualifications


• Education: Bachelor’s or Master’s degree in Engineering (B.E./B.Tech), Computer Applications (MCA), or related technical fields.


• Core Technical Expertise: Minimum 5 years of dedicated experience with Oracle Integration Cloud (OIC) is mandatory.


• Web Services & Languages: Mastery of REST/SOAP web services, XML, JSON, XQuery, and XSLT.


• Database & Extensibility: Strong background in SQL, PL/SQL, Oracle Database, and developing applications using Oracle APEX and VBCS.


• Data Migration Foundations: Solid understanding of Oracle SaaS data loading frameworks like FBDI and HDL, alongside reporting tools (BI Publisher, OTBI).


• Methodologies: Comfortable working in fast-paced Agile environments with a clear grasp of DevOps/DevSecOps tools and pipelines.


• design

Key skills required

• Provide solution leadership across Oracle Fusion Financials (GL, AP, AR, FA, CM) and PPM modules (Projects, Project Costing, Billing, Grants, Contracts)


• Guide solution architecture for project-centric finance transformations, including capitalization, revenue recognition, and cost accounting


• Lead Oracle EBS to Oracle Cloud migrations involving Financials and PPM


• Drive adoption of Oracle leading practices, Deloitte accelerators, and cloud-native capabilities such as automation and advanced reporting


• Hands-on experience with:


• Tagetik configuration and data models


• ETL processes and data integration


• SQL or database concepts


• Experience with ERP systems (SAP, Oracle, or others)


• Strong analytical and problem-solving skills


• Excellent communication and stakeholder management