Associate Software Engineer - Essbase Developer

Role Overview

Join CGI in Hyderabad to support the PNC Financial Services Group. As an Associate Software Engineer - Essbase Developer, you will join our Enterprise Performance Management (EPM) team to develop, maintain, and optimize Oracle Essbase applications, supporting critical financial planning and reporting solutions for a global enterprise.

Responsibilities

• Design, develop, and maintain Oracle Essbase applications and multidimensional cubes.
• Develop and optimize Essbase calculation scripts, business rules, and MaxL scripts.
• Design and maintain ASO and BSO cubes, including outline management and performance tuning.
• Perform metadata management, data loads, aggregations, and cube refresh activities.
• Develop and support data integration and ETL processes between Essbase and enterprise applications.
• Write and optimize SQL queries for data extraction, validation, and reporting.
• Troubleshoot application issues, perform root cause analysis, and implement resolutions.
• Monitor and optimize cube performance to ensure scalability and efficient query execution.
• Implement security, user provisioning, and access controls.
• Support application upgrades, patching, migrations, and production deployments.
• Collaborate with business users to gather requirements and translate them into technical solutions.
• Ensure data accuracy, consistency, and integrity across integrated systems.
• Create and maintain technical documentation and participate in code reviews and testing.

Requirements

• 0-3 years of experience in software development or engineering.
• Strong expertise in Oracle Essbase and multidimensional database design.
• Proficiency in SQL and data integration/ETL processes.
• Ability to work in a hybrid model (initial 8 weeks WFO, followed by 3 days hybrid).
• Location: Hyderabad, India.
• Notice Period: Immediate to 30 days.

Skills

• Oracle Essbase
• SQL
• ETL
• MaxL
• ASO/BSO Cubes