MDM/ETL Developer

Position: MDM/ETL Developer Location: Austin, TXDuration: 4 months (1000 Hours)The HIP MDM/ETL 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 EIM program staff, with HHSC Information Technology (IT) resources, and MDM business analysts to implement new program requirements for mastering critical agency data, identity resolution, trusted attribution, and governed reference data. The applicant will be able to demonstrate extensive 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 EIM 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 standardsII. WORKER SKILLS AND QUALIFICATIONSMinimum Requirements:YearsSkills/Experience8Advanced Informatica and ETL developer skills8Experience and understanding of Enterprise Information Management best practices5Experience designing and implementing Master Data Management solutions4Experience designing and implementing Informatica PowerCenter custom solutions4Experience with Erwin and ERStudio data modeling tools or equivalent functional toolsetsStrongCommunication, analytical and interpersonal skills at all levelsStrongProven ability to work successfully with technical and non-technical groups and manage multiple responsibilitiesStrongStrong technical writing skillsPreferred:YearsSkills/ExperienceSome experience as an Oracle DBA desired, but not requiredExperience installing and configuring Informatica Metadata Manager architectureExperience with metadata for Master Data Management solutions