Job Description :

Hope you are doing great.
My name is Abhishek Srivastav and I''m a Recruitment Consultant / Advisor at Compunnel Software Group, Inc.
I wanted to touch base with you regarding the below requirement for one of our Client . Please see below the Job-Description for your review and provide me your updated resume along with best time of yours to discuss the same.

Role: Data Modeler
Location: Madison, WI
Duration: 3+months with possible extension

Job Description :
Data Modeler Requirements:
Communication and Requirements gathering:
Expertise in translating functional business requirements to technical requirements and design.
Strong communication skills with the ability to interact with stakeholders at all levels.
Ability to lead requirements gathering and logical design sessions necessary to understand and document the scope and business requirements.
Lead the translation of business needs into feasible and acceptable data-centric design solutions.
Ability to estimate and communicate the work effort to EDW management and Stakeholders.
Own the deliverables from inception, review and signoff of the deliverables.
Ability to translate business needs into technical designs.
Strong experience with EDW development lifecycle (SDLC and/or Agile)
Strong verbal and written communication, presentation and customer service skills.

Expertise in Data Analysis, Data Profiling, and advanced SQL programming, (PL/SQL preferred
Strong analytical skills with the ability to collect, organize, analyze, and disseminate significant amounts of information with attention to detail and accuracy.
Ability to interpret and analyze data from various source systems to support data integration and data reporting needs.
Ability to solve complex integration design challenges.

Experience building and maintaining complex data model assets.
Experience with ERWIN data modeler designing conceptual, logical and physical data models
Advanced skills in dimensional data model design
Experience creating a and maintaining DDL scripts.
Experience building Dimensional Data Models for Data Warehouse and Data Mart implementations.
Create conceptual, logical and physical data models Kimball frameworks using 3NF and de-normalized dimensional design philosophies.
Drive and document the source to target mapping with the ETL developers.
Design highly performant structures such as staging areas, integrated data, data marts, and operational data stores.
Suggest, document and enforce data warehousing best practices including overall Data warehouse architecture.
Review, improve and enhance existing models to ensure compliance with best practices.
Strong dimensional modeling and star schema design skills.
Experience required with any Data Modeling tool (Erwin preferred)
Experience with Informatica PowerCenter is a plus.
Experience with reporting tools such as IBM Analytics is a plus.
Experience with Peoplesoft is a plus.
Familiarity with Supply Chain and Asset Management is a plus.

If you are qualified, available, interested, planning to make a change, or know of a friend who might have the required qualifications and interest, please call me ASAP at Ext 2541., even if we have spoken recently about a different position. If you do respond via e-mail, please include a daytime phone number so I can reach you. In considering candidates, time is of the essence, so please respond ASAP. Thank you.