Oracle Fusion OTBI Lead Technical Consultant
Technology, Data & Digital · Data, AI & Analytics · Data Analysis · Business Intelligence · Software Engineering
In short
This role requires an Oracle Fusion OTBI Lead Technical Consultant with strong expertise in SQL, PL/SQL, and Finance/SCM data structures. The consultant will design, develop, and customize OTBI reports, dashboards, and data conversions, while also having experience with Fusion REST APIs and OIC integrations.
Responsibilities
- Collaborate with stakeholders to gather requirements and understand business needs for reporting and analytics.
- Design and develop complex reports, dashboards, and visualizations in Oracle Fusion OTBI.
- Provide technical expertise in Oracle Fusion OTBI to troubleshoot issues, optimize performance, and ensure data accuracy.
- Customize and configure Oracle Fusion OTBI to enhance reporting capabilities based on business requirements.
- Conduct training sessions and provide guidance to end-users on utilizing Oracle Fusion OTBI for data analysis and decision-making.
- Stay updated on Oracle Fusion OTBI features and enhancements to recommend best practices and improvements.
Requirements
- Proficiency in Oracle Fusion OTBI report development and customization.
- Strong understanding of Oracle Fusion OTBI data models, subject areas, and security features.
- Experience in designing and implementing complex reports, dashboards, and analytics solutions.
- Ability to interpret and translate business requirements into technical solutions in Oracle Fusion OTBI.
- Excellent analytical and problem-solving skills with attention to detail.
- Strong communication and interpersonal skills to collaborate with stakeholders and end-users effectively.
- Strong experience in SQL and PL/SQL and knowledge on Finance and SCM tables and joins.
- Strong experience in creating complex BIP reports, OTBI Reports, Infolets, Dashboards.
- Strong experience in Data conversion for Finance and SCM modules.
- Hands-on experience with Oracle FIN/SCM Fusion REST API, SoapUI.
- Hands-on experience in building OTBI/BICC Financials/SCM.
- Hands-on experience in UCM/ADFDI/FBDI.
- Strong understanding of OIC components, capabilities and integration methods.
- Knowledge of FRC, Smart View Reports.
- Client facing experience with excellent interpersonal skills.
Desired Qualifications
- Oracle Fusion OTBI Certification is preferred.
Benefits
- Supercharge your potential, find your career, and find your spark at HCLTech.
- HCLTech is a global technology company with over 223,000 people across 60 countries.
- Delivering industry-leading capabilities centered around digital, engineering, cloud and AI.
- Work with clients across all major verticals including Financial Services, Manufacturing, Life Sciences and Healthcare, Technology and Services, Telecom and Media, Retail and CPG, and Public Services.
- Consolidated revenues of $14.8 billion as of 12 months ending June 2026.
#Oracle Fusion#OTBI#Technical Consultant#SQL#PL/SQL#Finance#SCM#BIP reports#Dashboards#Data conversion#REST API#SoapUI#BICC#UCM#ADFDI#FBDI#OIC#FRC#Smart View#Reporting#Analytics