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

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.