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.