MDM Data Engineer

MDM Data EngineerLocation: Buffalo, NY – OnsiteEssential Technical Competencies:Informatica MDM, Informatica Power Center, IDQ and SQLOverall, 6-8 years of experience in design, build and configure applications to meet business process and application requirements.Must have development experience of at least 2 projects with around 4-5 years of relevant experience in Informatica MDMShould have knowledge around Batch Load and Real Time APIs to/from MDMAbility to carry out Match Tuning/Match Performance etc.Customization and Configurations on Data Model/Hub Console/IDDAbility to convert business requirements and provide estimatesIntegration across enterprise systems in terms of sourcing data and publishing MDM ViewsExperience in creating source systems and configuring the trust settings in MDM.Experience in creating the mapping and used various cleanse function.Experience in configuring Match/Merge settings.Experience in writing the SQL to load data into the landing table and defining the process to load staging tables and then corresponding base Objects.Experience in creating Queries and packages.Experience in modifying the repository according to business needs.Creating import and export templates.Good to have skillset of Data Quality and external Data enrichment services.