Megthink - Level 3 Support Engineer - Oracle BI & Analytics (8-9 yrs)

Job Summary :

We are seeking an experienced Level 3 Support Engineer specialized in Oracle BI Applications and Analytics platforms. The successful candidate will provide advanced technical support, incident resolution, and system enhancements for Oracle BI 12c, Analytics Cloud, Fusion Analytics Warehouse, and associated tools, ensuring high system performance, reliability, and alignment with business needs.

Key Responsibilities :

Advanced Support & Troubleshooting :

- Provide expert-level troubleshooting and resolution for complex issues related to Oracle BI Applications, Financial Analytics, Procurement & Spend Analytics, Project Analytics, Oracle Fusion Analytics Warehouse, and Oracle Analytics Cloud.

System & Data Management :

- Oversee data integration and system configurations, ensuring accurate and timely data loads, metadata management, and system optimizations.

Functional Support :

- Support and maintain Oracle BI Applications 12c, Financial Analytics, Procurement & Spend Analytics, Project Analytics, and Fusion Analytics Warehouse functionalities.

- Handle month-end, quarter-end, and year-end reporting processes, along with ongoing data reconciliation and validation activities.

Technical Support & Development :

- Write, troubleshoot, and optimize SQL and PL/SQL scripts, functions, packages, and procedures.

- Manage and support Oracle Data Integrator (ODI) processes for data flow management.

- Support Oracle Data Warehouse environments such as Oracle Autonomous Data Warehouse (ADW).

Platform & Cloud Support :

- Manage and support Oracle Analytics Cloud services, ensuring seamless operation, performance tuning, and integration with other ERP and analytics systems.

Projects & Enhancements :

- Utilize allocated Oracle analytics development days for system enhancements, configuration changes, or new project implementations, coordinating with business stakeholders.

Monitoring & Optimization :

- Regularly monitor system health, performance, and load processing, implementing tuning and optimization as needed.

Documentation & Compliance :

- Maintain detailed records of incidents, configurations, scripts, and modifications. Ensure systematic documentation for audit and operational continuity.

Collaboration & Communication :

- Work closely with business analysts, functional teams, and technical teams to understand requirements, communicate issues, and deliver solutions.

Qualifications & Skills :

- Bachelors degree in computer science, Information Technology, or related discipline.

- Minimum of 5 years supporting Oracle BI Applications 12c, Oracle Analytics Cloud, Fusion Analytics Warehouse, and related BI tools.

- Strong experience with SQL, PL/SQL, and Oracle Data Integrator (ODI).

- Proficiency in developing and troubleshooting functions, packages, and procedures in Oracle databases.

- Hands-on experience with Oracle Autonomous Data Warehouse (ADW) is a plus.

- Knowledge of BI application architectures, data warehousing, and cloud analytics platforms.

- Proven ability to troubleshoot and resolve complex technical and functional issues related to BI reporting, analytics, and data integration.

- Relevant certifications in Oracle BI, Analytics Cloud, or Data Warehouse Technologies are desirable.