Job Description

Job Title: Associate Data Architect - Master Data Management (MDM)
Location:
Pune - Hybrid
Experience:
10+ years of experience in Data Architecture, Data Engineering/Integration with strong 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 efficient 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 efficient 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 pipelines on AWS or Azure using native services (e.g., AWS Glue, Lambda, S3, Redshift, Azure Data Factory, Synapse, Data Lake).

• Deploy and manage data pipelines and databases following cloud-native, cost-effective, and scalable design principles.

• Collaborate with DevOps teams for CI/CD, infrastructure-as-code, data pipeline and database deployment/migration automation.

Governance, Security & Compliance

• Implement data lineage, versioning, and stewardship processes.

• Ensure compliance with data privacy and security standards (GDPR, HIPAA, etc.).

• Partner with Data Governance teams to define data ownership, data standards, and stewardship workflows.

Requirements
Technical Skills Required
Core Skills

• Data Modelling: Expert-level in Relational (3NF) and Dimensional (Star/Snowflake) modelling; hands-on in Party data model, multi-domain MDM, and canonical models.

• Database: PostgreSQL (preferred), or any enterprise RDBMS.

• ER Modelling Tool - Erwin/ERStudio, Database Markup Language (DBML).

• ETL / Data Integration: Informatica, Python, PySpark, SQL, or similar tools.

• Cloud Platforms: AWS or Azure.

• Programming: Advanced SQL, Python, PySpark, and/or UNIX/Linux scripting.

• Data Quality & Governance: Familiarity with data quality rules, profiling, match/merge, and entity resolution.

• DevOps - Version Control & CI/CD: Git, Azure DevOps, Jenkins, Terraform, Redgate Flyway (preferred)

Database Design & Optimization (PostgreSQL)

• Design and maintain normalized and denormalized models using advanced features (schemas, partitions, views, CTEs, JSONB, arrays).

• Build and optimize complex SQL queries, materialized views, and data marts for performance and scalability.

• Tune RDBMS (PostgreSQL) performance - indexes, query plans, vacuum/analyze, statistics, parallelism, and connection management.

• Leverage RDBMS (PostgreSQL) extensions such as:

• pg_trgm for fuzzy matching and probabilistic search.

• fuzzystrmatch, pg_vector for semantic similarity and name matching.

• hstore, jsonb for flexible attribute storage.

• Implement RBAC, row-level security, partitioning, and logical replication for scalable MDM deployment.

• Work with stored procedures, functions, and triggers for data quality checks and lineage automation.

• Implement HA/DR, backup/restore, database-level encryption (at-rest, in-transit), column-level encryption for PII/PHI data.

Good to Have

• Knowledge of Master Data Management (MDM) - Customer, Product etc.

• Experience with graph databases like Neo4j for relationship and lineage tracking.

• Knowledge of probabilistic and deterministic matching, ML-based entity resolution, or AI-driven data mastering.

• Experience in data cataloging, data lineage tools, or metadata management platforms.

• Familiarity with data security frameworks and Well-Architected Framework principles.

Soft Skills

• Strong analytical, conceptual and problem-solving skills.

• Ability to collaborate in a cross-functional, agile environment.

• Excellent communication and documentation skills.

• Self-driven, proactive, and capable of working with minimal supervision.

• Strong desire to innovate and build scalable, reusable data frameworks.

Education

• Bachelor's or master's degree in computer science, Information Technology, or related discipline.

• Certifications in AWS/Azure, Informatica, or Data Architecture are a plus.

Benefits
Why Join Us

• Be part of a cutting-edge MDM product initiative blending data architecture, engineering, AI/ML, and cloud-native design.

• Opportunity to shape the next-generation data mastering framework for multiple industry domains.

• Gain deep exposure to data mastering, lineage, probabilistic search, and graph-based relationship management.

• Competitive compensation, flexible working and a technology-driven culture.

Skills Required