| Data Architect (hybrid) with Informatica MDM experience required for this role at Remote, Remote, USA |
| Email: [email protected] |
| From: Gaurav Gaur, DMS VISIONS INC [email protected] Reply to: [email protected] Hi, Hope you are doing well, Please find the job description given below and let me know your interest. Position: Data Architect (hybrid) with Informatica MDM experience required for this role Location: RELOCATION IS FINE. Hybrid Location - 50% onsite in Albany, NY (Must work 5 out of every 10 business days onsite) Duration:6+ Month Job description: Qualifications: 7+ years of experience working on complex projects with 2 or more years in a leadership role as an Architect 10+years of hands-on professional experience as an Architect in multiple Master Data Management (MDM) projects architecting, planning, designing, developing, implementing, testing, and integrating successful MDM solutions including data cleansing, data ingestion pipelines, matching, merging, deduplication, hierarchy management, standardization, automation, and orchestration of enterprise Master and Reference data such as Clients and Providers data to create the single version of the truth (e.g., golden record) and to create a Common Client Index (CCI) and a Master Provider Index (MPI) to support applications and data sharing in batch and real-time modes. 10+ years of hands-on professional experience using Informatica Master Data Management (MDM) Hub to build data models and configure rules to implement MDM solutions. This includes but not limited to Informatica MDM architecture, MDM Hub Workbenches, Informatica Data Director, Provisioning Tool, ActiveVOS, Customer 360, Informatica Master Database, Operational Reference Store (ORS) Database, Services Integration Framework (SIF), Queries Tool, Packages Tool, BPM workflow, Data Encryption, Hierarchy Manager, Mappings tool, audit trail, delta detection, message queues tool, JMS messages, and Batch Jobs. Desirable Qualifications: 10+ years of hands-on professional experience building landing tables, staging tables, and base objects to develop a comprehensive master data model such as the party data model, client/customer data model, or provider/vendor data model in Informatica MDM Hub to support MDM solutions. This includes but not limited to designing, developing, and implementing entity relational diagrams, conceptual, logical, and physical relational data models. 10+ or more years of hands-on professional experience creating data profiling rules, data cleansing rules, data match rules (exact match, fuzzy match), merge options, auto-merge rules, manual merge rules, un-merge rules, validation rules, and trust rules in Informatica MDM and Informatica Data Quality products. 7+ years of hands-on professional experience in Informatica MDM Hub load process, landing process, staging process, consolidate process, exception handling process, and publishing process. 7+ years of hands-on professional experience in designing, developing, and maintaining integrations between Informatica MDM solutions and other systems using APIs, web services, message queues, Java Message Service (JMS), ESB, Kafka, and ETL tools. 7+ years of hands-on professional experience using tools such as Informatica PowerCenter or Informatica Data Quality to export, transform and load data from source databases (e.g., Oracle) and flat files into the Informatica MDM landing tables. 7+ years of hands-on professional experience integrating Informatica MDM solutions with medium to large scale, high volume OLTP and OLAP systems such as Case Management systems, Enrollment and Eligibility systems, Financial Management systems, Child Support systems, Court Hearings systems, or similar systems. 5+ years of hands-on experience using data modeling software (e.g., Erwin Data Modeler) and developing complex SQL queries, Oracle PL/SQL packages, stored procedures, functions, views, complex joins, indexes, triggers, external tables, roles, grants, permissions, DDL, and DML. 7+ years of hands-on professional experience in data analysis, metadata cataloging, creating, and maintaining documentation including technical specifications, data mappings, data dictionary, data lineage, data flow diagrams, and high-level and low-level design. Domain knowledge and experience in health and human services, especially in Integrated Eligibility System programs such as PA, TA, SNAP, HEAP, TANF, etc. Knowledge and experience in applying data management concepts such as data architecture, data quality, metadata management, Data Warehousing and Business Intelligence, data integrity, data integration and interoperability, data governance, data security, data storage and operations If you are interested, please share your updated resume and suggest the best number & time to connect with you. Thanks & Regards, Gaurav Gaur [email protected] 972-645-9280 Keywords: procedural language New York Pennsylvania |
| [email protected] View all |
| Tue Mar 12 23:12:00 UTC 2024 |