Consultant - MDM IDQ Developer

Job Description

Role Summary: Drive the end-to-end solution architecture of MDM solutions including data model definition and refinement, data quality assessment and remediation design, data migration strategy, data stewardship process and system interaction design. Understand the technical landscape current as well as desired future state Assess the current state architecture & understand current business processes for managing Master Data Management solutions. Provide subject matter expertise on data architecture and data integration implementations across various downstream system. Extensive hands-on experience in configurations of core Informatica MDM Hub components such as Hub console, Hub Store, Hub Server, Cleanse/Match Server and Cleanse Adaptor. Ability to deliver full lifecycle MDM projects for clients including Data modeling, Metadata management, design and configuration of matching and merging rules, design and configuration of standardizing, cleansing and deduplication rules. Ability to design E360 UI with Business Entity framework Ability to fine-tune and optimize MDM Hub performance Hands-on experience with ActiveVOS, Informatica MDM Service Integration Framework (SIF) and Informatica Business Entity Services (BES) Will also be involved in integration/transfer of data across multiple systems, streamlining data processes and providing access to MDM data across the enterprise. Create Design Document and data models addressing business needs for the MDM environment - Contribute to creating reusable assets and accelerators for MDM platforms. Coordinate with Project Managers and participate in project planning and recurring meet. Development efficient & highly tuned data cleansing routines Should be able to use all IDQ transformations including Address Doctors Understands IDQ architecture and performance techniques with industry standard coding practices Should be able to works with exposing data quality rules as webservices and consumed data from third party rest APIs Should be able to work with managed and unmanaged reference table Understands the code deployment & knows to automate it Informatica Analyst Used by Business/ Data analyst & data stewards to profile data, define rule specification and manage business glossary Build profile on heterogenous data sources Basic profiling, join data profiling Build scorecards Build reference tables Build mapping and rule specifications Build and manage Reference data though reference tables Develop efficient & highly tuned data transformation mappings Build, execute/schedule mapping tasks and task flows Performance tuning through lookup and other coding best practices Rest API consumptions