Hands-On – data modeling on SQL, Erwin (or equivalent)
Strong in Hadoop (Hortonworks, Cloudera)
Insurance domain preferable
Hands on experience in Data Modular
Data strategy and Data grievance is MUST (Need this in resume)
2 Positions – 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 an end to end processing
Experience with moderate SQL scripts (creating, reading, running, customizing)