Job Description

Data Modeller + Data Vault Experiences: 9-15 years Locations : Mumbai/Pune/Bangalore/Chennai/ Hyderabad Primary Skills : Dimensional Data Modeling/ Data Vault Data Modelling, Data Analysis, Data Warehouse Desired Skills & Responsibilities Data modeling for Data Warehouse/Data Mart development, Data Analysis for Online Transaction Processing (OLTP) and Data Warehousing (OLAP)/Business Intelligence (BI) applications. Exposure in overall SDLC including requirement gathering, development, testing, debugging, deployment, documentation, production support and Extensive experience in Project Management methodologies, Microsoft SQL Server database management. Involved in various projects related to Data Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments. Facilitated data requirement meetings with business and technical stakeholders and resolved conflicts to drive decisions. Worked extensively on Erwin and ER Studio in several projects in both OLAP and OLTP applications. Working Experience in Data Vault Modelling. 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 on multiple tools.

foundit