- Communication Skills
- Data Modeling
- Application Development
Required Skills and Experience:
5 – 7 years in data modeling experience - at the logical and physical level, with a strong focus on dimensional modeling/OLAP
Understanding of normalization of entities and tables; ensure use of proper constraints, naming standards, data types & lengths.
Transform logical data model to physical data model.
Generate DDL from physical data model for database implementation.
Document data mapping - source to target.
Maintain metadata documentation/dictionary information in data modeling tool
Work closely with business analyst(s) and IT resources to decipher business requirements and translate them to a logical data model.
Good communication skills - able to explain and walk through design concepts to various resources (business, application development, management)
OLAP RDBMS (Teradata, Netezza)
Data warehouse schemas (Star, Snowflake)
dimensional data modeling
SQL Tools (AQT, SQL Navigator)
Data modeling tools (Erwin 9.5 and Model Mart)
Proficient with writing SQL
Optional Technologies: OLTP RDBMS