MDM ETL Expert Technical Lead

Clover Consulting has a direct client in Springfield, IL in need of an MDM ETL Expert/Technical Lead for a 12+ months contract. Job details are below. Qualified candidates please provide resume. Thank you!
Role: MDM ETL Expert/Technical Lead
Location: Remote - occasional travel to Illinois possible
Term: 12+ months contract, extensions possible
Rate: $60 W2 - $72 C2C
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 Power Center, 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.

• Partner with the MDM Statewide initiative supporting and combining different agency data sources.
• Integrate State agency data to create a holistic view of the clients that the State serves and to administer all State agency programs more effectively and efficiently.
• Provide advanced analytics, data quality analysis, business/data analysis, and MDM data specialists in support of the Illinois Health and Human Services Incubator (HHSi2) project.
• Partner with the State to develop custom dashboards using data as part of the HHSi2 project.
• Provide technical expertise using Informatica MDM and related integration tools to support MDM data processing, data quality, and downstream system(s) needs.
• Support data quality strategy while allowing for data quality analysis and other data governance activities.
• Maintain data quality by using timely and consistent processes and evaluating data quality with the State.
• Leverage established data governance practices and work with State staff and other vendors/partners to improve and validate data consistency and integrity.
• Provide a structure to support business and data analysis using industry standard practices.
• Data analysis to support policy development and program evaluation.
• Identify opportunities/use-cases that help translate data analysis into cost savings and improved outcomes in programs and service areas

• 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…