Oracle Fusion OTBI Business Analyst (Oracle Fusion Cloud + OTBI Reporting)

JMD Technologies Inc. is seeking a Business Analyst specializing in Oracle Fusion and Data Integration. This role focuses on bridging business requirements and technical execution, specifically in reporting, data extraction, and integrating enterprise data into a modern analytics platform.

Responsibilities:

• Gather and document requirements and translate into functional solutions within Oracle Fusion Cloud (ERP/HCM/SCM)
• Design and develop reports using OTBI , BI Publisher , and FRS (Financial Reporting Studio)
• Perform high-volume data extraction using BICC and Public View Objects (PVOs)
• Manage data integration into Microsoft Fabric (OneLake, Data Factory, Lakehouse)
• Develop and execute UAT , including test scripts and data validation
• Write and optimize SQL queries for validation and troubleshooting

Requirements:

• 3–5 years of experience with Oracle Fusion Cloud (ERP, HCM, or SCM)
• Strong expertise in OTBI, BI Publisher, and FRS
• Hands-on experience with BICC and PVOs for data extraction
• Experience or knowledge of Microsoft Fabric (OneLake, Data Factory, Lakehouse)
• Strong SQL skills for data validation and analysis
• Experience with Power BI for reporting and visualization