Job Description
As a Data Modeler, you will be responsible for working with key business representatives, data owners, end users, application designers, and data architects to model current and new data as the primary skill. Your typical day will involve working with Snowflake, Sql-Sever, and Matillion to develop and maintain data models.
Requirements
- Deep knowledge of Kimball and Inmon approaches and the core differences
- Experience in data modeling principles/methods including conceptual, logical & physical Data Models
- Extensively used Star Schema methodologies in building & designing logical models.
- Ability to translate a logical model into a physical model (reverse engineering), adding appropriate physical objects needed to create the database
- Create/expand the existing Star Schema especially building Facts, Dimension, slowly changing dimension ( Type 1,2,3).
- Strong Understanding and implementation experience on a grain of facts, factless facts, type of facts, and fact table types.
- Strong Understanding and implementation experience in Dimensions, denormalization of Dimensions ( Snowflake to Star), Confirmed dims, Role-playing dims, Outriggers, and mini dimensions.
- Strong Understanding and implementation experience in ER modeling.
- Build aggregates on top of facts to meet performance SLAs.
- Hands-on experience in SQL DBM tool, and Snowflake database.
Benefits
- We're recognized as a Niche Player in the 2023 Gartner® Magic Quadrant™ for Public Cloud IT Transformation Services. It's not just an achievement; it's a testament to our dedication to cloud excellence and innovation
A culture where the #ninecorevalues are believed in and role modelled. Yes, you get rewarded for it too! - A culture of #keeplearning. We are interested in how you are grooming yourself for the next level of growth opportunity rather than target crunching and coding away. A meaningful career is a mandate for us!
- A culture where the leadership team believes in utmost transparency and is prompt in its communication initiatives with the clan
- A culture which fosters many lifelong connections and we literally have clan@clan working with us
- Work-life Balance and prioritising mental wellbeing are more than just buzz words for us. We are prioritising them at the clan
- Finally, a clan which is a close-knit family of ambitious and intelligent minds, raring to take Blazeclan to the next level and making it the #firstbornincloudconsultingunicorn
- All of the above, has got us a hattrick at being a GPTW, India and Singapore!
Job Opening ID
BL_1621_JOBID
Assigned Recruiter(s)
Priya Kava
Job Opening Status
In-progress
Skill Set
Data Modeler
Industry
IT Services
Sub Skill
MSSQL; Data Modelling; Snowflake
Work Experience
6+ year(s)
City
Pune City
State/Province
Maharashtra
Country
India
Zip/Postal Code
411005