• Overall 9.5 years of experience in the field of IT Industry in Talend, Informatica MDM, Informatica Power Center ,IDQ, Customer 360, SQL Server, Oracle, Tableau and UNIX Shell Scripting
• Out of 9.5 Years I have 3.5 Years’ experience on MDM, IDQ, Provisioning Tool, Customer 360, SQL.
• Experience in SDLC(agile & waterfall) including design, implementation, testing, and maintenance and production support of Data Warehouse systems.
• Entity relation modelling, design techniques and data modeling using Star/Snowflake Schema Design, Fact and Dimensional tables.
• Strong experience in Installing and Configuring of various Infa MDM components
• Data modeling, data mappings, data validations, data standardization, defining business rules for cleansing, matching, merging and maintaining data.
• Created and Configured Landing tables, Staging Tables, Base Objects, Hierarchies, Foreign Key Relationships, Lookups in the Hub, Queries, Query Groups and Packages in MDM.
• Experienced with hierarchy manager to develop hierarchies as per the business needs.
• Created IDD application as per the business needs by creating the subject area and subject area groups and used Merge Manager and Data Manager for Managing Data.
• Worked on Repository manager for validation, promotion, importing and exporting the ORS repositories to Dev, QA and Prod environments.
• Hands on experience in Infa MDM Hub Match and Merge Rules, Batch Jobs and Batch groups and Data Validation and Data cleaning using User Exits in MDM Hub and in IDD.
• Extensive experience in design and creation of ETL mappings and Transformations using Informatica to move data from multiple sources into target using transformations like Source Qualifiers, Expressions, Aggregator, Lookups, Filters, Routers, Joiners etc.
• Extensively created mapplets, common functions, reusable transformations, look-ups for better usability and involved in Optimization and Tuning of mappings and sessions in Informatica by identifying and eliminating bottlenecks, memory management and parallel threading.
• Communicate effectively with stakeholders to identify needs and evaluate alternative business solutions