MDM ETL Expert / Technical Lead

For over twenty-seven years RCR Technology Corporation has delivered the highest quality services to our clients with an expansive portfolio of industry-relevant services, and deep technical capabilities around data management and application development.

We are seeking an experienced MDM ETL Expert / Technical Lead to provide technical leadership and hands-on delivery for Master Data Management services supporting the Health and Human Services Innovation Incubator (HHSi2) project led by the Illinois Department of Healthcare and Family Services (HFS). This role will focus on Informatica MDM, Informatica PowerCenter, data integration, data quality, data governance, and analysis capabilities that support a unified cross-agency client/member view across State programs, as well as individual statewide MDM use cases.

The selected candidate will lead MDM technical delivery, guide MDM/ETL specialists and developers, support Informatica workflows and data loads, develop and optimize SQL and Python-enabled automation where appropriate, troubleshoot production issues, support QA/testing, and help maintain reliable MDM operations.

• · Own MDM technical solution delivery, including review of technical documentation to design MDM solutions that meet business needs.
• · Design MDM solution with security by design and privacy by design and align with the Chief Information Security Office (CISO) guidelines.
• · Provide leadership and coordinate or lead work for Informatica Master Data Management and related MDM ETL delivery activities.
• · Use Informatica MDM tool to combine source data from agency sources, applying numerous transformations to the data that are required, applying corrections to the source files, and adding new fields via the change request process.
• · Provide project direction and assign work to MDM ETL Specialists.
• · Ability to provide expertise and guidance with MDM and the Informatica MDM tool.
• · Automate the staging of data by scheduling scripts to run at optimal times, enhancing overall system performance and efficiency.
• · Implement MDM jobs by creating mappings, mapplets, sessions, and workflows.
• · Work with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter.
• · Schedule and monitoring ETL/Informatica jobs in development, system testing, and production environment.
• · Document workflows and technical specifications.
• · Develop proactive processes for monitoring capacity and performance tuning.
• · Support and advise the development teams on technical issues.
• · Troubleshoot production support issues post-release deployment and produce solutions.
• · Troubleshoot server or software issues in coordination with State IT department
• · Develop, maintain, and analyze complex SQL queries and scripts used to create data marts in Teradata.
• · Work directly with the Quality Assurance and business team to support validation, defect resolution, and testing of MDM-related data processes.
• · Participate in project discussions to document and recommend alternative technical solutions or requirements.
• · Participate in unit, integration, and system testing.
• · Maintain effective communication and relationships with all individuals involved with the project.
• · Learn new technologies as needed to be able to perform job duties effectively.
• · Provide status updates and meet deliverables to Optum’s leadership and the State Project Managers.
• · Use other software tools such as Python as necessary to enhance MDM and data integration.