Principal Technical Analyst

About Oracle CSS – Customer Success Services:

Oracle Customer Success Services is a One Oracle approach to ensuring customer success, through a broad set of services and solutions that are supported by certified and experienced implementers, helping to accelerate the entire customer journey. Customer Success Services provides a customer-centric delivery and support-integrated service, in conjunction with Oracle Development.

Job Summary:

We are seeking a skilled Oracle BI/OTBI Developer with hands-on experience in building, customizing, and troubleshooting reports and dashboards in Oracle Fusion Cloud Applications. The ideal candidate will be proficient in BI Publisher, OTBI, and Fusion data models, and capable of resolving data inconsistencies, report errors, and performance issues.

The role also includes working on data migration, personalization, and support tasks across multiple time zones. The candidate must be ready to work in shifts to support global business operations and critical reporting needs.

Job Responsibilities:

• Design, develop, and maintain reports and dashboards using Oracle BI Publisher and OTBI.
• Collaborate with business users to gather reporting requirements and deliver tailored solutions.
• Perform root cause analysis and troubleshooting for data discrepancies, report failures, and performance issues.
• Optimize SQL queries and report performance.
• Maintain scheduled jobs, burst reports, and automated data extracts.
• Document data mappings, report logic, and issue resolutions.
• Support personalization using Sandbox and VBS where applicable.
• Participate in shift-based work schedules, including off-hours support when needed.

Mandatory Skills:

• Strong expertise in SQL (PL/SQL experience is a plus),Minimum of  10 Years Experience.
• In-depth knowledge of development and customization of BI Publisher Reports, OTBI Reports, and Dashboards.
• Hands-on experience with Data Migration using FBDI and HDL Loader.
• Proficiency in personalization, Sandbox customizations, and Visual Builder Studios (VBS).
• Understanding of ESS Jobs, Value Sets, and Descriptive Flexfields (DFF).
• Functional knowledge in Oracle Fusion modules of SCM (Supply Chain Management.
• Candidate should have good attitude and learning capability to pick up any modules apart from the modules he/she is aware. 
• Candidate is expected to work in support model.
• Ready to work in shifts including night shift. The role will be based in Bangalore / Hyderabad / Other India Locations

Preferred Qualifications:

• Experience with BICC for data extraction.
• Familiarity with Oracle Analytics Cloud (OAC) or OBIEE.
• Knowledge of OIC, cloud storage, or external integrations.
• Understanding of role-based security and access controls in OTBI.

• Detail-oriented with a strong analytical mindset.
• Able to prioritize and troubleshoot under pressure.
• Effective communicator across technical and business teams.
• Comfortable working independently and in a shift-based support environment.