We are looking for Sr. Data Modeler with Hadoop for our client in Clinton, NJ
Job Title: Sr. Data Modeler with Hadoop
Job Location: Clinton, NJ
Job Type: Contract
Basically need resources who are hands on with day to day data modelling activities with good insurance background + working knowledge of Hive/ Hadoop , who can perform analysis, design etc.
Below skills are mandatory:
Hands On data modeling on SQL, ErWin (or equivalent)
Strong in Hadoop (Hortonworks, Cloudera)
Insurance domain preferable
8+ years of experience with last 5 years in Data Modelling role proficient with entity relation diagrams, logical/physical data models creation, review, and analysis and issue resolution
Remaining can be 8+ years of experience with last 4 years in Data Modeling role proficient with entity relation diagrams, logical/physical data models creation, review, and analysis and issue resolution
Work independently and with Business Analysts and SMEs to gather, document and explain requirements
Ability to apply modeling standards to logical and physical ERDs
Ability to work with the Development team.
Experience with data mapping (ETL data mapping with defined technical and business rules. Complex logic, not only 1:1 data mapping)
Experience with data modeling concepts (conceptual/logical/physical/semantic, multi-dimensional models (star, snowflake), normalized/denormalized models)
Experience with understanding data - profile and analysis (metadata (formats, definitions, valid values, and boundaries), relationship/usage)
Experience with data warehousing.
Experience driving data design and end to end processing
Experience with moderate SQL scripts (creating, reading, running, customizing)
Work independently with minor oversight
Excellent interpersonal skills necessary
Life insurance experience is a plus.