Fusion Technical Consultant (OIC)

#HiringAlert

We are looking " Oracle APEX " for Reputed Client @ Permanent Role.

Must Have Skills:

1.Experience in Oracle APEX, SQL / PLSQL concepts, collections, function, procedure, package and types - Mandatory

2. Experience in JASPER / OBIEE reports

Good To Have Skills:

1.Knowledge in Oracle Forms and Reports, JavaScript, HTML, CSS or any other web-based programming language is added advantage (Optional)

2.Key Responsibilities: Design develop test and implement features and code using Oracle Application Express APEX

3. Perform requirements analysis development design test and deployment of custom Oracle applications.

4. Writing SQL queries Views Materialized views PLSQL procedures functions packages triggers cursors collections Ref cursor cursor variables System reference cursor Dynamic SQL

5. Debug code and maintain PL SQL procedures and functions.

6.Optimize existing applications and scripts for both usability and performance.

7. Adherence to policies processes and procedures within your areas of responsibility

8.Evaluate new features and technologies overseeing their implementation into the environment as appropriate.

9.Ability to prioritize, manage, deliver and report on multiple projects simultaneously highly motivated and able to work against aggressive deadlines schedules.

Professional Attributes:

1. Ability to work with minimal supervision.

2. Exhibits strong ethics, positive attitude, and calm demeanor under pressure.

3. Flexible, organized and possesses the ability to work in a fast-paced environment.

Location : Chennai

· Work Experience: 7+yrs

Technical Expertise

Must Have Skills:

· Proven experience as a Fusion Technical Consultant with strong expertise in Oracle Integration Cloud (OIC),

· Strong hand on experience generating BI reports (strictly Mandatory)

· Proficiency in Java, PL/SQL, Web Services, and other relevant programming languages.

· Strong problem-solving skills and the ability to troubleshoot complex technical issues independently.

· Prior experience in a customer-facing technical support role is a plus resolving P1/P2 tickets in a close deadline.

· Hands-on experience with Oracle Fusion Middleware technologies, including Oracle SOA Suite, Oracle Service Bus, and ADF.

· Excellent communication skills, both written and verbal, to effectively interact with clients and team members.

· Oracle certifications in Fusion Middleware and OIC are highly desirable.

Good To Have Skills:

· Good to have functional knowledge of AR, AP, GL,CM, Expense, FA, Procurement side.

Key Responsibilities:

· Collaborate with clients to understand their technical requirements and challenges related to Oracle Fusion applications and Oracle Integration Cloud (OIC).

· Provide expert-level support and troubleshooting for technical issues, system outages, and integration bottlenecks in a timely and efficient manner.

· Diagnose and resolve complex technical problems related to Fusion applications, OIC integrations, interfaces, and extensions.

· Perform root cause analysis and implement preventive measures to avoid future technical glitches.

· Collaborate with cross-functional teams, including developers, functional consultants, and business analysts, to ensure seamless integration and functionality.

· Develop and maintain technical documentation, including troubleshooting guides, best practices, and solution implementation details.

· Participate in regular status meetings with clients to address support requests, provide updates, and offer recommendations for process improvement.

· Stay updated with the latest releases, patches, and updates related to Oracle Fusion applications and OIC.

Professional Attributes:

· Flexibility

· Willing to work in shifts

· Willing to learn attitude

· Work location: Chennai/WFH

• Strong Knowledge in Oracle Forms and Reports
• Should be familiar with various triggers, events , canvas, master child forms, record groups , build-ins, properties etc., in Forms and reports
• Strong Knowledge in SQL / PLSQL concepts
• Strong in Analytical and Aggregate functions
• Strong in writing Procedure / Function / Packages
• Strong knowledge in the user of Cursors / Collections / Exception handling
• Strong in Datatypes, Constrainsts , index
• Having exposure to JavaScript and ReactJS will be an added advantage

•  Be a team player and strive for the success of the team and the client
• Preparation of Technical Design documents
• Work independently and progress the build of a CEMLI/RICE object from a technical design document
• Capable of working in a fast paced, dynamic, team-oriented environment
• Understanding functional documents of FIN (GL, Fixed Assets, Cash management, AP/AR) and SCM (procurement, Inventory, Order Management).

• Minimum a Bachelor’s degree.
• Oracle Apps Technical with 5+ years of Experience in development, testing and deployment of RICE components and financial modules
• Good Experience on Oracle Forms & Reports, XML / BI Publisher Reporting Tools, Interfaces (outbound /Inbound) and Workflow.
• Must have a strong experience and knowledge of Oracle E-Business Suite
• Must have strong technical experience on PL/SQL, XML Publisher reports, Java, Oracle Applications Framework (OAF)
• Knowledge on ADF
• Must be able to work independently with business users and external users and responsible for design, development, Testing support, production deployment and production support.
• Excellent organization and communication skills

• 4-15 year experience in Application Support
• Must have good knowledge in Java/J2EE, Microservices, PL/SQL, Unix
• Good to have knowledge in Agile, JIRA, Splunk, Service Now
• Good understanding and hands-on experience in Incident, Problem and Change Management
• Provide technical leadership to the team & contribute in the skill development within team
  Interact with internal teams and client stakeholders to trouble shoot the tickets/incident and manage other support activities
• Good communications skills are necessary, must be team player and inquisitive.
• Strong customer service and support focus with a desire to deliver a high-quality service
• Ability to multi-task, work under pressure and to tight deadlines
• Flexible in working outside of office business hours at short notice (as required)
• Should be able to examine the system and identify the areas for Service Improvements & Value adds.

RESPONSIBILITIES:

• Plans conduct and lead assignments generally involving moderate, high-budgeted projects or more than one project.
• Manages user expectations regarding appropriate milestones and deadlines.
• Assists in training, work assignment and checking of less experienced developers.
• Serves as a technical consultant to leaders in the IT organization and functional user groups. Subject matter expert in one or more technical programming specialties; employs expertise as a generalist of a specialist.
• Performs estimation efforts on complex projects and tracks progress.
• Works on the highest level of problems where analysis of situations or data requires an in-depth evaluation of various factors.
• Documents evaluate, and researches test results; documents evolution of testing scripts for future replication.
• Identifies, recommends, and implements changes to enhance the effectiveness of quality assurance strategies.

Detailed Job Description:

• Should have experience in Development, Configuration, Implementation, and Support of Salesforce CRM applications based on Apex Language and leveraging Force.com Platform running in Cloud Computing Environments.
• Should work on developing custom objects, custom fields, role-based page layouts, custom Tabs, custom reports, report folders, design of Visual Force Pages, Dashboards, Apex Classes, Controllers & Triggers, VF Components, and various other components as per the client and application requirements.
• Should implement security and sharing rules at an object, field, and record level for different users at different levels of the organization. Also should have knowledge of creating various profiles and configured the permissions based on the organizational hierarchy.
• Should have good experience in design and develop Apex Classes, Controller Classes, and Apex Triggers for various functional needs in the application.
• Should involve in Unit Testing, Test Coverage, and Code Review.
• Should have experience working with Force.com IDE version 23.0, Eclipse IDE, and salesforce.com Sandbox environments.
• Responsible for ensuring the quality of their own work as well as the work of the development team.
• Development responsibilities include doing code review/bug analysis, analyzing development and impacts.
• The candidate should have strong programming, debugging experience, and excellent problem-solving skills.