Essbase Hyperion Consultant (Locals to IL)
External
Sonomaconsultinginc · Oak Brook, ILPrepare for this interview
EliteAI-generated questions, company research, and talking points tailored to this role
About the role
Job Description: Looking to migrate data from our Hyperion Planning environment where the data is stored in an Essbase multi-dimensional database, into our Enterprise Data Warehouse. This involves taking the fragmented multi-dimensional hierarchical structures and translating them into meaningful relational structures. The hierarchical data needs to be aligned across each dimension into meaningful business grouping and terms that can be stored in a relational / star schema format. Data relationships need to be identified, documented and mapped. Work with Kemper data architect to determine the best EDW target structures (star schema). Document data transformations for the ETL developer. Test data loaded from Essbase into the EDW for completeness and accuracy. Knowledge of Essbase, relational DB and financial processes are needed. Insurance experience would be extremely helpful. H1b, US Citizens, GC, EAD and TN Permit. Skills: Essbase, Multidimensional, Hyperion, Data warehouse, ETL Title: Essbase Conusltant, Hyperion Developer, Hyperion Consultant, Data Analyst,
Your Match
How well this role fits your profile.
Company Intel
What employees say
Worked at Sonomaconsultinginc? Share your experience