Oracle Consultant

Location: Bengaluru

Roles and responsibilities
The responsibilities of the role include:

· Proficiency in using Oracle BI Tools (OAC, FDI, ADW,OTBI and BIP) and possibly related technologies like SQL, and XML Publisher.

· Experience with Oracle ERP Systems (E-Business Suite, Fusions Applications).

· Expertise in Business Intelligence Publisher, including report development, template design, and document management.

· Hands-on experience in implementing Fusion Analytics Warehouse (FAW).

· Implement and manage the OAC& FAW Security model.

· Should be well versed with Data warehousing Dimension fact tables and BI reporting concepts.

· Should be able to load data from non-oracle source systems to FAW.

· Strong understanding of databases and SQL for querying and manipulating data

· Ability to analyze data, identify trends, and translate insights into actionable business recommendations.

· Responsible for preparing the Technical Design Documents

· Providing support to end-users in using BI tools effectively and conducting training sessions as needed.

Requirement

· Candidate should have the ability to perform in a dynamically changing environment.

· Relevant experience for 5+ years

· Hands-on experience in Oracle BI Publisher, OTBI reporting

· Hands-on experience developing reports, building graphs/charts/tables, and working with Variables and Filter components.

· Design, develop, maintain, and deliver key Oracle Analytics/ Fusion Analytics Warehouse (FAW) Reporting Dashboards, Analytics, and extracts.

· Experience with FAW Extensibility – Data Extensibility, Semantic Layer Extensibility, and Content Extensibility.

· Knowledge on SQL

· Should have a minimum of 3 years of experience on end-to-end implementation projects.

· Having Certification in any Oracle Technology is an added advantage.

· Effective communication skills to collaborate with stakeholders, understand business requirements, and present findings.

· Capacity to troubleshoot issues, debug reports, and optimize BI solutions.

· Willingness to learn new technologies and adapt to changing business needs.

Experience & Background

· Graduate/Post-Graduate qualification

B.Tech./BCA/MBA/M-Tech/MCA

· Relevant experience for 4.5+ years

· Excellent Communication Skills

LOCATIONS
- Bangalore, Pune