Hybrid Informatica ETL/Data Engineer

HonorVet Technologies; Austin (TX); Hybrid; USD 120,000 - 180,000; Full time

Job summary

HonorVet Technologies in Austin, TX is seeking an Informatica ETL/Data Engineer with 8+ years of experience to design, develop, and support enterprise data integration solutions across diverse source systems.

You will work with Informatica PowerCenter, Snowflake, Oracle SQL/PL-SQL, and batch scheduling tools in a structured SDLC, collaborating with business and technical stakeholders to deliver scalable data pipelines and reliable production support.

Qualifications

• 8+ years designing, developing, and supporting enterprise data integration solutions.
• Experience integrating data from diverse source systems (flat files, APIs, databases, mainframes).
• Strong knowledge of ETL workflows, data ingestion, and production support.

Responsibilities

• Design, develop, and support enterprise data integration solutions.
• Collaborate with business and technical stakeholders to deliver scalable data pipelines.
• Troubleshoot data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
• Coordinate with scheduling tools for batch data loads.

Skills

ETL/Data Integration design

Data quality management

SDLC collaboration

Analytical communication

Production support

Tools

Informatica PowerCenter

Snowflake

Oracle SQL/PL-SQL

Informatica Cloud Data Integration

Control-M / Autosys

Job description

HonorVet Technologies is a Service Disable Veteran-Owned IT staffing firm, ISO 9001, and ISO 27001 certified, working with federal agencies, state governments, and Fortune 500 enterprise clients across the US. What makes us different isn't a tagline; it's the way we work. We don't forward resumes and hope for the best. We take the time to understand where a professional like you are headed and only reach out when we genuinely believe there's a fit worth exploring. I came across your profile, and something stood out.

Local to Austin Texas only

Job Title: Informatica ETL/Data Engineer

Duration: 10+ Months with possible extension

Hybrid: 2 days remote with 3 days (Mon, Wed & Fri) required to be onsite

Location: Austin, TX 78751

Job Description:

Informatica ETL/Data Engineer with 8+ years of experience designing, developing, and supporting enterprise data integration solutions. Expertise in Informatica PowerCenter, Oracle SQL/PLSQL, ETL workflows, data ingestion from diverse source systems, and production support.

Hands-on experience with Snowflake, Informatica Power center, source-to-target mapping, data quality management, performance optimization, and batch job scheduling in large enterprise environments.

Strong analytical and communication skills with experience working in structured SDLC environments, collaborating with business and technical stakeholders to deliver scalable data engineering solutions.

Required Skills:

• 8 Years Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment
• 8 Years Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations
• 8 Years Experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) into Oracle databases
• 8 Years Strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning of ETL-related queries
• 8 Years Experience with Snowflake, including data loading, schema design, and query performance optimization
• 8 Years Experience with Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development
• 8 Years Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications
• 8 Years Experience troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines
• 8 Years Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads

Preferred Skills:

• 3 Years Experience with SAP Business Objects Universe design and/or maintenance 11
• 3 Years Experience working in a state government or large enterprise IT environment, following formal SDLC and change management processes