At least 8-10 yrs of experience in Data Analysis & Data Modelling
Should have strong Data Modeling, Data Quality and Metadata Management
Experience with RDBMS and NO SQL Databases
Experience in Cloudera Big Data distribution would be advantage
Understand and translate business needs into data models supporting long-term solutions.
Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
Data Modelling (Conceptual, Logical and Physical) with E-R Modeling and Dimensional Modeling
Strong data modeling skills (i.e. conceptual, logical and physical model design, Star Schema/Snowflake schema design, Fact and Dimensions tables, Physical and logical data modeling). Data Modelling (Conceptual, Logical and Physical) with E-R Modeling and Dimensional Modeling.
Logical data modeling for both existing and new business subject areas in the Operational Data Stores, Business Intelligence solutions/Data Marts, and other applications.
Define & maintain BI/Data Warehouse methodologies, standards and industry best practice.
Work with IT, ETL & Reporting development teams to develop BI Platform Solutions.
Design and development database objects and scripts a long with data strategy and their associated policies.
Create Data Dictionary with full description of data element and its usage.
Proven ability to work with varied data infrastructures including relational databases, column stores, NoSQL databases, and file-based storage solutions.
Thorough understanding of database theory and practice (ETL,OLTP,OLAP, DataVault And Star Schema design patterns)
Must be a team-player and be able to work closely with technical teams and business users of the Data Warehouse.
Work with the internal teams and client stakeholders to create, review and implement the data models.
End - to-end Data Warehousing and Business Intelligence Architect implementation experience
Knowledge of any of the leading ETL and BI tools Ability to quickly locate and analyze data.
Ability to work effectively on multiple priorities with strict deliverable dates.
Building Effective Relationships, Customer Focus, Effective Communication, Coaching
Good communication skills