MDM Data Modeller

Extensive experience in Data Modelling (Relational Data Modelling, Dimensional Data Modelling, and Data Vault Data Modelling)

1.       Experienced in developing conceptual data model, logical data model, and physical data models.

2.       Has experience in creating data models from end to end. (New Data Model to Database, Database to Data Model, SQL Scripts). Involved in Forward Engineering, Reverse Engineering Techniques.

3.       Created Several Fact Tables (Aggregate, Transaction, Snapshot) and Dimensions (Degenerate Dimensions, SCD 2).

4.       Partnered with development teams to design and implement robust database models.

5.       Developed Source to Target Mapping (STTM) from source systems through to data consumption layers

6.       Performed data profiling to assess source data, uncover business processes, and distinguish relevant and irrelevant data elements.

7.       Translated business requirements into technical specifications by outlining Data Vault architecture for a POC Project.

8.       Proficient with tools such as Erwin, ER Studio, MySQL Workbench, and Oracle SQL Data Modeler.

9.       Has worked on Oracle, SQL Server, GCP, AWS, Snow Flake, and Azure from Data Modelling Perspective

10.    4 years of experience Big-Data using Apache Hadoop Commands and Hive.

11.    7+ years of experience in handling and managing traditional RDBMS projects

12.    Performed and handled data migration involving RDBMSs (SQL Server, Oracle, MS Access) via ETL tools i.e. SSIS packages and SQL Server DTS jobs.

13.    Handled CM build and deployment of changes to QA, UAT, and Production environments.