TMS, LLC · 1 day ago
Oracle Essbase Consultant – Databricks Migration
TMS, LLC is seeking a highly skilled Oracle Essbase Consultant to support an Essbase-to-Databricks migration initiative. The role involves hands-on data integration work, migration of existing workloads to Databricks, and ensuring data accuracy and performance post-migration.
SoftwareHuman ResourcesAutomotiveStaffing Agency
Responsibilities
Perform hands-on data integration and maintenance activities in Oracle Essbase
Support and manage BSO and ASO cubes
Analyze existing Essbase workloads and identify candidates for migration
Migrate and replace selected Essbase workloads with Databricks-based solutions
Design and validate data models and transformations during migration
Develop and optimize SQL queries for data analysis and reconciliation
Collaborate with data engineering, analytics, and business teams
Ensure data accuracy, performance, and scalability post-migration
Document migration processes, mappings, and best practices
Qualification
Required
Strong hands-on experience with Oracle Essbase
Proven experience with BSO (Block Storage Option) and ASO (Aggregate Storage Option) cubes
Experience with Essbase data integration tools
Strong SQL and data analysis skills
Ability to work independently while collaborating with cross-functional teams
Strong communication and documentation skills
Preferred
Experience with Databricks and cloud-based data platforms
Prior experience migrating legacy OLAP systems to modern analytics platforms
Knowledge of data warehousing and ETL frameworks
Company
TMS, LLC
Technology Management Solutions (TMS, LLC), headquartered in Parsippany, New Jersey, is a premier IT company specializing in digital product engineering and innovative technology solutions.
H1B Sponsorship
TMS, LLC has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (2)
2024 (4)
2023 (1)
Funding
Current Stage
Growth StageCompany data provided by crunchbase