- Data modeling for the storage layers (data lake / EDW) for the data marts
- Design and build physical and logical data models
- Prepare Data Mapping document for
- Source Data Store Raw Data store
- Raw Data Curated data store
- Curated data store Snowflake
- Snowflake data modelling
- Minimum 8+ years of data modeling experience
- Past Hospitality (Lodging/gaming) experience in leading Data analytics/ Data Transformation/ Cloud Migration programs preferred.
- Strong communication skills, able to explain technical concepts to business audiences
- Excellent oral and written communication and interpersonal skills
- Past Data modernization/ transformation experience involving Azure, Teradata (or similar DW tool), Snowflake, Databricks
Good Critical Thinking and proven problem solving abilities • Responsible for end-to-end understanding of the data model requirements • Working directly with customer’s SMEs and data architects to frame the logical and physical data models • Working with DBAs to implement the physical database • Work with customer SMEs and Extract, Transform, and Load (ETL) lead to come up with merging rules for common tables • Working on ETL lead on ETL design based on data migration and comparison require Required Skills Technical Skills- ,3NF data modeling Domain Skills- Nice to have skills Technical Skills- ,ER Modeling ,SQL Server Domain Skills- Technology Data Management
Roles & Responsibilities:
- Good Critical Thinking and proven problem solving abilities
- Responsible for end-to-end understanding of the data model requirements
- Working directly with customer’s SMEs and data architects to frame the logical and physical data models
- Working with DBAs to implement the physical database
- Work with customer SMEs and Extract, Transform, and Load (ETL) lead to come up with merging rules for common tables
- Working on ETL lead on ETL design based on data migration and comparison requirements
- Passing on all understanding gathered from client to the offshore team and coordinate with offshore