• Data Warehousing Data Model Concepts ( Star Schema , Snowflake Schema and related Dimensional Modeling Skills )
• Big Data (Hadoop / Hive) concepts and application to the Data Warehousing scenarios.
• Skillset in Design of Data Integration / ETL Jobs (in terms of creating the Data Integration Documents).
• ERWIN / Other Tools skills related to Data Modeling
• Exposure to Microsoft Azure Tech – (would be a positive).


Experienced in Data Modeling, Data Analysis and model representation
Experienced in requirements analysis for converting business requirements to data models
Experienced in Data Modeling and normalization using relational models and schemas
Experienced in Data presentation and story telling
Experienced in creating and maintaining Conceptual and Logical data models, and data dictionary
Responsible for conducting review meetings with Business and IT stakeholders in various functions
Responsible for Defining and governing data modeling standards, tools, and best practices
Responsible for Analyzing data flows between various systems
Coordinate with IT SMEs to understand physical data in source systems and map it to the logical data model.
Experienced in following tools:
ERWin or similar tool
RDBMS Data Tools like Toad
Knowledge of following languages
DAX
SQL
Strong interpersonal skills with the ability to work with clients to establish models
– Ability to translate business requirements into plausible data models for articulation to other development staff;
– Flexibility and ability to adapt change
– Positive attitude and high proactivity
– Strong English language knowledge: understanding, speaking and writing