Job Title:
Associate Data Architect – Master Data Management (MDM)

Location:

Pune -
Hybrid

Experience:

10+ years of
experience in Data Architecture, Data Engineering/Integration with solid
exposure into Data Modelling and Database (RDBMS) Management.

About the
Role

We are seeking
an Associate Data/Database Architect to join our core product
architecture team building an enterprise-grade, multi-domain Master Data
Management (MDM) product platform.

You will play a
key role in optimizing and extending the MDM data model, implementing
productive data ingestion and entity resolution mechanisms, and ensuring
the system supports multiple domains such as Party
(Individual/Organization), Product, Location, Policy, and Relationship in a cloud-native and scalable manner.

Key
Responsibilities

Data
Modeling & Architecture
Enhance and extend the existing Party-based data
model into a multi-domain MDM schema (Party, Product, Location,
Relationship, Policy, etc.).
Design and maintain canonical data models and staging-to-core
mappings for multiple source systems.




Implement auditability, lineage, and soft-delete
frameworks within the MDM data model.
Contribute to the creation of golden records, trust
scores, match/merge logic, and data survivorship rules.
Ensure the model supports real-time and batch data
mastering across multiple domains.

Data
Engineering & Integration
Help support to optimize data ingestion and
ETL/ELT pipeline using Python, PySpark, SQL, and/or Informatica (or equivalent tools).
Design and implement data validation, profiling,
and quality checks to ensure consistent master data.
Work on data harmonization, schema mapping,
and standardization across multiple source systems.
Help build productive ETL mappings from
canonical staging layers to MDM core data models in PostgreSQL.
Develop REST APIs or streaming pipelines
(Kafka/Spark) for real-time data processing and entity
resolution.

Cloud &
Platform Engineering
Implement and optimize

📌 Data Architect Pune
🏢 DataEconomy
📍 Pune