Oracle Report Developer

Oracle BI Developer

Contract Length: 4 Months

Day Rate: £700

On-Site In London

Inside IR35

Must have active SC Clearance

This role is a ‘hands-on' OBIEE/OBIA/OACS developer and requires working with others to specify, design and implement the reporting technical and dashboard/report requirements for the Hera Service, this involves developing, validating and reviewing conceptual, logical and physical report designs.

This is a technical role and requires a level of experience to ensure you begin to add value from the start. It is expected that you would have 3+ years in a B.I. or data integration development environment.

The Oracle BI Developer will be responsible for:

• Oracle BI Tools - OTBI (Oracle Transactional Business Intelligence), Oracle BI Publisher, Oracle Business Intelligence Enterprise Edition (OBIEE) including report development
• Oracle Database technologies - data warehouse development including dimensional modelling
• Hyperion Essbase / EPM/ PBCS/ knowledge
• Oracle Business Intelligence Applications (OBIA) – including application servers
• Knowledge in one of the following data structures and basic knowledge of the other
• e-business suite/fusion HR/HCM
• e-business suite/fusion ERP
• Requirements analysis
• Metadata modelling
• ETL (Extract, Transform and Load) technologies
• Exposure to ETL toolset and ETL performance tuning
• Execute data flows by using Oracle Database Cloud
• Data Visualization
• Explore and replicate data
• Create scalable data flows including ingestion, transformation, and persistence
• Create connections and data sources for drill-through, data loads and dimension builds
• Collect collaborative data, create scenarios, and perform what-if analysis using Smart View
• Build data models, reports, and analytic dashboards in an enterprise business intelligence environment
• Design and publish pixel-perfect reports from the enterprise data
• Maintain live and optimized connectivity to on-premises data warehouses
• Good ODI skills, both in terms of the basics, but also being able to write knowledge modules, integrate with OBIEE, deployment and migration
• Solid database skills - partitioning, materialized views, index types and Oracle PL/SQL - to support BI development
• Good communication and documentation skills, the ability to get on well with team members