Senior Data Modeler with ErWin, SQL expertise

Job description

**Job Title - Senior Data Modeler** **Location - Bangalore, Chennai, Pune, Gurgoan, Kolkata** **Joining period - Immediate joiners** **Years of experience - 9~12 years** **# of rounds of interview - 2 virtual** **Roles and responsibilities -** - Role requires him/her to design and implement data modeling solutions using relational, dimensional, and NoSQL databases. - You will work closely with data architects to design databases using a mixture of conceptual, **physical**, and logical data models. - Ability to design and deliver conceptual, logical, and **physical data models** - **Proven experience creating sourcetotarget mappings from raw data to business data consumption layers** - Strong capability to analyze raw data and define business rules to convert data into meaningful information - Deep understanding of the Retail and Marketing domains - Advanced, handson expertise in **SQL** - Ability to analyze raw business data and transform it into robust analytical data models - **Solid understanding of star schema, snowflake schema, and Slowly Changing Dimensions (SCDs)** - Clear conceptual understanding of **data warehouse objects, including tables, views, materialized views, and external tables** **Required Skills** Required Skills - Data modeler, ErWin tool, **hands-on SQL coding, physical data model, Star Schema, Snowflake Schema, Slowly Changing Dimensions, Dimensional modeling, Data Management**