Data Modeler Whippany, NJ 07981, USA 24+Months Contract Core Tools or Technologies 1. Erwin Data Modeling Tool (Preferably version 8 or above)andor ER Studio Data Modeling tool (preferably version 16 or above) 2. Oracle 10g or above 3. Hadoop HDFS, Hive, HBase 4. Microsoft Word, Excel and Power Point 5. SQL (Structure Query Language) skills Core Capabilities ER Diagram design Logical Physical Model design Snow Flake and Star Schema design Metadata Management (Data Dictionary and Data Lineage) Data Normalization and De-Normalization rules knowledge Source to Target mapping document creation skills Responsible for identifying data entities and describing the relationships between them, as a model, based on business context, process and existing systems clearly showing source to target mappings. Generally a data modeler is concerned with intra-system data design. Understand the concepts of persistent and transient data design modelling including entity-relationship, conceptual, logical and physical models. High-level data design patterns frameworks (e.g. Kimball, Inmon, Data Vault, NoSQL, XML, canonical models) Derive data concepts from documented requirements Ability to clarify requirements with stakeholders to resolve gaps, uncertainties and conflicts Familiar with concepts of Relational Data-Base Management Systems (RDBMS) Big Data Extract Transform Load (ETL) Business Intelligence (BI) and Analytics toolsets Understands the concepts of data entities, attributes, relationships Understands the use of advanced constructs including super-typessub-types, self-referencing relationships and arcs Can identify logical entities from a business scenario and determine full scope of relationship cardinalities including optionality Build complex logical models featuring distinctions including identifyingnon identifying relationships, subtype discriminators Good knowledge of at least one major RDBMS' physical metadata capabilities. Can build a basic physical schema and objects based on a provided logical model Familiar with modelling approaches to change data capture (slowly changing dimensions) Can create comprehensive multidimensional models based on in-principle reporting requirements Understand building blocks of Hadoop like HDFS, MapReduce and YARN Understand Hive and HBase storage mechanism Lisa Matthew 302-###-####

* 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.

Launch your career - Upload your resume now!

Upload your resume

Loading some great jobs for you...