Data Modeler Job in Intersoft Data Labs

Data Modeler:

Required Skill Set:

• Hands on experience with ERWIN Data Modeler and Working on the Enterprise Data Mart.
• Understanding Metadata Management principles ( Data Dictionary activities ).
• Hands on experience with Creating the ETL Mapping.
• Should understand impacts of model changes on databases and to validate that a model supports straight-forward requirements.
• Hands on experience with 3NF Data Modeling and NORMALIZED schema.
• Should be able to analyse business requirements to develop data models with minimal oversight.
• Hands on experience implementing Data Warehouse presentation layer - including design and definition of logical tables, physical sources, columns, aggregation rules.
• Hands on experience in writing SQL queries, views, and optimization of SQL queries.
• Comprehensive Knowledge of Bill Inmon's Data Modeling Concepts (Logical and Physical) including 3NF, Supertypes, Subtypes, Abstraction, Associative entities / tables.
• Requires strong decision-making, organizational, planning and problem-solving skills.

Nice to have:

• Knowledge on other Data Modeling tools like Power Designer , Visio , ER studio.
• Comprehensive Knowledge of Ralph Kimball's Data Modeling Concepts including Transaction dimensions, conformed dimensions and facts, slowly changing dimension, multi-Star/ Snowflake Schema Modeling, different types of Fact tables.
• Implementing a virtual semantic layer (virtual star schema) using views on a multi-tiered normalized Integrated Operational Data Store is a huge plus . 3NF (Relational) Logical and Physical Modeling.