Data Modeler (MDM)

Navikenz; Bengaluru; On-site; INR 1,200,000 - 1,600,000; Full time

Job summary

Navikenz is seeking a Data and AI Specialist in Bangalore. This full-time role involves extensive data modelling and data quality assessment. Candidates must have skills in creating MDM models, conducting data quality profiling, and familiarity with tools like Erwin and MySQL Workbench.

The successful applicant will develop governance frameworks and lead data quality initiatives, working on various database platforms including Oracle and SQL Server.

Qualifications

• Extensive experience in Data Modelling including Relational, Dimensional, and Data Vault.
• Proficient in developing conceptual, logical, and physical data models.
• Experience in source to target mapping and data profiling.

Responsibilities

• Develop MDM Reference Data Models and Governance Frameworks.
• Execute data quality assessments and establish quality KPIs.
• Partner with development teams for database model implementations.

Skills

Data Modelling

SQL

Data Quality Assessment

Data Migration

Big Data

ETL tools

Data Governance

Tools

Erwin

MySQL Workbench

Oracle SQL Data Modeler

Apache Hadoop

GCP

AWS

Snow Flake

Azure

Job description

Full-Time / Bangalore Noida / / Data and AI

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 fromend to end. (New 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.