Data Modeler

Job Description

- 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

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

Exp. On the Service cloud or Tech Support that we need from SFDC standpoint