Profisee MDM Engineer
Job Description
Job role : Profisee MDM Engineer
Dallas, Texas preferred but remote can be considered
Qualifications:
• Should have 12+ years of IT experience and 6+ years of experience in MDM architecture, design, development and support with leading MDM tools
• Extensive MDM experience in Profisee MDM Tool & Purview Tool
• Should have 6+ years of experience in ETL development, support and operations with emphasis on Data quality
• Should have in depth knowledge on Bill Inmon and Ralph Kimball methodologies to design data warehouses
• Should have in depth understanding on Data Warehousing, Data Analysis, Data Profiling, Data Cataloging, Master Data Management (MDM), Data Quality, Data Lineage, Data Dictionary, Data Mapping, Data Policy and Data Governance
• Should have thorough understanding of Master Data hierarchy and implemented multi-Domain MDM for Fortune 100 organizations
• Should have done extensive Data Cataloguing using Purview Tool
• Comprehensive knowledge and experience in process improvement, normalization/de-normalization, data extraction, data cleansing and data manipulation
• Should have participated in MDM workshops with business and technology stakeholders
• Should have written complex SQL queries for data analysis and profiling
• Should have cross global location experience and been part of a team of atleast 10+ members in a global delivery model
• Should have experience in gathering business requirements by collaborating with business users, stakeholders and SMEs
• Should have experience in working with product managers, project managers, business users, applications development teams, DBA teams and Data Governance team on a daily basis to analyze requirements, design, development and deployment technical solutions
• Should have excellent communication and leadership skills
• Able to articulate ideas to both technical and non-technical stakeholders
Responsibilities:
• Participate in JAD, workshops and/or business requirements sessions to understand, identify and detail MDM requirements and key criteria
• Work with stakeholders in gathering the Match & Merge rules, develop & configure trust matrix, match path, match columns, match rules (Exact and Fuzzy) and data stewardship workflows
• Find gaps and data anomalies and review the same with stakeholders for approval and identify next steps
• Develop and execute data profiling, data quality analysis and capture results for requirement/user story sessions recommendations and plan, Data Model, Data Dictionary and Current to Future State Data Map
• Design, develop and implement architecture for MDM as enterprise solution
• Perform Data Cataloguing and analysis using Purview
• Propose and institutionalize principles of MDM data model lifecycle management that will ensure best standards for data quality management
• Engineer efforts of data quality completeness initiative
• Provide design expertise in the development of the data deliverables, including the Data Stewardship Framework, Data Cleansing recommendations including standardization and plan, Data Model, Data Dictionary and Current to Future State Data Map.
• Participate in roadmap planning, recommending technologies and solutions
• Participate and drive requirements and architecture discussions with cross-functional stakeholders
• Assist in system analysis, design, development and testing patch releases and system upgrades
• Participate in daily scrum meeting and actively participate in the Jira Teams Plan, issue reporting and assignment, Track, Report, and manage work for the MDM development
• Ensure program’s alignment to Enterprise data standards Quality, Metadata, Linkage, Reference data, Provisioning strategy etc.