Job Title:  Consulting - T&T - Oracle - OIC, BI, RICE, OAC, FAW - Senior Consultant

Job requisition ID ::  72068
Date:  Oct 1, 2024
Location:  Mumbai
Designation:  Senior Consultant
Entity: 

Job Title: Oracle ERP Cloud Technical Consultant with OIC Experience
Experience Level: 2 to 15 Years
Location: PAN India
Notice Period: Immediate to 90 Days

Roles and Responsibilities:

The responsibilities of the role include:

  • Integration Development: Design, develop, and implement technical solutions for integrations using Oracle Integration Cloud (OIC), ensuring seamless connectivity between Oracle Cloud and other enterprise applications.
  • Report Development: Create and enhance reports using BI Publisher, OTBI, and Financial Reporting Studio (FRS) to meet business requirements, ensuring data accuracy and reliability.
  • Conversions and Extensions: Develop technical solutions for data conversions, interfaces, and customizations to extend Oracle Cloud functionalities according to business needs.
  • Oracle Cloud Modules Expertise: Leverage a strong understanding of Oracle Cloud Financial Modules such as Accounts Payable (AP), Accounts Receivable (AR), General Ledger (GL), Project Accounting (PA), Fixed Assets (FA), Purchasing (PO), and Cash Management.
  • Technical Documentation: Prepare detailed Technical Design Documents (TDD) and Unit Test Scripts, ensuring clarity and completeness for development and testing teams.
  • Collaboration and Support: Work closely with functional teams, end-users, and stakeholders to understand requirements, troubleshoot issues, and provide technical support for implemented solutions.

Requirements:

  • Adaptability: Ability to perform effectively in a dynamic and rapidly changing environment, demonstrating flexibility and a proactive approach to problem-solving.
  • Technical Expertise: Strong proficiency in Oracle Integration Cloud (OIC), BI Publisher, OTBI, FRS, and other Oracle Financial tools and technologies.
  • Knowledge of Oracle Cloud Modules: In-depth knowledge of financial modules, with a focus on integrating and customizing solutions to meet business objectives.
  • Analytical Skills: Ability to analyze requirements, identify gaps, and develop robust technical solutions that align with business processes.
  • Communication Skills: Strong verbal and written communication skills, with the ability to interact effectively with technical and non-technical stakeholders.
  • Documentation Skills: Proficiency in creating technical documentation, including design specifications, test scripts, and user guides.

 

 

Job Title: Oracle EBS Technical Consultant
Experience Level: 2-15 Years
Location: PAN India

Roles and Responsibilities:

  • Technical Development and Customization:
    • Develop and enhance Oracle E-Business Suite (EBS) R12 applications using SQL, PL/SQL, APEX, XML/BI Publisher, and Oracle Forms.
    • Design and implement RICE components (Reports, Interfaces, Conversions, and Extensions) to customize and extend Oracle EBS functionality according to business needs.
    • Develop and manage Oracle Workflows and integrate with other systems using Oracle Integration tools.
  • Implementation and Rollout:
    • Lead or contribute to a minimum of three full-cycle implementation projects, enhancements, and rollouts within Oracle EBS.
    • Provide technical expertise and support during the implementation phase, including requirements analysis, solution design, development, and deployment.
  • Finance and SCM Modules Expertise:
    • Work with key Oracle EBS modules, particularly in Finance (AP, AR, GL) and Supply Chain Management (SCM) modules, to deliver technical solutions that align with business processes.
  • Scripting and Programming:
    • Utilize strong programming skills in SQL and PL/SQL to develop complex queries, scripts, and procedures for data manipulation, reporting, and system integrations.
  • Technical Documentation and Support:
    • Prepare and maintain technical documentation, including design specifications, test scripts, and user manuals.
    • Provide ongoing technical support and troubleshooting to resolve issues, ensuring system stability and performance.

Requirements:

  • Technical Expertise: Proficiency in Oracle EBS R12, SQL, PL/SQL, APEX, XML/BI Publisher, Oracle Forms, Oracle Workflow, and RICE components.
  • Project Experience: Minimum of 3 full-cycle implementation projects with hands-on experience in system enhancements and rollouts.
  • Module Knowledge: Strong working knowledge of Oracle EBS Finance and SCM modules, with the ability to develop custom solutions tailored to these areas.
  • Programming Skills: Advanced skills in SQL and PL/SQL, with a strong ability to write and optimize scripts for performance.
  • Problem-Solving Skills: Proven ability to troubleshoot technical issues, perform root cause analysis, and implement effective solutions in a timely manner.

Job Title: Oracle Analytics Cloud (OAC)/FAW Consultant
Experience Level: 5-15 Years
Location: PAN India.

Roles and Responsibilities:

  • OAC Dashboard and Report Customization:
    • Design, customize, and configure interactive dashboards, reports, and visualizations in Oracle Analytics Cloud (OAC) tailored to business requirements.
    • Perform OAC administration tasks, including user management, security setup, and performance optimization.
  • Data Integration and Performance Tuning:
    • Develop complex Oracle SQL queries and perform performance tuning by implementing views, materialized views, and creating indexes to enhance data retrieval speed.
    • Design and develop interfaces to load data into Oracle Autonomous Data Warehouse (ADW) from various sources, including external relational databases and flat files, ensuring data accuracy and consistency.
  • Data Warehouse Development:
    • Utilize strong data warehousing skills to design, build, and optimize data models, ensuring alignment with business intelligence needs.
    • Work with large datasets to create ETL processes that support analytical and reporting requirements, enhancing overall data usability.
  • Defect Resolution and Support:
    • Manage the resolution of defects identified during testing, migration, and support phases, ensuring issues are resolved promptly to maintain data integrity and system performance.
    • Provide ongoing support to troubleshoot and optimize analytics solutions, maintaining high levels of user satisfaction.

Requirements:

  • Technical Expertise:
    • Proven experience in Oracle Analytics Cloud (OAC) dashboard, report development, and administration.
    • Strong command of Oracle SQL, performance tuning techniques, and experience with Oracle Autonomous Data Warehouse.
  • Data Warehousing Skills:
    • Deep understanding of data warehouse design, development, and optimization, with hands-on experience in ETL processes.
  • Defect Management:
    • Demonstrated ability to manage and resolve defects during testing, migration, and support, ensuring robust analytics performance.
  • Analytical Skills:
    • Excellent problem-solving skills with the ability to analyze complex datasets and develop meaningful insights.