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 Chennai, Tamil Nadu, IND Office
1A, 9/1A, 2nd Floor, MGR Main Road, Kodandarama Nagar, Perungudi, Chennai, Tamil Nadu, India, 600096
Similar Jobs
Cloud • Information Technology • Productivity • Software • Automation
Design modern, reusable UI components, templates, and branded design systems for demos and POCs. Build front-end components and flows, maintain a shared UI asset library, collaborate with presales and field teams, and define best practices to accelerate POC delivery and improve visual consistency.
Top Skills:
BoomiBoomi FlowCSSFlow-Based EnvironmentsHTMLJavaScriptLow-Code PlatformsReact
Fintech • Professional Services • Consulting • Energy • Financial Services • Cybersecurity • Generative AI
Design, develop, customize, test, document, deploy, and support Microsoft Dynamics CRM/Dynamics 365 solutions. Configure entities, relationships, business process flows, and integrations. Collaborate with stakeholders and developers, produce requirements and documentation, and follow development best practices and established methodologies.
Top Skills:
.NetDynamics 365 Project OperationsJavaScriptMicrosoft Dynamics 365Microsoft Dynamics CrmPower PlatformWeb Services
Software • App development
The Software Engineer 1 - Frontend will design intuitive frontend interfaces, write clean code, collaborate with teams, and enhance product performance.
Top Skills:
AngularReactVue
What you need to know about the Chennai Tech Scene
To locals, it's no secret that South India is leading the charge in big data infrastructure. While the environmental impact of data centers has long been a concern, emerging hubs like Chennai are favored by companies seeking ready access to renewable energy resources, which provide more sustainable and cost-effective solutions. As a result, Chennai, along with neighboring Bengaluru and Hyderabad, is poised for significant growth, with a projected 65 percent increase in data center capacity over the next decade.
