Data Modeling

Data Modeling needs 7 + years of experience in Data Modeling & Data Analysis and should have excellent communication and leadership skills.

Data Modeling requires:

o Financial Domain knowledge is plus.

o Strong understanding of cloud Datawarehouse like Snowflake and Data modelling skill using Data Vault 2.0.

o In depth understanding or executed new concepts like Data Lakehouse and should have worked on Big Data sources / tools such as Hive, S3, Trino, HUE, etc.

o Complex (100+ entities/tables) Data Modeling programs in both on-prem and cloud environments.

o Experience in designing normalized, denormalized, relational, dimensional, star and snowflake schemas for cloud, big data and on prem databases using any one of these data modeling tools (Erwin, ER/Studio, Toad Data Modeler, etc.)

o Extensive Data Modeling experience in same or similar bigdata and cloud databases such as Hive, Redshift, Snowflake and on prem databases such as Oracle, SQL Server and DB2

o Experience in working with product managers, project managers, business users, applications development team members, DBA teams and Data Governance team daily to analyze requirements, design, development, and deployment technical solutions.

o Implemented Bill Inmon and Ralph Kimball methodologies to design data warehouses

o In depth understanding on Data Warehousing, Data Analysis, Data Profiling, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy, and Data Governance.