Informatica Developer

Date: Mar 6, 2026 Location: AUSTIN, TX 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 Regular/Temporary: Regular Full Time/Part Time: Full time FLSA Exempt/Non-Exempt: Exempt Job Location City: AUSTIN Job Location Address: 701 W 51ST ST 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 Position Summary The Systems Analyst reports to the Application Manager within the Health and Specialty Care Systems (HSCS) unit of the Information Technology (IT) department for the Health and Human Services Commission (HHSC). The role focuses on creating, developing, and maintaining data mappings, process workflows, and process monitoring using Informatica Power Center, while providing support for existing and new Electronic Health Record (EHR) applications.

The analyst will also perform analytical, development, and database administration work to support EHR systems and applications for State Hospitals (SH’s) and State Supported Living Centers (SSLCs), including third‑party applications such as Cerner Millennium, Netsmart myAvatar, and IRIS_DSS. Essential Job Functions (EJFs) Extract data from Cerner Millennium or myAvatar application databases using existing tools; build data mappings, tasks, and workflows with Informatica tools to load data into the data warehouse (50%). Investigate and identify corrective solutions to production problems, consult with IT teams on software/hardware justifications and purchases, and support troubleshooting of complex EHR system software and hardware incidents (20%).

Provide on‑call application support as part of the support team based on roster rotations; offer technical expertise for decision making and problem resolution for EHR applications (10%). Perform quality assurance tasks to ensure accuracy of fixes; document processes and procedures for technical and non‑technical users (10%). Execute additional duties as assigned to maintain unit operations and promote respect for cultural diversity among coworkers and all work‑related contacts (10%).

Knowledge, Skills, and Abilities (KSAs) Knowledge of EHR application 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 operating systems in Unix/Linux/AIX and Windows. Skills in using SQL, SQL*Plus, PL/SQL, TOAD, Oracle, SQL Developer, and 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 queries, 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 warehouses. 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.

Initial Screening Criteria Minimum of 6 years of experience in using DDL, DML, and DCL in the creation/maintenance of SQL Server or Oracle databases. Minimum of 8 years of experience in ETL tools such as Informatica PowerCenter or equivalent, database design, and implementation. Experience in using ITSM tools such as ServiceNow or Remedy on Demand is preferred.

Bachelor’s degree, or higher, in a technology‑related field is preferred; work experience may substitute one‑to‑one. Minimum of 8 years of experience in Unix/Linux/AIX or MS Windows servers is preferred. Minimum of 8 years of experience in report design, development, and automation is preferred.

Minimum of 4 years of experience using EHR applications (Cerner Millennium or Netsmart myAvatar) in a large‑scale private/public environment is preferred. Additional Information 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 after‑hours and weekends, may be required.

Will be part of the application support team requiring on‑call service rotation among team members. Selected candidates must be legally authorized to work in the U.S. without sponsorship. Equal Opportunity and Disability Accommodations All qualified applicants will receive consideration without regard to race, color, religion, sex, national origin, age, disability, or any other protected characteristics.

HHSC and DSHS agencies will provide reasonable accommodation during the hiring and selection process for qualified individuals with a disability. Military and Veteran Inclusion Military occupation(s) that relate to the initial selection criteria and registration or licensure requirements for this position may include, but are not limited to, those listed in the posting. All active‑duty military, reservists, guardsmen, and veterans are encouraged to apply if qualified to fill this position.

Pre‑Employment Checks Applicants selected for hire may be required to pass background and other due diligence checks. HHSC uses E‑Verify. I‑9 documentation must be brought on the first day of work.

Telework Disclaimer This position may be eligible for telework; however, all HHS positions are subject to state and agency telework policies in addition to the discretion of the direct supervisor and business needs. Nearest Major Market Austin #J-18808-Ljbffr