Data Modeler

Company Description

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.

Job Description

Position Summary:

The successful candidate will create or modify data models within the Product Domain.

6 month contract position - local candidates only

Qualifications

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) Additional Information 6 month contract position - local candidates only All your information will be kept confidential according to EEO guidelines.