Zensar logo

ESaaS - Oracle - Technical - Hyperion Development

4 - 8 years

8 - 12 Lacs

pune

Posted:15 hours ago| Platform: Naukri logo

Apply

Skills Required

performance tuning automation metadata production support data processing stored procedures oracle ssis hyperion planning sql

Work Mode

Work from Office

Job Type

Full Time

Job Description


  • Design, develop, and optimize

    BSO/ASO Essbase cubes

    including calculation scripts, business rules, and performance tuning.

  • Manage

    metadata, data loads, and integration processes

    between source systems (SQL Server, Oracle DB) and Hyperion Planning applications.

  • Develop and maintain

    automation frameworks

    using MAXL, Batch scripts, and

    SSIS packages

    .

  • Create and enhance

    SQL Server stored procedures, functions, and dynamic SQLs

    to support data processing requirements.

  • Build and customize

    Smart View reports, Query Designer outputs, and workflows

    for end-users.

  • Troubleshoot, debug, and modify existing code to resolve complex issues in a timely manner.

  • Collaborate with business teams to capture requirements and deliver

    technical design documents

    and scalable solutions.

  • Provide

    production support

    and enhancements for Hyperion Planning applications across global regions.

  • Contribute to knowledge sharing by documenting solutions, best practices, and reusable tools/scripts.


  • 4-8 years

    of hands-on experience in

    Oracle Essbase / Hyperion Planning

    development and post-launch support (version

    11.2.x

    required).

  • Strong expertise in

    BSO/ASO cube design and performance tuning

    .

  • Proficiency in

    Essbase Calc Scripts, Business Rules, MAXL, MDX, and automation scripting

    .

  • Solid experience in

    SQL Server 2016+

    (stored procedures, packages, functions, dynamic SQL).

  • Hands-on with

    SSIS

    for data integration and automation workflows.


  • Design, develop, and optimize

    BSO/ASO Essbase cubes

    including calculation scripts, business rules, and performance tuning.

  • Manage

    metadata, data loads, and integration processes

    between source systems (SQL Server, Oracle DB) and Hyperion Planning applications.

  • Develop and maintain

    automation frameworks

    using MAXL, Batch scripts, and

    SSIS packages

    .

  • Create and enhance

    SQL Server stored procedures, functions, and dynamic SQLs

    to support data processing requirements.

  • Build and customize

    Smart View reports, Query Designer outputs, and workflows

    for end-users.

  • Troubleshoot, debug, and modify existing code to resolve complex issues in a timely manner.

  • Collaborate with business teams to capture requirements and deliver

    technical design documents

    and scalable solutions.

  • Provide

    production support

    and enhancements for Hyperion Planning applications across global regions.

  • Contribute to knowledge sharing by documenting solutions, best practices, and reusable tools/scripts.

More Jobs at Zensar

Urgent Opening For GenAI with Python

Pune, Bengaluru, Hyderabad

6 - 10 yrs
|

INR 16 - 31 Lacs

PERL PL/SQL Developer

Pune

3 - 5 yrs
|

INR 8 - 9 Lacs

BUSINESS FINANCE MANAGER

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

5 - 15 yrs
|

INR 22 - 27 Lacs

Senior Data Architect

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

7 - 9 yrs
|

INR 9 - 11 Lacs

Martech resources - Internal

Chennai, Pune, Delhi, Mumbai, Bengaluru, Hyderabad, Kolkata

4 - 7 yrs
|

INR 9 - 13 Lacs

Mock Interview

Practice Video Interview with JobPe AI

Start Job-Specific Interview
cta

Start Your Job Search Today

Browse through a variety of job opportunities tailored to your skills and preferences. Filter by location, experience, salary, and more to find your perfect fit.

Job Application AI Bot

Job Application AI Bot

Apply to 20+ Portals in one click

Download Now

Download the Mobile App

Instantly access job listings, apply easily, and track applications.

Google Play App Store
coding practice

Enhance Your Skills

Practice coding challenges to boost your skills

Start Practicing Now
Zensar logo
Zensar

Information Technology and Services

Mumbai

RecommendedJobs for You

Zensar logo

ESaaS - Oracle - Technical - Hyperion Development

Zensar

pune

Wits Innovation Lab logo

MLOps Developer

Wits Innovation Lab

mumbai

Sbicap Securities logo

Oracle DBA - SBI Securities

Sbicap Securities

mumbai

Hdfc Bank logo

Lead Data Engineer

Hdfc Bank

navi mumbai

Evergent Technologies logo

Mysql Database Administrator

Evergent Technologies

hyderabad

Zensar logo

ESaaS - Oracle - Technical - Hyperion Development

Zensar

pune

Pega logo

Demo Engineer

Pega

hyderabad

Apptad logo

Reltio MDM Developer

Apptad

bokaro, dhanbad, jamshedpur, ranchi

Accenture logo

Data Modeler

Accenture

navi mumbai

Accenture logo

Data Modeler

Accenture

coimbatore