> Markdown version of [/jobs/ext/1919447-mdm-etl-specialist-developer-w2](https://www.wearedevelopers.com/jobs/ext/1919447-mdm-etl-specialist-developer-w2). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # MDM ETL Specialist / Developer - W2 - **Company:** CLOUDSCOUTS SOFTWARE SOLUTIONS LLC - **Location:** United States (Remote available) - **Experience:** Experienced - **Contract:** Permanent contract - **Skills:** Application Programming Interfaces (APIs), Artificial Intelligence, Microsoft Azure, Cloud Engineering, Information Systems, Databases, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Data Mart, Data Warehousing, Electronic Data Interchange (EDI), JSON, Python (Programming Language), Performance Tuning, Scrum Methodology, Systems Development Life Cycle, Cloud Services, SQL Databases, System Testing, Teradata SQL, Extensible Markup Language (XML), Network Routers, Data Processing, Scripting, Freeform SQL, Informatica Powercenter, Fast Healthcare Interoperability Resources, Large Language Models, Snowflake, Data Lakes, Information Technology, Data Analytics, Health Level Seven International, SAP MDG, Data Management, Databricks - **Published:** August 4, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=9e6dc19469885f2c ## About the Role * 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 enterprise relational platforms. * Experience with data quality, matching, unique client/member identifier, standardization, reconciliation, and data governance concepts. * Experience supporting ETL/MDM operations, performance tuning, issue resolution, 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 Cloud-native MDM solutions. * Experience working in State Government, public sector, or regulated environments. * Experience with Agile/Scrum Sprint development and iterative/incremental delivery. * Experience with healthcare, Medicaid, claims, eligibility, provider, or Health and Human Services data. * Exposure to interoperability formats such as X12, EDI, XML, JSON, APIs, or HL7/FHIR. * Exposure to cloud data platforms or modernization initiatives such as Azure, ADF, Databricks, Snowflake, Data Lake, or comparable technologies is a plus. * Experience with on-prem-to-cloud 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 quality is a plus. * Ability to operate in a telecommute environment and matrix organization with minimal direction. ## Description We are seeking an experienced MDM ETL Specialist / Developer to provide technical development and hands-on delivery and support for Master Data Management services supporting the Health and Human Services Innovation Incubator project. 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., * 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. * 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 optimal times, enhancing overall system performance and efficiency. * Implementing MDM jobs by creating mappings, mapplets, sessions, and workflows. * Working with different ETL transformations, including Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Joiner, Rank and Source Qualifier, Lookup, and Sorter. * Scheduling and monitoring ETL/Informatica jobs in development, system testing, and production environment. * Troubleshoot post-release production support issues and develop solutions. * Developing, maintaining, and analyzing complex SQL queries and scripts used to create data marts in Teradata. * Work directly with the QA team to support defect resolution, validation, and testing of MDM-related processes. * Participating in project discussions to document and recommend alternative technical solutions or requirements. ## Related Videos - [Tips and Tricks for Working with JSON](https://www.wearedevelopers.com/videos/1229-tips-and-tricks-for-working-with-json) - [How Cisco embraced a DevOps culture within its network engineering team](https://www.wearedevelopers.com/videos/99-how-cisco-embraced-a-devops-culture-within-its-network-engineering-team) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Blueprints for Success: Steering a Global Data & AI Architecture](https://www.wearedevelopers.com/videos/1577-blueprints-for-success-steering-a-global-data-ai-architecture) - [From Messy Queries to Scalable Systems - How Data Engineering actually works](https://www.wearedevelopers.com/videos/100203-from-messy-queries-to-scalable-systems-how-data-engineering-actually-works) - [Introducing JSON Structure](https://www.wearedevelopers.com/videos/100219-introducing-json-structure) ## Related Articles - [What Are The Top Skills Required For Azure Developers?](https://www.wearedevelopers.com/magazine/77-what-are-the-top-skills-required-for-azure-developers) - [Dev Digest 162: AI careers, MCP, AWS best practices & floppy sweaters](https://www.wearedevelopers.com/magazine/571-dev-digest-162-ai-careers-mcp-aws-best-practices-floppy-sweaters) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [The Most Popular IT Jobs on the Market](https://www.wearedevelopers.com/magazine/376-the-most-popular-it-jobs-on-the-market) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers)