Our client in Columbus, Ohio has a contract-to-hire opening for an MDM Engineer who will be mostly remote but would need to be available to come in for meetings in Columbus office. The MDM Engineer role will focus on the expansion of the client's Master Data Management capabilities. This role is deeply technical requiring a thorough understanding of data integration between multiple systems in real-time and batch scenarios. This role will collaborate with MDM Lead and Portfolio Architects to implement a robust, scalable, and secure architecture for bi-directional data movement to/from the toolsets.
95%: OPERATIONS Enhance and expand usage of Master Data Management toolset spanning multiple domains such as Patient, Provider, and Location, etc. Partner with MDM Lead and Users to customize out-of-the-box “Accelerator” MDM Data Models to fit business needs. Provide technical guidance to users of the MDM system such as Data Stewards, Business Users, etc. Configure business rules, match rules, survivorship rules, etc. within the MDM application based on business requirements. Ensure accuracy of mastered records. Develop integration components to ingest data from multiple source applications and deliver/push data to consuming applications. Leverage out-of-the-box APIs and build custom APIs to support bi-directional data movement from MDM applications for both real-time and batch scenarios. Develop into a technical SME and Administrator for Informatica Multi-Domain MDM. Design solutions that support data auditability, data masking, risk mitigation, regulatory compliance, role-based access, etc. Ensure data management & governance policies, processes, and standards are followed. Produce relevant documentation that contains data flow diagrams, technical decisions, and production support guidance. On-call support, change management, incident resolution including working with vendor global support and customer success managers.
7+ years of overall IT experience focused on Data Management with experience in Master Data Management toolsets and business processes. 3+ years of technical SME and development experience in Informatica MDM Hands-on experience with a Data Integration tool, preferably Informatica Intelligent Cloud Services or other Enterprise iPaaS tools. Hands-on experience in using Data Quality tools & Address Cleansing services. Development experience with Informatica Data Director, Active VOS, Services Integration Framework 7+ years of experience working with a wide variety of relational and non-relational data stores. Strong ANSI SQL experience and ability to write stored procedures and user-defined functions Good architectural understanding of middleware systems and various integration patterns. Experience working with structured, semi-structured, and unstructured data in a multi-terabyte environment Exposure to cloud-native architectures, product deployment on public cloud, and various batch and real-time/streaming integration patterns. Exposure to BI, Visualization, and Statistical tools and their data needs Experience working in an Agile environment
Familiarity with Data Lake concepts, ETL Automation Techniques, Data Cataloging, AI/ML usage in Analytics. Experience with Informatica Axon & Enterprise Data Catalog Experience with MS SQL Server, Azure SQL DB / Managed Instance, Azure Synapse, Snowflake Experience developing new & secure APIs for bi-directional data movement Experience in Healthcare Industry Experience in Data Modeling (Normalized, Star / Snowflake Schema, Data Vault)