Hybrid Systems Analyst 3 - Data Engineer (ETL/Snowflake)

My3Tech; Austin (TX); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Texas Health and Human Services Commission is seeking a Systems Analyst 3 in Austin, TX. The role is hybrid (Mon, Wed, Fri onsite) with a 12+ month duration. The team focuses on data engineering, ETL design, and enterprise data integration using Informatica PowerCenter and Snowflake.

Strong SQL/PL-SQL proficiency and experience with batch scheduling are required. The position requires analyzing user needs, translating requirements into data flows, and delivering scalable data solutions in a

Qualifications

• 8+ years as a Data Engineer/Systems Analyst in an enterprise setting.
• Hands-on ETL development and maintenance using Informatica PowerCenter.
• Experience ingesting data from multiple heterogeneous sources into Oracle DBs.
• Strong Oracle SQL/PL-SQL, including performance tuning.
• Experience with Snowflake data loading, schema design, and query performance.
• Experience with Informatica PowerCenter and Informatica Cloud Data Integration.
• Gathering data requirements, mapping, and documenting data flows.
• Troubleshooting data quality, job failures, and ETL bottlenecks.
• Experience with batch data loads using scheduling/orchestration tools.

Skills

Data integration

ETL workflows

Source-to-target mapping

Oracle SQL/PL-SQL

Snowflake

Informatica PowerCenter

Informatica Cloud Data Integration

Data quality

Job scheduling

Control-M

Autosys

Informatica Scheduler

SAP BO Universe

State government

SDLC processes

Tools

Informatica PowerCenter

Informatica Cloud Data Integration

Oracle SQL/PL-SQL

Snowflake

Control-M

Autosys

Informatica Scheduler

Job description

Texas Health and Human Services Commission is seeking a Systems Analyst 3 in Austin, TX. The role is hybrid (Mon, Wed, Fri onsite) with a 12+ month duration. The team focuses on data engineering, ETL design, and enterprise data integration using Informatica PowerCenter and Snowflake.

Strong SQL/PL-SQL proficiency and experience with batch scheduling are required. The position requires analyzing user needs, translating requirements into data flows, and delivering scalable data solutions in a