Himanshu Shandilya

Business Technology Consultant @ZS

Diverse professional IT experience in analysis, design, development, and implementing software solutions in Data Management tools like Informatica Master Data Management ( MDM ), IDD, E360, Informatica PowerCenter, Informatica Data Quality, PowerConnect, Alteryx for Investment Pharmaceutical and Healthcare industry • Extensive experience in Databases like Oracle 10g/9i/8i, Teradata V2R5/V2R3, Teradata Tool & Utilities (FastLoad, MultiLoad, Tpump), MS SQL Server, MS Access XML, SQL, PL/SQL, TSQL, SQL*Plus on UNIX & Windows environments. • Installation/Configuration of Informatica MDM Hub Console, Hub Server(Master Reference Manager, HM, AM), Cleanse Match Server, Cleanse Adaptor, IDD (Informatica Data Director) and SIF(Services Integration Framework) • Using Informatica Product Availability Matrix( PAM) for identifying Proper software for MDM. Participated in requirement gathering and preparation of High level and Low-level Designs throughout the Software Development Life Cycle. • Detailed data analysis, Data Profiling and Developed a good understanding of each source and how the business purpose of the source aligns with the purpose of the Hub. • Data modeling & Data Mappings, Data Validations, Data Standardization, Defining business rules for Cleansing, Matching, Merging and Maintaining data. • Helped business to understand the Match rules configuration and match/merge rules. Defined the Match and Merge Rules in the MDM Hub by creating Match Path components, Match Strategy, Population and Match columns and rules. Fine-tuning the match rules. • Helped business to MDM BE APIs to search before create and get functionality