Drag

PROFILE SUMMARY

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

  1. Analyzed supplier and customer data using IDMC (IICS) and performed data profiling on Oracle CFIN flat files.
  2. Built data quality rules, scorecards, and implemented a data governance process.
  3. Created mapping documents, designed business entities (Supplier & Customer 360), and enhanced data models.
  4. Designed match-merge rules, developed validation and cleansing rules, and configured address verification.
  5. Built mappings, workflows, scheduled jobs, and prepared deployment runbooks.
  6. Monitored data loads, fixed product issues, worked with Informatica support, and optimized performance.

Informatica MDM Consultant

PwC | Jun  2021 - Jan 2023

  1. Developed an MDM upgrade strategy across multiple environments (Sandbox to PROD) and performed pre-requisite checks.
  2. Upgraded MDM Hub Store, Cleanse Server, and IDD applications from 10.2 to 10.4, resolving upgrade-related issues.
  3. Configured SSL, LDAP authentication, and updated cmxserver properties for improved entity and data views.
  4. Supported real-time integration testing, external matching, and data analysis for new source systems.
  5. Managed deployment of Informatica MDM, Java code, and addressed ongoing issues in Consolidated MDM (PMDM).
  6. Created upgrade documentation, handled hotfixes, and collaborated with Informatica support for issue resolution.

Informatica Consultant

Multiple Projects | Feb  2017 - Present

  1. Installed and configured Informatica MDM 9.7.1 on Red Hat Linux with WebLogic, set up Cleanse Server, and validated installations across environments.
  2. Installed Informatica Data Quality (IDQ), performed pre-requisite validation, created schemas, and configured Address Doctor for address cleansing.
  3. Developed an MDM upgrade strategy, upgraded from 9.7 to 10.1 HF5, performed sanity testing, and fine-tuned Match and Merge rules.
  4. Profiled source system data using Informatica Developer Tool and IDQ to identify data quality anomalies and column profiling.
  5. Upgraded Informatica Power Center and Data Quality, backed up and restored repositories, and configured application services and security.
  6. Created and implemented data quality standardization, cleansing rules, scorecards, and address validation using Address Doctor.
  7. Translated business requirements into technical documentation, used various transformations, and identified key attributes for metadata scanning.
  8. Managed CCPA project, creating a comprehensive data asset view, enriching business context, and establishing 360-degree data relationships.
  9. Configured Informatica Administrator, created users, roles, reusable schedules, and custom attributes in Catalog Administrator for data profiling.
  10. Conducted impact analysis with lineage diagrams, enabled transformation logic, and analyzed data structure frequency in multiple environments.

Swathi - 7 years of experience as SaaS Developer

Swathi

SaaS Developer

Experience: 7 Years

TECHNICAL SKILLS

SaaS  MDM SaaS S360  Data Profiling  SQL/PL SQL HTML  AWS Azure  Informatica MDM

EDUCATION

Bachelors in Engineering (JNTU, Telangana, India) - 2013

CERTIFICATIONS

  • MDM SaaS Foundation Level
  • Data Quality 9.x Developer Specialist
  • MDM Developer