Description

Must-Have Skills & Experience:

  • Oracle Essbase Development: Extensive experience (10+ years) in designing, developing, and maintaining Oracle Essbase applications, including cube building, data loading, and performance optimization.
  • SQL: Proficiency in SQL for data extraction, transformation, and loading (ETL) processes.
  • Unix: Familiarity with Unix operating system and shell scripting for automation tasks.

Desired Skills & Experience:

  • RDBMS: Experience with relational database management systems (RDBMS) such as Microsoft SQL Server and Oracle Database.
  • Batch Automation: Knowledge of batch automation tools like Windows Scheduler and AutoSys.
  • Scripting Languages: Familiarity with scripting languages such as Python, Unix shell scripts, and Windows PowerShell/DOS command line.

Responsibilities:

  • Design, develop, and maintain Oracle Essbase cubes and applications.
  • Write and optimize complex SQL queries for data extraction and loading.
  • Develop and maintain scripts for automating Essbase processes.
  • Collaborate with business users to gather requirements and translate them into technical solutions.
  • Troubleshoot and resolve Essbase-related issues.
  • Optimize Essbase performance and ensure data integrity.
  • Stay up-to-date on the latest Oracle Essbase technologies and best practices.

Qualifications:

  • 10+ years of experience in Oracle Essbase development.
  • Strong understanding of data warehousing concepts and multidimensional modeling.
  • Excellent problem-solving and analytical skills.
  • Ability to work independently and as part of a team.
  • Effective communication and collaboration skills.


 

Education

Any Graduate