Oracle OAC Consultant / Oracle Analytics Cloud Developer

Job Title: Oracle OAC Consultant / Oracle Analytics Cloud Developer

Experience: 10+ Years

Job Location: Remote

Job Summary

Value Technology is looking for an experienced Oracle OAC Consultant with strong expertise in Oracle Analytics Cloud (OAC), BI/OTBI reporting, data visualization, data modeling, and Oracle Fusion analytics solutions. The ideal candidate should have hands-on experience in developing dashboards, reports, integrations, and analytics solutions using Oracle cloud technologies.

Key Responsibilities

• Design, develop, and maintain Oracle Analytics Cloud (OAC) dashboards and reports.
• Develop BI Publisher and OTBI reports based on business requirements.
• Create interactive visualizations, KPIs, scorecards, and analytics dashboards.
• Work with Oracle Fusion data sources including HCM, ERP, SCM, and Financials.
• Develop and maintain data models using ADW, ATP, and other Oracle databases.
• Implement data extraction solutions using BICC.
• Integrate data from multiple systems into OAC.
• Work on FDI (Fusion Data Intelligence) reporting and analytics solutions.
• Optimize report performance and improve dashboard usability.
• Develop SQL queries, PL/SQL procedures, and data transformations.
• Collaborate with functional teams and business stakeholders to gather reporting requirements.
• Perform data validation, testing, and troubleshooting.
• Support production issues and provide enhancements to existing analytics solutions.
• Maintain technical documentation and follow development standards.

Required Skills

Oracle Analytics & Reporting

• Oracle Analytics Cloud (OAC)
• OTBI Reports
• BI Publisher Reports
• FDI (Fusion Data Intelligence)
• Dashboard Development
• Data Visualization

Database & Data Modeling

• ADW (Autonomous Data Warehouse)
• ATP (Autonomous Transaction Processing)
• SQL
• PL/SQL
• Data Modeling

Integration & Data Extraction

• BICC
• REST/SOAP APIs
• Oracle Integration Cloud (OIC/ICS)

Oracle Fusion Knowledge

• Oracle Fusion HCM / ERP / SCM / Financials
• Data Migration Concepts
• Fusion Subject Areas

Additional Skills

• Performance Tuning
• Security & Role Management
• Informatica (preferred)

Preferred Qualifications

• Bachelor’s degree in Computer Science, Information Technology, or related field.
• Oracle OAC/Oracle Analytics certifications preferred.
• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management skills.
• Experience working in Agile/Scrum environments.

Preferred Modules

• Oracle Fusion HCM
• Oracle ERP
• SCM
• Financials
• Payroll
• Procurement

Nice to Have

• Experience with Redwood UI analytics integration.
• Knowledge of OCI services.
• Exposure to Data Warehousing concepts.
• Experience in migration from OBIEE to OAC.