Oracle Essbase Developer - Aloden LLC

Location: San Francisco, California (Hybrid)

Candidate Preference: Local candidates or those within commuting distance of San Francisco, CA.

Work Authorization: W2 Candidates only

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.