Process Manager - Master Data Management (Informatica / SQL / MDM)

Silicon Valley Bank; Karnataka; On-site; INR 900,000 - 1,200,000; Full time

Job summary

Silicon Valley Bank is seeking a Process Manager - MDM Analyst to support data validation and documentation activities. This role emphasizes ensuring accurate data flow into downstream systems, evaluating data quality, and assisting with user acceptance testing.

The ideal candidate will have a Bachelor's degree in a related field and strong analytical skills, with practical experience in SQL and API concepts. Join us to enhance our MDM processes and contribute to our financial reporting integrity.

Qualifications

• Strong attention to detail; able to spot discrepancies in data across multiple systems.
• Structured thinking and ability to organize findings in written form.
• Comfortable working with large datasets.

Responsibilities

• Develop understanding of MDM golden record structures and data flows.
• Support validation across consumption data flows.
• Assist in reconciliation activities between MDM and reporting datasets.

Skills

Analytical Skills

Intermediate SQL

API concepts

Data Quality Concepts

MDM Knowledge

Education

Bachelor's degree in Business, Information Systems, Data Analytics, or related field

Tools

Excel

JIRA

Confluence

Postman

Swagger

Job description

Company Overview

FC Global Services India LLP (First Citizens India), a part of First Citizens BancShares, Inc., a top 20 U.S. financial institution, is a global capability center (GCC) based in Bengaluru. Our India-based teams benefit from the company’s over 125-year legacy of strength and stability. First Citizens India is responsible for delivering value and managing risks for our lines of business. We are particularly proud of our strong, relationship‑driven culture and our long‑term approach, which are deeply ingrained in our talented workforce. This is evident across all key areas of our operations, including Technology, Enterprise Operations, Finance, Cybersecurity, Risk Management, and Credit Administration.

Job Description

The Process Manager - MDM Analyst supports the analysis, validation, and documentation activities required to ensure that data flowing from MDM 360 (Customer 360 / Reference 360) into downstream systems is accurate, consistent, and fit for purpose. This is an analyst — not a developer — role. Rather than building pipelines or writing production code, the Junior MDM Analyst interprets data flows, documents findings, validates data quality, supports requirements gathering, and assists with UAT and reconciliation reviews across consumption and reporting workstreams. This role is an excellent entry point into MDM programme delivery, offering exposure to: MDM 360 → APIs / Batch → Snowflake → Financial Reporting → UI Consumption.

Key Responsibilities

1. MDM Data Understanding & Documentation
   • 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 elevate data anomalies or gaps in documentation identified during analysis activities.
2. Data Validation & Quality Checking
   • Support 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.
   • 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.
3. Downstream Reporting & Financial Data
   • Support validation of MDM data used in financial and regulatory reporting layers.
   • Assist in reconciliation activities between MDM golden records and Snowflake reporting datasets, including 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.
4. Requirements Support & Analysis Documentation
   • Support the P4 BA in translating business needs into clear, documented requirements: attend requirements workshops, take structured notes, and circulate agreed actions and decisions.
   • Assist in drafting user stories, acceptance criteria, and data mapping specifications under senior guidance.
   • Review and cross‑check requirements documents for completeness, consistency, and alignment with MDM data standards.
   • Maintain up‑to‑date requirements logs and traceability matrices for the consumption workstream.
   • Raise questions and clarification points with the P4 Analyst when requirements are unclear or ambiguous.
5. API & Batch Pipeline Validation Support
   • 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.
6. UAT Support & Defect Tracking
   • 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.

Requirements

• Analytical Skills
  • Strong attention to detail — able to spot discrepancies in data across multiple systems.
  • Structured thinking and ability to organise findings clearly in written form.
  • Comfortable working with large datasets and identifying patterns, gaps, or anomalies.
  • Ability to ask the right questions and elevate issues appropriately.
• Data & Technical Acumen
  • 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.
• MDM & Data Knowledge
  • 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.
• Soft Skills
  • Proactive learner — eager to build MDM and data analysis knowledge on the job.
  • Clear written communication — able to document findings, defects, and notes in a structured, readable format.
  • Reliable and organized — able to manage assigned tasks, track progress, and meet deadlines.
  • Collaborative team player — works effectively in an offshore delivery model with onsite and P4 colleagues.
  • Comfortable asking for help and working under senior guidance without needing full autonomy.

Preferred Qualifications

• Bachelor's degree in Business, Information Systems, Data Analytics, or a related field with 7-10 years experience.
• Exposure to banking or financial services data environments.
• Familiarity with Agile delivery — experience attending stand‑ups, sprint reviews, or retrospectives.
• Exposure to data reconciliation tasks in a reporting or analytics context.
• Interest in or awareness of data governance, data cataloguing, or MDM frameworks.

Key Success Measures

• 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.

Equal Employment Opportunity

Equal Employment Opportunity 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.