Process Manager - Master Data Management (Validation & Integration)

Develop a working understanding of MDM golden record structures and how data flows from MDM 360 to downstream systems

Document data flows, field mappings, and transformation logic under the guidance of the P4 Analyst or BA Lead

Maintain and update data mapping registers, attribute lists, and business rule logs as requirements evolve

Assist in maintaining the MDM data dictionary — recording field definitions, data types, and ownership

Note and escalate data anomalies or gaps in documentation identified during analysis activities

Supporting validation across the consumption data flow — from MDM through to reporting:

Run and review data validation checks across: MDM golden records vs. API payload outputs Batch pipeline outputs vs. expected source data Snowflake consumption layer vs. MDM source records UI-displayed data vs. MDM and Snowflake outputs

MDM golden records vs. API payload outputs

Batch pipeline outputs vs. expected source data

Snowflake consumption layer vs. MDM source records

UI-displayed data vs. MDM and Snowflake outputs

Use SQL (with guidance) to query datasets, identify discrepancies, and validate attribute-level accuracy

Apply data quality checks across key dimensions — completeness, accuracy, consistency — and document outcomes

Log and track data quality issues in agreed tooling (e.g. JIRA, SharePoint, Excel trackers)

Escalate unresolved or high-impact data discrepancies to the P4 Analyst or BA Lead promptly

Support validation of MDM data used in financial and regulatory reporting layers

Assist in reconciliation activities between: MDM golden records and Snowflake reporting datasets Reporting outputs and expected business values for key financial attributes and hierarchies

MDM golden records and Snowflake reporting datasets

Reporting outputs and expected business values for key financial attributes and hierarchies

Document reconciliation results clearly — noting matched records, mismatches, and volumes

Assist in investigating data breaks and reporting discrepancies by gathering relevant data and preparing findings for P4 review

Track and follow up on outstanding reconciliation items through to resolution

From an analysis — not development — standpoint:

Review API payload structures (JSON) and validate that field mappings match agreed data specifications

Use API testing tools (Postman, Swagger) under guidance to inspect responses and document findings

Monitor batch job outcomes and validate data completeness and successful execution against expected results

Log pipeline validation findings and assist in drafting defect descriptions for technical teams

Track open pipeline issues through to resolution, providing status updates to the P4 lead

Support UAT activities across API, batch, Snowflake, and reporting validation scenarios

Execute test cases defined by the P4 Analyst or BA Lead — validate data movement accuracy and business rule adherence

Log defects clearly and completely in agreed defect tracking tools — including steps to reproduce, observed vs. expected results, and data evidence

Track defects through to resolution and retest fixes as required

Assist in preparing UAT summary notes and test evidence for sign-off activities

Intermediate SQL — able to write and run queries for data validation, comparison, and reconciliation (joins, filters, aggregations)

Familiarity to some expertise in API concepts (REST/JSON) — able to read and interpret payloads with guidance

Basic exposure to Snowflake or similar cloud data platforms (querying and exploring data)

Understanding of data quality concepts — completeness, accuracy, consistency, and timeliness

Comfortable using tools such as Excel, JIRA, Confluence, Postman, or Swagger for analysis and tracking tasks

Basic understanding of Master Data Management concepts — what MDM is, why golden records matter, and how data flows between systems

Awareness of how downstream systems (Snowflake, reporting tools, UI applications) consume MDM data

Exposure to Informatica Customer 360 / Reference 360 is a plus, but not required

Runs checks, logs results, flags mismatches

Root cause is unclear or impact is high

Executes reconciliation steps, documents findings

Unexplained volume differences or systemic breaks

Logs full defect detail, retests fixes

Defect is disputed or requires architectural decision

Executes test cases, logs results

Business sign-off decisions or critical failures

Writes and runs validation queries with guidance

Complex multi-system queries or performance issues

Accuracy and completeness of data validation outputs and reconciliation documentation

Quality of defect logs — clear, reproducible, and fully evidenced

Timely escalation of data issues and discrepancies to P4 leads

Reliable completion of assigned UAT test cases within sprint or release timelines

Growing confidence and independence in SQL-based validation and data analysis tasks over time

Positive feedback from Senior Leads on quality of support and documentation

Data validation, reconciliation support, and requirements documentation across MDM consumption workstreams

Interprets, documents, and validates data flows — does not build pipelines or write production code

Attention to detail + growing MDM data knowledge + structured documentation and communication

FC Global Services India LLP (First Citizens India) is an Equal Employment Opportunity Employer. We are committed to fostering an inclusive and accessible environment and prohibit all forms of discrimination on the basis of gender, religion, caste, disability, sexual orientation, economic status or any other characteristics protected by the law. We strive to foster a safe and respectful environment in which all individuals are treated with respect and dignity. Our EEO policy ensures fairness throughout the employee life cycle.