What are the responsibilities and job description for the Senior Big Data Modeler - Data Vault 2.0 position at Boston Associate Software Systems?
Job Details
Should have in depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data sources / tools such as Hive , S3 , Trino , HUE , etc.
Should have done complex (100 entities/tables) Data Modeling programs in both on-prem and cloud environments .
Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc.)
Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Redshift, Snowflake and on prem databases such as Oracle, SQL Server and DB2