MDM ETL Developer at 

Category: Data & Analytics, Developer/Engineer, IT
Location: Austin, Texas

PMCS Services is an Austin based company and Prime vendor to State of Texas DIR IT staffing. We have a contracting opportunity with one of our client at Austin, TX


The Department of Information Resources (DIR) requires the services of one Programmer/Developer, hereafter referred to as Worker(s), who meets the general qualifications of ITSAC Programmer/Developer 3 Category, Emerging Technology Type and the specifications outlined in this document for the Texas Health and Human Services Commission (HHSC).

All work products resulting from the project shall be considered “works made for hire” and are the property of the HHSC.  HHSC may include pre-selection requirements that potential Vendors (and their Workers) submit to and satisfy criminal background checks as authorized by the Texas law. HHSC will pay no fees for interviews or discussions, which occur during the process of selecting a Worker(s).

The Master Data Management (MDM) Developer designs and implements master data solutions for a multi-terabyte MDM implementation, in support of the Health and Human Services Commission (HHSC) Center for Analytics and Decision Support’s, Enterprise Information Management (ElM) team.

The Business Data Analyst position will report to the Director of the System Information and Asset Management team. This team is a part of the Health and Human Services Commission (HHSC) Information Technology team. This team helps improve data quality and supports data analytics. The objective of this team is to ensure Health and Human Services (HHS) data is accessible and trusted by business users to support data-driven decisions. The team also partners with key business areas to execute a roadmap of defined business value propositions.

This MDM Developer role will help implement additional HHS Master Data for use in analytics and decision support.

The MDM Developer:

  • Has an excellent understanding of MDM principles, goals, and tools and how these relate to overall HHS data quality.
  • Is responsible for development and implementation of new MDM capabilities using the Informatica application tool stack.
  • Works collaboratively with ElM program staff, with HHSC Information Technology (IT) resources, and MDM business analysts
  • to implement new program requirements for mastering critical agency data, identity resolution, data attribution, and governed reference data.

The applicant will be able to demonstrate extensive skills and/or experience in:

  • Developing MDM solutions for healthcare provider and managed care member domains (using an Informatica tool stack).
  • Developing extract/transform/load processes for HHS system data into MDM applications (using Oracle and Informatica tools).
  • Developing, testing, and maintenance of enhancements to MDM application layer(s).
  • Working closely with data architects, HHS subject matter experts, and HHS system data models to accurately represent as-is and to-be process models involving HHS master data.
  • Operational responsibility for metadata loads.
  • Planning and monitoring MDM/Metadata project lifecycle deployment using agile methods.
  • Ensuring that the build and deployment of the MDM components are of high quality and comply HHSC IT coding and security standards.
  • Managing data interfaces that consume HHS master data, ensuring effective integration between consuming source and downstream systems.
  • Logical and physical data modeling of the MOM databases (using ER Studio).
  • Meeting MDM project deliverables, goals and milestones.
  • Understanding of Health Insurance Portability and Accountability Act {HIPM) compliance policies and HHS security requirements.
  • Working with Oracle and/or Informatica support in resolution of any critical issues or bugs encountered during MDM application upgrades.

Other Special Requirements: Because of the nature of the information in the system that will be implemented, all entities must sign a Data Use Agreement (DUA) as a condition of employment.

Face-to-face interview required.

Terms and Conditions: This position is subject to funding.


Minimum Requirements:

Years                     Skills/Experience

8              Advanced Informatica and ETL developer skills

8              Experience and understanding of Enterprise Information Management best practices

5              Experience designing and implementing Master Data Management solutions

4              Experience designing and implementing Informatica PowerCenter custom solutions

4              Experience with Erwin and ERStudio data modeling tools or equivalent functional toolsets

Strong   Communication, analytical and interpersonal skills at all levels

Strong   Proven ability to work successfully with technical and non-technical groups and manage multiple

Strong responsibilities

Strong   Strong technical writing skills



Years                     Skills/Experience

Some experience as an Oracle DBA desired but not required

Experience installing and configuring Informatica Metadata Manager architecture

Experience with metadata for Master Data Management Solutions

Bachelor’s degree in Computer Science, Systems Engineering or equivalent experience


Services expect to start as soon as possible and are expected to be completed by August 31, 2017. Total estimated Worker hours shall not exceed 550 hours per worker.  This service may be amended, renewed, and/or extended providing both parties agree to do so in writing.