7+ years of experience in MDM, Data Integration, and Data Quality. Expertise in IDMC, Informatica MDM, IDQ, cloud platforms (AWS, Azure), data profiling, cleansing, integration, security, and API development.
PROFESSIONAL EXPERIENCE
SaaS Developer
Giant Eagle | Feb 2023 - Present
Analyzed supplier and customer data using IDMC (IICS) and performed data profiling on Oracle CFIN flat files.
Built data quality rules, scorecards, and implemented a data governance process.
Created mapping documents, designed business entities (Supplier & Customer 360), and enhanced data models.
Designed match-merge rules, developed validation and cleansing rules, and configured address verification.
Built mappings, workflows, scheduled jobs, and prepared deployment runbooks.
Monitored data loads, fixed product issues, worked with Informatica support, and optimized performance.
Informatica MDM Consultant
PwC | Jun 2021 - Jan 2023
Developed an MDM upgrade strategy across multiple environments (Sandbox to PROD) and performed pre-requisite checks.
Upgraded MDM Hub Store, Cleanse Server, and IDD applications from 10.2 to 10.4, resolving upgrade-related issues.
Configured SSL, LDAP authentication, and updated cmxserver properties for improved entity and data views.
Supported real-time integration testing, external matching, and data analysis for new source systems.
Managed deployment of Informatica MDM, Java code, and addressed ongoing issues in Consolidated MDM (PMDM).
Created upgrade documentation, handled hotfixes, and collaborated with Informatica support for issue resolution.
Informatica Consultant
Multiple Projects | Feb 2017 - Present
Installed and configured Informatica MDM 9.7.1 on Red Hat Linux with WebLogic, set up Cleanse Server, and validated installations across environments.
Installed Informatica Data Quality (IDQ), performed pre-requisite validation, created schemas, and configured Address Doctor for address cleansing.
Developed an MDM upgrade strategy, upgraded from 9.7 to 10.1 HF5, performed sanity testing, and fine-tuned Match and Merge rules.
Profiled source system data using Informatica Developer Tool and IDQ to identify data quality anomalies and column profiling.
Upgraded Informatica Power Center and Data Quality, backed up and restored repositories, and configured application services and security.
Created and implemented data quality standardization, cleansing rules, scorecards, and address validation using Address Doctor.
Translated business requirements into technical documentation, used various transformations, and identified key attributes for metadata scanning.
Managed CCPA project, creating a comprehensive data asset view, enriching business context, and establishing 360-degree data relationships.
Configured Informatica Administrator, created users, roles, reusable schedules, and custom attributes in Catalog Administrator for data profiling.
Conducted impact analysis with lineage diagrams, enabled transformation logic, and analyzed data structure frequency in multiple environments.