Must have hands-on experience in Dimensional modeling, Data Profiling, Data Mapping, oracle SQL queries. Should know ERWIN Tool
Knowledge in Hadoop - Hive shell, HDFS, Impala
Hadoop development and implementation.
Table creation, data load, data management in Hive front end and Back end.
Loading from disparate data sets.
Designing, building, installing, configuring and supporting Hadoop.
Translate complex functional and technical requirements into detailed design.
Perform analysis of vast data stores and uncover insights.
Maintain security and data privacy.
Create scalable and high-performance web services for data tracking.
Maintaining consistency of Schema Definitions
Understanding of key Concepts related to Data Management including Domain Definition, naming standard usage, Data model Creation and management.
Responsible for reverse Engineering source systems and creating staging tables in consistent with physical table reqs and naming conventions in EDW.
Design an actionable, logical data model that promotes flexibility, simplicity, consistency and integrity
Design solutions for most efficient use of data, Capture and analyze key business metadata including data definitions for attributes in conceptual and logical models
Develop and implement data modeling standards and best practices
Ensure the transformational logical design meets the functional and performance requirements of the application
Create source to target mapping document between logical source and logical target data models
Design and develop logical and physical (relational/dimensional) data models required to support the existing and evolving frameworks
Maintain ERD and all other relevant documents.
Engage, communicate with, and manage expectations of relevant stakeholders
Cross team collaboration and hands-on technical skills are key to this role.