Oracle Fusion OTBI

Title: Oracle Fusion OTBI

Location: Mississauga, ON (Hybrid)

Position type: Contract

Job Summary:

We are seeking an experienced Oracle HCM Technical Developer with strong expertise in Oracle HCM Cloud Integrations and Visual Builder Studio (VBS) Customizations. The ideal candidate will be responsible for designing, developing, and supporting Oracle HCM technical solutions, including inbound/outbound integrations, data conversions, reports, extracts, and Redwood UI customizations using Oracle Visual Builder Studio.

Key Responsibilities:

• Design, develop, and support Oracle HCM Cloud integrations using:
• HCM Extracts
• HDL (HCM Data Loader)
• HSDL
• REST/SOAP APIs
• Oracle Integration Cloud (OIC)
• File-based integrations
• Develop and maintain integrations between Oracle HCM Cloud and third-party applications including Payroll, Benefits, Identity Management, Finance, and ERP systems.
• Create and support BI Publisher reports, OTBI analyses, dashboards, and HCM Extracts.
• Design and implement Oracle Redwood UI customizations using Oracle Visual Builder Studio (VBS).
• Develop page extensions, business rules, validations, UI customizations, and client-side enhancements through VBS.
• Perform technical analysis, solution design, development, testing, and deployment.
• Troubleshoot production issues and provide timely resolution.
• Work closely with functional consultants and business stakeholders to gather requirements and translate them into technical solutions.
• Support data migration, mass updates, and conversion activities.
• Prepare technical design documents, unit test cases, and deployment documentation.
• Ensure compliance with Oracle Cloud best practices and security standards.

Required Skills:

• 7+ years of Oracle HCM technical development experience.
• Hands-on experience with Oracle HCM Cloud modules such as:
• Core HR
• Recruiting
• Talent Management
• Compensation
• Learning
• Absence Management
• Payroll
• Strong experience in:
• Oracle Integration Cloud (OIC)
• HCM Extracts
• HDL/HSDL
• Fast Formula
• BI Publisher
• OTBI
• REST and SOAP Web Services
• Proven experience with Oracle Visual Builder Studio (VBS) and Redwood UI customizations.
• Experience in page composer, page extensions, business rules, and custom validations.
• Strong SQL and data analysis skills.
• Knowledge of Oracle Cloud security, roles, and data access controls.
• Experience with Git/version control and deployment management.

Preferred Qualifications:

• Experience with Oracle Redwood transformation projects.
• Oracle Cloud HCM technical certifications.
• Experience integrating Oracle HCM with third-party HR/payroll systems.
• Knowledge of Oracle PaaS and SaaS architecture.

Key Deliverables:

• End-to-end HCM Cloud integrations.
• Redwood/VBS customizations and extensions.
• BI Publisher reports and HCM Extracts.
• HDL/HSDL data load solutions.
• Technical documentation and deployment support.
• Production support and issue resolution.

Mandatory Skills:

• Oracle HCM Cloud
• Oracle Integration Cloud (OIC)
• HCM Extracts
• HDL/HSDL
• REST/SOAP APIs
• BI Publisher & OTBI
• Visual Builder Studio (VBS)
• Redwood UI Customizations
• Fast Formula
• This role is ideal for a strong Oracle HCM technical consultant who can independently drive integration development and Redwood/VBS customization initiatives.