Informatica MDM Customer 360 Data Quality
Resume:
RAJARSHI RAY
MASTER DATA MANAGEMENT PROFESSIONAL
Informatica MDM Customer 360 Data Quality ETL & Data Integration SQL
Kolkata, India +91-801******* *******************@*****.***
Synopsys
MDM and Data Management professional with 12.5+ years of IT experience, including extensive experience in Informatica MDM, Customer 360, Reference Data Management, Data Quality, ETL, data validation, reconciliation, APIs and downstream data integration. Hands-on experience across Match & Merge, Survivorship, Golden Record creation, Crosswalk/XREF, Hierarchies & Relationships, RDM, Business Entity Services, data quality and MDM data models. Strong experience with Landing, Stage, Base Object, Crosswalk, History and Business Entity structures, using SQL for data analysis, validation and reconciliation.
CORE SKILLS
Master Data Management: Informatica MDM / Customer 360 / P360, Golden Record, Match & Merge, Survivorship, Crosswalk/XREF, Individual & Organization Matching, Fuzzy & Exact Matching, Hierarchies & Relationships, RDM, BES, MDM Data Models
Data Management & Quality: Data Quality, Data Profiling, Cleansing & Standardization, Duplicate Identification, Data Validation & Reconciliation, Source-to-Target Validation, Attribute-Level Validation, Data Mapping & Transformation Validation, Metadata, Data Lineage, Exception & Reject Analysis
ETL / Integration / Platforms: PowerCenter, IICS, Azure Data Factory, AWS S3, Snowflake, Databricks, REST APIs, JSON, Business Entity Services
Database & Analytics: Oracle SQL, SQL Server, Power BI, Tableau, SAP BusinessObjects
Testing & QA: MDM, ETL, Data Migration, API, Integration, Functional, Regression, SIT, UAT, Jira, HP ALM, Bugzilla, JMeter
PROFESSIONAL EXPERIENCE
TATA CONSULTANCY SERVICES (TCS) Assistant Consultant Jul 2022 – Present
Client: UAE / EU Banking Domain
Work extensively with Informatica Customer 360 (MDM) for enterprise customer onboarding and customer lifecycle management.
Work across Match, Merge, Unmerge, Survivorship, Golden Record creation and Crosswalk/XREF processes.
Work with Individual and Organization matching, including fuzzy and exact matching rules, Auto Merge and Manual Merge scenarios.
Work with MDM hierarchies and relationships, including parent-child relationships and cardinality rules.
Work with Reference Data Management (RDM) covering lookup values, code uniqueness, lifecycle management, localization and multilingual requirements.
Work with Business Entity Services (BES) APIs for Create, Update, Delete, Merge and Unmerge operations, including workflow approval scenarios.
Work extensively with Landing, Stage, Base Object, Crosswalk, History and Business Entity tables, using Oracle SQL for data analysis, validation and reconciliation.
Perform data quality analysis covering cleansing, standardization, duplicate identification, survivorship and rejected records.
Validate and analyze ETL/data integration pipelines involving Informatica PowerCenter, IICS, Azure Data Factory, AWS S3, Snowflake and Databricks.
Perform data validation across source, MDM and downstream systems, including record-level and attribute-level validation.
Perform reporting and downstream data validation using Power BI and Tableau.
Perform data profiling, metadata validation and data lineage analysis using Informatica IDQ, Axon and EDC.
Work with ActiveVOS workflows, including workflow approvals, task management, email notifications and role-based access controls.
Investigate data discrepancies and exceptions by tracing records across MDM layers and downstream systems.
Design and execute MDM, ETL, integration and data validation scenarios; support SIT, regression and UAT activities.
CAPGEMINI CONSULTING INDIA Manager Apr 2019 – Jun 2022
Clients: MIC / CIMB Bank / Healthcare – USA
Worked on Informatica Customer 360 for customer master data validation and MDM processes.
Worked with Match & Merge functionality, including fuzzy and exact matching rules.
Performed validation of customer master data and analyzed data consistency across MDM processes.
Collaborated with development teams on Stage and Base Object mappings and transformation requirements.
Analyzed MDM data and validated expected results against business requirements.
Performed reporting and data validation using Tableau Server.
Supported defect analysis, resolution validation and stakeholder communication across MDM delivery activities.
Received the “Extra Mile” Award – Q3 2021.
MICROGREEN TECHNOLOGIES PVT. LTD. Senior QA Engineer Nov 2018 – Apr 2019
Client: Kelly Services
Created MDM test plans and coordinated MDM testing activities.
Validated data transformations, Match & Merge rules and ETL processes.
Worked with MDM data validation and investigated discrepancies across source and target data.
ARC DOCUMENT SOLUTION PVT. LTD., KOLKATA QA Engineer Feb 2017 – Oct 2018
Analyzed business and system requirements from SRS documents.
Prepared and executed detailed test scenarios and test cases.
Performed functional and regression testing.
Logged, analyzed and tracked defects using Bugzilla.
INTERRA IT PVT. LTD., KOLKATA Member of Technical Staff – L5 Jun 2015 – Jan 2017
Worked on the M-Junction MDM project.
Performed Roll-up and Roll-down testing for MDM-related functionality.
Logged and tracked defects and supported defect resolution activities.
Prepared user manuals and project documentation.
Performed basic performance/load testing using JMeter.
IT ORBITAL, KOLKATA IT Coordinator Nov 2012 – Apr 2015
Monitored application and server environments and supported system availability.
Provided database and technical support to project users.
Conducted training sessions for municipal users.
Worked on SUDA and E-District projects covering Mizoram and Daman & Diu.
EDUCATION
B.Tech – Information Technology Techno India, Kolkata / WBUT 2011 CGPA: 6.91
Diploma – Information Technology SMIT, Guptipara, Hooghly 2008 69%
Class X – Patha Bhavan, Dankuni WBBSE 2005 53.75%
CERTIFICATIONS
Informatica MDM SaaS – Foundation Level
Informatica MDM SaaS – Intermediate Level
ISTQB Foundation & Analyst Level
AWARDS & RECOGNITION
Rockstar of the Month – Interra IT
Best Team Award – Interra IT
Extra Mile Award – Capgemini, 2021
Multiple GEMS & Client Appreciation Awards – TCS
Contact this candidate