Falcon Chase International is seeking an experienced Oracle Analytics (OAS) & ODI Developer to join a high-profile client engagement. This role is ideal for a professional with strong experience in Oracle Analytics Server (OAS), Oracle Data Integrator (ODI), Enterprise Data Warehousing, and Oracle SQL/PLSQL, who can design, develop, and support enterprise analytics and data integration solutions.
The successful candidate will be responsible for designing and implementing Oracle Analytics subject areas (RPD), developing ETL solutions using ODI, building enterprise data warehouse components, developing reports and dashboards, and providing production support while working closely with business stakeholders, architects, and technical teams.
Must be SC cleared
Responsibilities
- Design, develop, and maintain subject areas and semantic models using Oracle Analytics Server (OAS) Repository (RPD).
- Design, implement, and manage Oracle Analytics Server (OAS) security, including users, application roles, groups, and data-level security.
- Design, develop, and implement Oracle Data Integrator (ODI) mappings, packages, and ETL workflows for enterprise data integration.
- Design, develop, and support Enterprise Data Warehouse (EDW) solutions, including logical and physical data models, dimensional modelling, and data integration.
- Develop, enhance, and maintain Oracle Analytics Server (OAS) reports, dashboards, and visualisations to support Business Intelligence and reporting requirements.
- Provide production support and ongoing maintenance for Oracle Analytics Server (OAS), Oracle Data Integrator (ODI), and Enterprise Data Warehouse environments.
- Analyse, troubleshoot, and resolve data, ETL, reporting, and application issues to ensure platform stability and data quality.
- Perform performance tuning and optimisation of RPD models, ODI mappings, SQL queries, and Oracle Analytics reports.
- Create and maintain technical documentation, solution designs, deployment guides, and operational procedures.
- Collaborate with Business Analysts, Solution Architects, Data Architects, Developers, and business stakeholders to gather requirements and deliver scalable analytics solutions.
- Participate in code reviews, testing, deployment, and release activities while ensuring adherence to development standards and best practices.
- Support continuous improvement initiatives by identifying opportunities to enhance data integration, reporting, and analytics capabilities.