Informatica Developer Job Listing at Texas Health and Human Services in Austin, TX (Job ID 14623-en_US)

Description

Join the Texas Health and Human Services Commission (HHSC) and be part of a team committed to creating a positive impact in the lives of fellow Texans. At HHSC, your contributions matter, and we support you at each stage of your life and work journey. Our comprehensive benefits package includes 100% paid employee health insurance for full-time eligible employees, a defined benefit pension plan, generous time off benefits, numerous opportunities for career advancement and more. Explore more details on the Benefits of Working at HHS webpage.

Functional Title: Informatica Developer 
Job Title: Systems Analyst V 
Agency: Health & Human Services Comm 
Department: State Hospitals Facility Supp 
Posting Number: 14623 
Closing Date: 06/04/2026 
Posting Audience: Internal and External 
Occupational Category: Computer and Mathematical 
Salary Range: $5,797.66 - $8,000.00 
Pay Frequency: Monthly
Salary Group: TEXAS-B-25 
Shift: Day 
Additional Shift:  
Telework:  
Travel:  
Regular/Temporary: Regular 
Full Time/Part Time: Full time 
FLSA Exempt/Non-Exempt: Exempt 
Facility Location:  
Job Location City: AUSTIN 
Job Location Address: 701 W 51ST ST 
Other Locations:  
MOS Codes: 0171,8848,8858,181X,182X,1D7X1,255A,255S,25B,25D,25H,26B,62E,681X,682X,781X,CTI,CTM,CTR,CYB10,CYB11 
ISM,IT,Z Prefix 
 
 

The Systems Analyst reports to Application Manager within Health and Specialty Care Systems (HSCS) unit of Information Technology (IT) department for Health and Human Service Commissions (HHSC).  This position applies their expertise and technical skills in creating, developing, and maintaining data mappings, process workflows, process monitoring using Informatica Power Center and support for existing and new Electronic Health Record (EHR) applications.  This position is within the software development and support team and requires development of application business logic with stored procedures and support applications experience.

The analyst will also perform analytical, development, and database administrations work for information systems and technologies to support Electronic Health Record (EHR) systems and applications for the State Hospitals (SH's) and State Supported Living Centers (SSLCs). The analyst will support multiple third-party applications (Cerner's Millennium, Netsmart's myAvatar, and IRIS_DSS, among others).  Work involves gathering and analyzing requirements, design, development, implementation of new solutions, and on-going maintenance of existing systems and processes.

Analyst will work with other HSCS application support staff as well as other HHSC teams to develop and support information systems. The analyst may interact with staff from vendors, other agencies and outside entities as required to provide continued support, obtain required work products, or for consultation. Work is performed in an Agile environment and creativity is encouraged.

• Work outside of regular hours, including occasional afterhours and weekends, may be required.
• Will be part of the application support team which requires to provide on-call service rotation among team members.

Selected candidate must work onsite from an HHS office located in Austin, Texas designated by the hiring manager. 

Essential Job Functions (EJFs):

1. Extracts data from Cerner Millennium or myAvatar application databases using existing tools. Builds data mappings, tasks and workflows using Informatica Tools to load data to the data warehouse databases. Documents, designs, validates, and implements reporting methodologies for multiple areas of specialization using selected HHSC methodology and tools. (50%)
2. Investigates and identifies corrective solutions to production problems / issues. Consults with IT teams on software/hardware justifications and purchases. Supports in troubleshooting and solving complex problems related to EHR system software and hardware incidents and problem calls, and in the processing of service requests and tasks. (20%)
3. May provide on-call application support as part of the support team based on team rosters. Provides technical expertise to aid in decision making and problem resolution for EHR applications. (10%).
4. Performs quality assurance tasks to ensure accuracy of fixes provided to resolve issues. Documents processes and procedures for technical and non-technical users. (10%)
5. Perform other duties as assigned and required to maintain unit operations. Promotes and demonstrates appropriate respect for cultural diversity among coworkers and all work-related contacts (10%).

Knowledge, Skills and Abilities (KSAs):

• Knowledge of EHR applications functionality.
• Knowledge of relational databases, data systems and data warehouses.
• Knowledge of best practices governing architecture, infrastructure and security for information systems that collect PII, PHI and HIPAA data.
• Skills in developing complex high-quality database solutions.
• Skills in using server OS in Unix/Linux/AIX and Windows servers.
• Skills in using software such as SQL, SQL*Plus, PL/SQL, TOAD, Oracle, SQL Developer, Business Intelligence tools.
• Skills in analysis, problem solving, data comprehension, reporting methodologies, and designing statistical reports and charts/graphs. 
• Skill in researching and troubleshooting application system issues and solving complex problems.
• Skill in writing Stored Procedures, SQL quiries and query tuning on high transaction systems.
• Ability to maintain database indexes, columns and tables using DDL, DML and DCL constructs. 
• Ability in building data mappings, tasks and workflows using Informatica Tools to load into data warehouse databases.
• Ability to analyze, consolidate, and interpret complex data, procedures, and systems and write or revise program code as required.
• Ability to present information to a variety of audiences verbally and in writing and to communicate clearly, concisely, and effectively.
• Ability to work hours as needed to meet defined deadlines and support the agency's mission critical requirements.
• Ability to provide excellent customer service to end users of the applications.

Registrations, Licensure Requirements or Certifications:

N/A

Initial Screening Criteria:

• Minimum of 6 years of experience in using DDL (Data Definition Language), DML (Data Manipulation Language), and DCL (Data Control Language) in the creation/maintenance of SQL Server databases, Oracle or similar, is required.
• Minimum of 8 years of experience in data extraction, transition, and load (ETL) tools such as Informatica PowerCenter or equivalent, database design and implementation preferred.
• Experience in using ITSM tools such as ServiceNow, Remedy on Demand or similar is preferred
• Bachelor's degree, or higher, in a technology related field is preferred. May substitute direct work experience on a year-for-year basis in lieu of education. 
• Minimum of 8 years of experience in using Unix/Linux/AIX OS or MS Windows Servers are preferred.
• Minimum of 8 years of experience in report design, development and automation is preferred.
• Minimum 4 years of experience in using EHR application (Cerner Millennium, Netsmart's myAvatar or similar) in a largescale private/public environment is preferred.

Additional Information:

Any employment offer is contingent upon available budgeted funds. The offered salary will be determined in accordance with budgetary limits and the requirements of HHSC Human Resources Manual. 

• Selected candidate must be willing to work from an HHS office located in Austin, designated by the hiring manager. 
• Work outside of regular hours, including occasional afterhours and weekends, may be required. 
• Will be part of the application support team which requires to provide on-call service rotation among team members.
• Selected candidates must be legally authorized to work in the U.S. without sponsorship.

#LI-GN1

Review our Tips for Success when applying for jobs at DFPS, DSHS and HHSC.

Active Duty, Military, Reservists, Guardsmen, and Veterans:

Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but not limited to those listed in this posting. All active-duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position. For more information please see the Texas State Auditor's Job Descriptions, Military Crosswalk and Military Crosswalk Guide at Texas State Auditor's Office - Job Descriptions.

ADA Accommodations:

In compliance with the Americans with Disabilities Act (ADA), HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. If you need assistance completing the on-line application, contact the HHS Employee Service Center at 1-888-894-4747. If you are contacted for an interview and need accommodation to participate in the interview process, please notify the person scheduling the interview.

Pre-Employment Checks and Work Eligibility:

Depending on the program area and position requirements, applicants selected for hire may be required to pass background and other due diligence checks.

HHSC uses E-Verify. You must bring your I-9 documentation with you on your first day of work. Download the I-9 Form

Telework Disclaimer:

This position may be eligible for telework.  Please note, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs.