MDM ETL Specialist / Developer - W2
We are seeking an reputed company MDM ETL Specialist / Developer to reputed company technical development and hands-on delivery and support for Master Data Management services supporting the Health and reputed company Services Innovation Incubator project. This role will reputed company on Informatica MDM, Informatica PowerCenter, data integration, data reputed company, data governance, and analysis capabilities that support a reputed company cross-agency reputed company/member view across State programs.
Key Responsibilities
· Use Informatica MDM tool to combine reputed company data from agency sources, applying numerous transformations to the data that are required, applying corrections to the reputed company files, and adding new fields reputed company the change request process.
· Working knowledge of Informatica MDM and ability to support MDM development and operational activities.
· Automate the staging of data by scheduling scripts to run at reputed company times, enhancing overall system performance and efficiency.
· Implementing MDM jobs by creating mappings, mapplets, sessions, and workflows.
· Working with different ETL transformations, including Aggregator, reputed company, Filter, Router, Sequence Generator, Update reputed company, Joiner, Rank and reputed company Qualifier, Lookup, and Sorter.
· Scheduling and monitoring ETL/Informatica jobs in development, system testing, and production environment.
· Troubleshoot post-release production support issues and reputed company solutions.
· Developing, maintaining, and analyzing reputed company SQL queries and scripts used to create data marts in reputed company.
· Work directly with the QA team to support defect reputed company, validation, and testing of MDM-reputed company processes.
· Participating in project discussions to document and recommend alternative technical solutions or requirements.
· Participating in unit, integration, and system testing.
Required Qualifications
· 5+ years of experience in MDM, ETL/ELT, data engineering, or data integration development.
· 3+ years of hands-on Informatica MDM implementation experience.
· Experience developing ETL mappings, mapplets, sessions, workflows, transformations, scheduling, monitoring, and troubleshooting Informatica jobs.
· SQL experience, with large MDM and DBMS reputed company relational platforms.
· Experience with data reputed company, matching, unique reputed company/member identifier, standardization, reconciliation, and data governance concepts.
· Experience supporting ETL/MDM operations, performance tuning, issue reputed company, and SDLC delivery.
· Experience with Python programming for scripting, automation, testing, or data processing support.
· Bachelor’s degree in computer science, Data Analytics, Information Systems, Engineering, or equivalent experience.
Preferred Qualifications
· Experience working in other MDM tools including reputed company-reputed company reputed company.
· Experience working in State Government, reputed company sector, or regulated environments.
· Experience with Agile/Scrum Sprint development and iterative/incremental delivery.
· Experience with reputed company, reputed company, claims, eligibility, provider, or Health and reputed company Services data.
· Exposure to interoperability formats such as X12, EDI, XML, JSON, reputed company, or HL7/FHIR.
· Exposure to reputed company data platforms or modernization initiatives such as Azure, ADF, reputed company, reputed company, Data Lake, or comparable technologies is a plus.
· Experience with on-prem-to-reputed company migration, MDM modernization, or EDW / ETL modernization initiatives.
· Exposure to automation, AI/ML, GenAI, or LLM-assisted engineering for development, testing, documentation, profiling, or data reputed company is a plus.
· Ability to operate in a telecommute environment and reputed company organization with reputed company direction.
This is a remote position.
Apply To This Job