PROFILE SUMMARY
Over 7 years of experience in Master Data Management (MDM), Data Integration, and Data Quality. Proficient in IDMC, Informatica MDM, IDQ, and cloud platforms such as AWS and Azure. Specialized in data profiling, cleansing, integration, security, and API development.
PROFESSIONAL EXPERIENCE
INFA MDM SaaS Developer
Giant Eagle | Feb 2023 - Present- Conducted analysis of supplier and customer data utilizing IDMC (IICS), performing data profiling on Oracle CFIN flat files.
- Developed data quality rules and scorecards, and established a comprehensive data governance framework.
- Drafted mapping documents, designed business entities (such as Supplier & Customer 360), and improved data models.
- Formulated match-merge rules, created validation and cleansing protocols, and configured address verification processes.
- Designed mappings, workflows, and scheduled tasks, while also preparing deployment runbooks.
- Monitored and managed data loads, resolved product-related issues, collaborated with Informatica support, and fine-tuned system performance.
Informatica MDM Consultant
PwC | Jun 2021 - Jan 2023- Developed a comprehensive MDM upgrade strategy spanning multiple environments (from Sandbox to Production) and conducted essential pre-upgrade checks.
- Executed the upgrade of MDM Hub Store, Cleanse Server, and IDD applications from version 10.2 to 10.4, resolving any upgrade-related challenges.
- Configured SSL, LDAP authentication, and adjusted cmxserver settings to enhance entity and data visibility.
- Provided support for real-time integration testing, external matching, and data analysis for newly integrated source systems.
- Managed the deployment of Informatica MDM, Java code, and resolved ongoing issues within the Consolidated MDM (PMDM) environment.
- Documented the upgrade process, applied hotfixes as necessary, and collaborated with Informatica support to troubleshoot and resolve issues.
Informatica Consultant
Multiple Projects | Feb 2017 - May 2021- Installed and configured Informatica MDM 9.7.1 on Red Hat Linux with WebLogic, set up Cleanse Server, and verified successful installations across multiple environments.
- Deployed Informatica Data Quality (IDQ), conducted pre-requisite validation, created necessary schemas, and configured Address Doctor for address data cleansing.
- Developed an MDM upgrade strategy, managed the upgrade from 9.7 to 10.1 HF5, performed sanity checks, and optimized Match and Merge rules.
- Used Informatica Developer Tool and IDQ to profile source system data, identifying data quality issues and performing column-level profiling.
- Upgraded Informatica PowerCenter and Data Quality, ensured repository backups and restorations, and configured application services and security settings.
- Created and implemented data quality standards, including cleansing rules, scorecards, and address validation via Address Doctor.
- Translated business requirements into detailed technical documentation, applied various transformations, and identified key metadata attributes for scanning.
- Led the CCPA project by building a comprehensive data asset inventory, enriching business context, and establishing 360-degree data relationships.
- Configured Informatica Administrator, created users and roles, and set up reusable schedules and custom attributes in Catalog Administrator for effective data profiling.
- Conducted impact assessments with lineage diagrams, enabled transformation logic, and analyzed data structure frequency across different environments.
Swathisri
MDM SaaS Developer
Experience: 7 Years
TECHNICAL SKILLS
SaaS MDM SaaS S360 Data Profiling SQL/PL SQL HTML AWS Azure Informatica MDMEDUCATION
Bachelors in Engineering (JNTU) - 2013
CERTIFICATIONS
- MDM SaaS Foundation Level
- Data Quality 9.x Developer Specialist
- MDM Developer
- Informatica Data Quality Training
