Data Modeler - Short term contract

Job Description
Role: Data Modeler
Location: New York City, NY
Duration: 3--4 Months to start

Domain Knowledge
• P&C Insurance Mandatory

Experience
• 10+ years in Information Technology with Expertise in Data modeling for Data Warehouse/Data Mart development, Data Warehousing (OLAP)/Business Intelligence (BI) applications and Data Analysis for Online Transaction Processing (OLTP).
• Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions.
• Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications.
• Practical understanding of the Data modeling (Dimensional & Relational) concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables.
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing, data manipulation.
• Implemented Slowly Changing Dimensions - Type I & II in Dimension tables as per the requirements.
• Familiarity and experience in the work environment consisting of Business analysts, Production Support teams, Subject Matter Experts, Database Administrators and Database developers
• Good understanding of views, Synonyms, Indexes, Joins and Partitioning.
• Experience in extracting, transforming and loading (ETL) data from spreadsheets, database tables and other sources using Microsoft SSIS and Informatica.
• Created, documented and maintained logical and physical database models in compliance with enterprise standards and maintained corporate metadata definitions for enterprise data stores within a metadata repository.
• Established and maintained comprehensive data model documentation including detailed descriptions of business entities, attributes, and data relationships.
• Developed mapping spreadsheets for (ETL) team with source to target data mapping with physical naming standards, data types, volumetric, domain definitions, and corporate meta-data definitions.
• Exceptional communication and presentation skills and established track record of client interactions

Technical Skills
• Data Modeling Tools: Erwin and ER studio
• OLAP Tools: SAP Business Objects
• ETL Tools: Microsoft SSIS and Informatica 7.1.3
• Database Tools: Microsoft SQL Server 2000/2005/2008,2012
• Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects
• Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Qualifications
Technical Skills
• Data Modeling Tools: Erwin and ER studio
• OLAP Tools: SAP Business Objects
• ETL Tools: Microsoft SSIS and Informatica 7.1.3
• Database Tools: Microsoft SQL Server 2000/2005/2008,2012
• Packages: Microsoft Office Suite, Microsoft Project 2010, SAP Business Objects
• Operating Systems: Microsoft Windows 9x/NT/2000/XP/Vista/7 and UNIX

Additional Information
Warm Regards

Ravi Jaiswal

Pyramid Consulting, Inc.

Associate Manager Resourcing

________________________________________

O: 770-255-3104 M: 404-891-0420