Hi, Role: Data Modeler Consultants Location: NYC, NY Duration: 12+ months Need Locals or nearby who can go for Face2Face interview... Required 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, Power Designer. 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 Power Designer model reporting Power Designer 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. Data Analysis Skills Domain Experience: Capital Markets, Wealth Management (Advisory and Brokerage), Retail Banking. This will require a thorough understanding of investment products concepts, Market Data, etc. Retail banking knowledge would involve knowledge on concepts like Loans, Mortgage, HELOC etc. Understanding of securities data. Should be able to demonstrate sound data modeling standards knowledge, approach to requirements gathering, physical model translations etc. An aptitude for data discovery, mining and translating business understanding to detailed requirements for data architecture. Best Regards Ashok Infinity Tech Group Inc, | 292 Main Street, Suite 6 | Hackensack, NJ 07601 | (Office) 201-###-#### | (F) 201 ### ####| Email: ...@infigroup.com | www.infigroup.com Certifications: NMSDC / WBENC and MWBE Certified Awards: Fast 50 Asian American businesses in USA Partners: SAS Alliance Partner - provided by Dice Extensive data modeling, Strong in Power Designer, Data Analysis,Hadoop,
* The salary listed in the header is an estimate based on salary data for similar jobs in the same area. Salary or compensation data found in the job description is accurate.