Roles Responsibilities:

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

- Develop MDM Reference Data Models Governance Frameworks:
- Create canonical data models (ERDs, attribute dictionaries) aligned with party-role-relationship patterns. Establish data stewardship policies, SLAs, and accountability frameworks.

Lead Data Quality Profiling Assessment Initiatives:

- Execute data quality assessments using IDMC s DQ module to identify gaps in completeness, accuracy, and consistency. Translate findings into remediation roadmaps and establish baseline quality KPIs.
- Experienced in developing conceptual data model, logical data model, and physical data models.
- Experienced in developing conceptual data model, logical data model, and physical data models.
- Has experience in creating data models from end to end. (Recent Data Model to Database, Database to Data Model, SQL Scripts).
- Involved in Forward Engineering, Reverse Engineering Techniques.Created Several Fact Tables (Aggregate, Transaction, Snapshot) and Dimensions (Degenerate Dimensions, SCD 2).
- Partnered with development teams to design and implement robust database models.




- Developed Source to Target Mapping (STTM) from source systems through to data consumption layers.
- Performed data profiling to assess source data, uncover business processes, and distinguish relevant and irrelevant data elements.
- Translated business requirements into technical specifications by outlining Data Vault architecture for a POC Project.
- Proficient with tools such as Erwin, ER Studio, MySQL Workbench, and Oracle SQL Data Modeler.Has worked on Oracle, SQL Server, GCP, AWS, Snow Flake, and Azure from Data Modelling Perspective.
- Experience Big-Data using Apache Hadoop Commands and Hive.
- Experience in handling and managing traditional RDBMS projects.
- Performed and handled data migration involving RDBMSs (SQL Server, Oracle, MS Access) via ETL tools i.e. SSIS packages and SQL Server DTS jobs.
- Handled CM build and deployment of changes to QA, UAT, and Production environments.

Disclaimer: This job posting has been aggregated from external source. Role details, content, and availability are subject to change. Applicants are advised to confirm the latest information directly on the company website before applying.

📌 Data Modeler (MDM) (Uttar Pradesh)
🏢 Navikenz India
📍 Uttar Pradesh