The role involves the design and development of Essbase cubes, data integration, automation frameworks, and production support for Hyperion applications, requiring strong SQL Server and Hyperion expertise.
- 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.
- 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.
Top Skills
Aso
Bso
Business Rules
Hyperion Planning
Maxl
Mdx
Oracle Essbase
SQL Server
Ssis
Zensar Technologies Pune, Mahārāshtra, IND Office
Zensar Knowledge Park, Kharadi, Plot # 4, MIDC, Pune, Maharashtra, India, 411014
Similar Jobs
Artificial Intelligence • Cloud • HR Tech • Information Technology • Productivity • Software • Automation
The Director of Customer Outcomes GTM will lead Services Sales for Professional and Strategic Services, grow the business in India, coach a high-performing team, and drive transformational deals with strategic customers while exceeding revenue and margin targets.
Top Skills:
CsmHrsdItomItsmServicenow Ai Platform
.png)
Artificial Intelligence • Blockchain • Fintech • Financial Services • Cryptocurrency • NFT • Web3
Lead the development of AI-powered customer support solutions, guiding a team to build scalable, reliable, and secure systems using LLMs and third-party integrations.
Top Skills:
AIAWSGoKubernetesLangchainLlamaindexLlmsMlRubyVector Databases
Artificial Intelligence • Edtech • Mobile • Natural Language Processing • Productivity • Software
Lead the development of frontend systems, design user features, mentor engineers, and ensure operational excellence while collaborating with cross-functional teams.
Top Skills:
CSSNode.jsPythonReactTypescript
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
