ETL Data Engineer C2C contract Hybrid in Austin, TX

Tech Mirrors; Austin (TX); On-site; USD 100,000 - 130,000; Full time

Job summary

Tech Mirrors is looking for an experienced ETL Data Engineer based in Austin, TX. The role encompasses developing and maintaining ETL mappings with a focus on integrating diverse data sources into analytics solutions.

The ideal candidate will have over 8 years of experience in data engineering, particularly with Informatica and Snowflake. Responsibilities include building data workflows, collaborating with cross-functional teams, and participating in Agile practices.

Qualifications

• 8+ years of experience with ETL development.
• Strong analytical, troubleshooting, and problem-solving skills.
• Experience with healthcare data security principles.

Responsibilities

• Develop and maintain ETL mappings using Informatica.
• Acquire and integrate data from multiple sources.
• Collaborate on data integration strategies.

Skills

Informatica Power Center

SQL Script Development

Data Integration

Agile Methodologies

Data Modeling

Analytical Skills

Education

Bachelor’s degree in Computer Science or equivalent

Tools

Snowflake

Oracle

SQL Server

Excel

Python

JIRA

Job description

ETL Data Engineer

Location: Austin, TX

Duration: 12+

Interview: Virtual Than in person

Job Description

HHSC IT is seeking an experienced Systems Analyst 3 / Data Engineer to support the development and enhancement of the Performance Management & Analytics System (PMAS) data integration hub. The candidate will work within an Agile environment to design, develop, automate, and maintain enterprise data integration and analytics solutions.

Key Responsibilities

• Develop and maintain ETL mappings and workflows using Informatica Power Center/IICS
• Acquire and integrate data from multiple sources including Oracle, SQL Server, Excel, Access, and Adobe PDF
• Design and develop complex Snowflake SQL scripts, views, and materialized views
• Transform source data into dimensional data models for analytics and reporting
• Collaborate with architects and data engineering teams on data integration strategies
• Perform testing, validation, troubleshooting, and performance optimization
• Participate in Agile sprint ceremonies and SDLC activities
• Create technical documentation, specifications, and diagrams
• Support deployment, enhancement, and operations of the data integration hub

Required Skills & Experience

• 8+ years of experience developing ETL mappings and workflows using Informatica Power Center or IICS
• 8+ years of experience acquiring and integrating data from multiple data sources/technologies using Informatica
• 8+ years of experience working with Oracle, SQL Server, Excel, Access, and Adobe PDF data sources
• 8+ years of experience designing and developing complex Snowflake SQL scripts
• 8+ years of experience as a Systems Analyst/Data Analyst on data warehousing, analytics, or performance management projects
• 8+ years of strong analytical, troubleshooting, and problem-solving experience
• 8+ years of experience with technical documentation, Visio/Erwin, MS Office Suite, and MS Project
• 8+ years of experience delivering enterprise-level software platforms across multiple teams
• 8+ years of experience writing efficient, testable, and well-designed code using software development best practices

Preferred Skills

• 6+ years of strong verbal and written communication skills
• 6+ years of experience managing multiple priorities and assignments in fast‑paced environments
• 4+ years of Agile/Scrum team experience
• 4+ years of experience with healthcare data security principles
• 4+ years of experience with BI/performance metrics visualization environments
• 4+ years of Healthcare Industry experience
• 4+ years of HHS agency experience
• 4+ years of experience handling PII/PHI data
• 4+ years of Python scripting experience
• 4+ years of experience using JIRA
• 2+ years of experience with REST/SOAP web services
• 2+ years of Java and JavaScript development experience
• 2+ years of experience developing CI/CD pipelines using GitHub and GitHub Actions
• 2+ years of MuleSoft development experience
• 2+ years of experience using AI tools such as Snowflake Cortex, Snowflake Intelligence, or Informatica Claire
• Bachelor’s degree in Computer Science, Information Systems, Business, or equivalent experience preferred