Data Modelling Professional (Ghaziabad)

Data Modelling Professional (Ghaziabad)

19 Nov
|
Velocitai Digital
|
Ghaziabad

19 Nov

Velocitai Digital

Ghaziabad

JD & Key Responsibilities:
- Analyze business requirements, source-system structures, sample data, DDLs, JSON/XML files and existing documentation.
- Identify business entities, attributes, relationships, cardinality, optionality, keys and applicable business rules.
- Develop and maintain conceptual, logical, and physical data models.
- Design source-aligned bronze models, integrated and standardized silver models, and dimensional gold models.
- Develop dimensional models using star and snowflake schemas for warehouse and reporting requirements.
- Define fact-table grain, measures, dimensions, conformed dimensions, hierarchies, and Slowly Changing Dimension requirements.
- Use ERwin Data Modeler or an equivalent tool for model creation, reverse engineering, forward engineering, compare/merge, and DDL generation.
- Define table and column names, business definitions, datatypes, lengths, nullability, default values, primary keys, foreign keys, natural keys and surrogate keys.
- Prepare source-to-target mappings, transformation rules, data dictionaries, model specifications, and logical-to-physical mapping documents.
- Design technical columns for auditability, lineage, batch processing, record status, effective dates, and historical tracking.
- Support SCD Type 1 and SCD Type 2 implementation and define surrogate-key, sequence,



and hash-key strategies.
- Apply naming conventions, modeling standards, reusable domains, reference-data patterns, and design guidelines.
- Work with Teradata teams to translate logical models into implementable physical designs, including Primary Index, partitioning and NoPI considerations.
- Collaborate with ETL, BI, data-quality and governance teams to align transformations, targets, metadata, lineage, and controls.
- Conduct model walkthroughs, resolve review comments, and validate implemented database structures against approved physical models.
- Maintain model versions, change logs and traceability between requirements, models, mappings and implemented objects.

Qualifications & Experience:
Education: B.E./B.Tech/M.Tech/MCA
Primary Skills: Conceptual, Logical and Physical Data Modeling; Relational and Dimensional Modeling; ERwin Data Modeler or any other Data Modeling Tool; Source-to-Target Mapping; SQL and Database Fundamentals; OLTP and OLAP Modeling

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 Modelling Professional (Ghaziabad)
🏢 Velocitai Digital
📍 Ghaziabad

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: data modelling professional (ghaziabad) / ghaziabad

Subscribe to this job alert:

Get the latest job offers by email for: data modelling professional (ghaziabad) / ghaziabad