Job Description :

Please send in resume and ph#


Location – new york NY

Data Modeling Skills
Extensive data modeling experience - Normalized ER modeling and dimensional modeling. In dimensional modeling, the resource should be able to demonstrate hands-on experience in designing slowly changing dimensions, understanding and implementation of the CDC process, metrics design.
Should be comfortable modeling right from the conceptual modeling to logical and physical modeling.
Should be able to demonstrate sound data modeling standards knowledge, approach to requirements gathering, physical model translations etc.
Should show in-depth skills in database layer, semantic layer architectures.
In Depth understanding of data warehouse architecture. Expertise with Hadoop (Hive, Spark, Scala, Impala), Teradata is preferred.
Extensive experience in using data modeling tool, PowerDesigner. This is to include the following:
Creating models from scratch
Reverse engineering databases and structures from flat files.
Creation of multiple physical models from single logical models
Database creation & DDL generation
Building data dictionary
PowerDesigner model reporting
PowerDesigner repository setup and management
The candidate should have experience working with ETL and data visualization / analytics teams since modeling and data design will need to cater to the individual requirements during the physical modeling process.