Techiva is a leading information technology consulting firm helping clients realize the real benefits of technology. We deliver business-driven technology solutions that enable our clients to gain competitive advantage and reduce information technology costs. Visit us  at www.techiva.com to learn more about our capabilities.

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.