Position Summary:
The successful candidate will create or modify data models within the Product Domain.
6 month contract position - local candidates only
Required Skills and Experience:
•5 – 7 years in data modeling experience - at the logical and physical level, with a strong focus on OLTP. Dimensional modeling experience is a plus.
•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.
•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)
•Retail experience
Required Technologies: OLTP RDBMs (MS SQL Server), Data modeling tools (Erwin 9.5 and Model Mart), Experience with GS1, Proficient with writing SQL
Optional Technologies: OLTP RDBMs (DB2, Oracle v10g), OLAP (Teradata, Netezza), Data warehouse schemas (Star, Snowflake), dimensional data modeling, SQL Tools (AQT, SQL Navigator)
6 month contract position - local candidates only
All your information will be kept confidential according to EEO guidelines.
Job details are sourced from the employer's original posting.
Open job postingAbout the company
Techiva is a leading information technology consulting firm helping clients realize the real benefits of technology.