Oracle Technical Consultant

Varun Beverages Limited

Gurugram District

Hybrid

INR 1,500,000 - 2,500,000

Full time

5 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Varun Beverages Limited is seeking an experienced Oracle Fusion HCM Technical Consultant to lead reporting, integrations, data migration, and Redwood UI configuration. The role focuses on OTBI dashboards, BI Publisher reports, HDL data loads, and OIC-based integrations across Oracle Fusion HCM, HR letters, and templates.

The candidate will work with REST/SOAP APIs, SQL/PL-SQL, and Fast Formulas, ensuring data accuracy and smooth deployment through development to production cycles.

Qualifications

  • Must have strong OTBI Reports & Dashboards experience.
  • Proficient in BI Publisher and HCM Extracts.
  • Strong Fast Formula development skills.
  • Experience with HDL/HSDL data migration.
  • Knowledge of Redwood UI configuration and support.
  • Experience with Oracle Integration Cloud (OIC).
  • Proficient in REST/SOAP APIs and file-based integrations.
  • Strong SQL and PL/SQL skills.
  • Experience with SIT/UAT and production support.

Responsibilities

  • Develop and maintain OTBI dashboards, analyses, prompts, and interactive reports.
  • Develop BI Publisher reports, HR letters, and notifications, including templates and formats.
  • Design and manage OIC integrations between Oracle Fusion HCM and third-party apps.
  • Develop and maintain HCM Extracts for outbound data and reporting.
  • Prepare HDL data loads and migration for Oracle Fusion HCM.
  • Develop and test Oracle Fusion HCM Fast Formulas and document them.
  • Support Redwood UI changes and validate pages and workflows.
  • Coordinate configuration migrations and deployment across environments.

Skills

OTBI Reports & Dashboards
BI Publisher & HCM Extracts
Fast Formula Development
HDL/HSDL Data Migration
Redwood UI Configuration & Support
Oracle Integration Cloud (OIC)
REST/SOAP APIs & File-Based Integr.
SQL & PL/SQL
SIT/UAT & Production Support

Education

Oracle Fusion HCM technical certification preferred.
Relevant experience in Oracle Fusion HCM implementation and support.

Tools

Oracle Visual Builder (VBCS)

Job description

Job Summary
Key Responsibilities
Primary Focus: HCM Reporting, Integrations, Data Migration, and Technical Configuration
1. OTBI Dashboards and Analytics
  • Develop and maintain OTBI dashboards, analyses, prompts, and interactive reports.
  • Build reports using appropriate HCM subject areas across All modules and Workforce Structures.
  • Apply filters, parameters, calculations, and dashboard-level configurations as required.
  • Troubleshoot data discrepancies, reporting access, and performance issues.
  • Validate report output against business requirements.
2. BI Publisher Reports, Letters, and Notifications
  • Develop and maintain BI Publisher reports using SQL, data models, data sets, parameters, and templates (RTF, Excel, ETF).
  • Develop reports across all modules, Workforce Structures, and Transaction Console-related reporting requirements.
  • Design and maintain HR letters, including offer letters, appointment letters, transfer letters, termination and relieving letters, and other employee-related documents.
  • Configure and troubleshoot document templates, dynamic fields, conditional sections, and formatting.
  • Develop or maintain HCM notification templates and troubleshoot notification-related issues using supported Oracle Fusion capabilities.
  • Support scheduled reports, bursting, and report delivery where required.
3. Oracle Integration Cloud (OIC) Third-Party Integrations
  • Design, develop, enhance, and support integrations between Oracle Fusion HCM and third-party applications using OIC.
  • Work with REST and SOAP APIs, relevant adapters, data mappings, lookups, and fault-handling mechanisms.
  • Support inbound and outbound data integrations between HCM and external systems.
  • Monitor integration executions, troubleshoot failures, and implement corrective actions.
  • Coordinate integration testing with functional teams and third-party application owners.
4. HCM Extracts
  • Develop, configure, and maintain HCM Extracts for outbound data integrations and reporting requirements.
  • Configure extract definitions, data groups, records, attributes, and filtering criteria as applicable.
  • Support delivery options and integration with downstream systems.
  • Troubleshoot extract execution, data completeness, and delivery issues.
  • Validate extracted data against business requirements and source HCM records.
5. HCM Data Loader (HDL) and Data Migration
  • Prepare, execute, and troubleshoot HDL data loads for Oracle Fusion HCM.
  • Develop and validate data-load files, mappings, and source-to-target transformations.
  • Support migration of HCM data, including relevant worker, assignment, and workforce structure records.
  • Analyze import and load errors and resolve data validation issues.
  • Perform post-load reconciliation and coordinate data validation with functional teams.
6. Fast Formulas
  • Develop, configure, test, and troubleshoot Oracle Fusion HCM Fast Formulas.
  • Support applicable formula types based on business requirements and module scope.
  • Analyze formula execution errors and resolve issues in coordination with functional teams.
  • Maintain formula documentation and support regression testing.
  • Validation Fast Formulas All existing FF’s
7. Redwood UI Changes
  • Support Oracle Fusion HCM Redwood UI adoption and related configuration changes.
  • Assess the impact of Redwood changes on existing business processes and user experiences.
  • Support testing and validation of Redwood pages, workflows, and related functionality.
  • Troubleshoot configuration or usability issues in coordination with functional teams.
  • Support regression testing following Redwood-related changes and Oracle quarterly updates.
  • Redwood pages configurations (Validation) as per Business Requirement.
8. Configuration Migration and Deployment Pipeline (Development to Production)
  • Support the migration of eligible configurations and technical artifacts across development, test, and production environments.
  • Understand and use Oracle-supported migration tools and deployment processes applicable to each artifact type.
  • Prepare migration checklists, validate dependencies, and coordinate deployment activities.
  • Perform pre-deployment and post-deployment validation.
  • Support deployment of reports, integrations, extracts, formulas, and other eligible configurations using the appropriate migration method.
  • Maintain deployment documentation, version control, rollback considerations, and environment-specific validation procedures.
Required Skills (Must Have)
  • OTBI Reports & Dashboards
  • BI Publisher and HCM Extracts
  • Fast Formula Development
  • HDL/HSDL Data Migration
  • Redwood UI Configuration and Support
  • Oracle Integration Cloud (OIC)
  • REST/SOAP APIs and File-Based Integrations
  • SQL and PL/SQL
  • SIT/UAT and Production Support
Good to Have Skills
  • Oracle Visual Builder (VBCS)
  • Oracle HCM quarterly release management
  • SAP integration experience
  • Oracle HCM technical certification
Preferred candidate profile
Soft Skills
  • Strong analytical and problem-solving skills
  • Effective communication and stakeholder management
  • Documentation and troubleshooting skills
  • Ability to work independently and manage multiple priorities
Qualifications
  • Oracle Fusion HCM technical certification preferred.
  • Relevant experience in Oracle Fusion HCM implementation and support.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Hris Specialist
Senior Hris Specialist

Varun Beverages Limited • Gurugram District

On-site
INR 1,100,000 - 1,900,000
Oracle Techno-Functional Consultant
Oracle Techno-Functional Consultant

Varun Beverages Limited • Gurugram District

On-site
INR 1,500,000 - 2,300,000
Oracle HCM
Oracle HCM

MetLife, Inc. • Pune District

On-site
INR 1,200,000 - 2,400,000
Oracle Fusion HCM Consultant
Oracle Fusion HCM Consultant

Frontend Arts • Hyderabad

On-site
INR 2,400,000 - 3,200,000
Oracle Fusion Technical Consultant
Oracle Fusion Technical Consultant

Conduent, Inc. • Bengaluru, Hyderabad

Hybrid
INR 1,200,000 - 1,800,000
Oracle Fusion Techno Functional Consultant (HCM)
Oracle Fusion Techno Functional Consultant (HCM)

Oasis TechnoSoft Pvt Ltd • Gurugram District

On-site
INR 1,200,000 - 2,400,000
Oracle HCM BIP/OTBI (FDI) - Manager
Oracle HCM BIP/OTBI (FDI) - Manager

PwC • Kolkata District, Hyderabad, Bengaluru

Hybrid
INR 1,500,000 - 3,000,000
Oracle Cloud Technical Developer
Oracle Cloud Technical Developer

Jade Global • Pune District

Hybrid
INR 1,600,000 - 3,400,000
Oracle Functional Consultant
Oracle Functional Consultant

SourcingXPress • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Oracle Fusion Cloud Technical Consultant
Oracle Fusion Cloud Technical Consultant

Finonyx Software Solutions Pvt Ltd • Bengaluru

On-site
INR 3,500,000 - 6,000,000