Description

• Design, develop, enhance and support Oracle Analytics Cloud (OAC) reports, dashboards and analytical solutions.
• Develop interactive dashboards, visualizations, analyses and KPIs based on business requirements.
• OAC Data Visualization (DV) to create business-focused analytics and visualizations.
• Develop and maintain semantic models / subject areas, including logical relationships, measures, dimensions and hierarchies.
• Integrate OAC with Oracle Fusion Cloud applications, databases and other enterprise data sources.
• Develop complex SQL queries for reporting, data validation and analytical requirements.
• Perform data moClienting, data transformation and data preparation for reporting and analytics.
• Develop and support BI Publisher (BIP) reports, data models, templates and scheduled reports where required.
• Analyse and resolve OAC report performance, data discrepancy and dashboard issues.
• Implement appropriate security and role-based access for reports, dashboards and subject areas.
• Perform reconciliation between source applications and OAC reports to ensure accuracy and completeness of reporting data.
• Support migration and deployment of OAC objects across Development, Test and Production environments.
• Work with business and functional teams to translate reporting requirements into effective technical solutions.

Qualifications:

• 5-6 years of overall Oracle technical development experience, with strong hands-on exposure to OAC and OIC.
• Strong hands-on experience with Oracle Analytics Cloud (OAC) development and administration.
• Strong hands-on development experience with Oracle Integration Cloud (OIC).
• Good understanding of Oracle Fusion Cloud ERP/HCM/SCM architecture and data structures.
• Strong knowledge of SQL and PL/SQL.
• Experience with OAC Data Visualization, dashboards, analyses and semantic moClienting.
• Experience with BI Publisher reports, data models and templates.
• Strong knowledge of REST/SOAP APIs, JSON, XML, XSD, WSDL and web-service technologies.
• Experience with OIC adapters, orchestration, mappings, lookups, schedules and error handling.
• Experience with SFTP/file-based integration and database integrations.
• Knowledge of FBDI, HDL, HSDL and ESS jobs is desirable.
• Understanding of OAuth, certificates and API/integration security.
• Experience in performance tuning and troubleshooting of OAC reports and OIC integrations.
• Good understanding of SDLC, deployment and change-management processes.
• Ability to prepare technical documents including Technical Design Documents (TDD), interface specifications, mapping documents and deployment documents.
• Support migration and deployment of OIC integrations across Development, SIT, UAT and Production environments.
• Provide production support and perform root cause analysis (RCA) for integration-related issues.
• Coordinate with functional teams, business users and external system teams during interface design, testing and deployment

Key Skills

Education

Bachelor's degree