Informatica ETL Developer / Data Engineer (Hybrid – 3 days/week onsite)

Vitaver & Associates, Inc; Austin (TX); Hybrid; USD 96,000 - 124,000; Part time

Job summary

Vitaver & Associates, Inc. seeks an experienced Informatica ETL Developer / Data Engineer for a hybrid role in Austin, TX.

The position focuses on designing, developing, and supporting enterprise data integration solutions across multiple business systems. You will build ETL workflows with Informatica PowerCenter and Informatica Cloud Data Integration, ingest data into Oracle and Snowflake, and ensure data quality and performance in production environments.

Qualifications

• 8+ years of experience designing, developing, and supporting enterprise data integration solutions.
• Experience with developing and maintaining ETL workflows using Informatica PowerCenter and Informatica Cloud Data Integration, including mappings, sessions, workflows, and reusable transformations.
• Experience with ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts) into Oracle databases.
• Experience with Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning of ETL-related queries.
• Experience with Snowflake, including data loading, schema design, and query performance optimization.
• Experience with gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications.
• Experience with troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
• Experience with job scheduling/orchestrations tools supporting batch data loads.

Responsibilities

• Design, develop, and support enterprise data integration solutions across multiple business systems.
• Build and maintain ETL workflows using Informatica PowerCenter, including mappings, sessions, and reusable transformations.
• Ingest and integrate data from diverse source systems into Oracle and Snowflake environments.
• Perform source-to-target mapping and maintain data flow and design documentation.
• Monitor and optimize ETL performance, including batch job scheduling and orchestration.
• Troubleshoot and resolve data quality issues, job failures, and production performance bottlenecks.
• Collaborate with business and technical stakeholders in structured SDLC and change management environments.

Skills

Data Engineer

ETL development

Informatica PowerCenter

Informatica Cloud Data Integration

Oracle SQL/PL-SQL

Snowflake

Data modeling

Source-to-target mapping

Production support

Job scheduling

Tools

Control-M

Autosys

Informatica Scheduler

SAP Business Objects Universe design

Job description

• Austin, TX

14911 - Informatica ETL Developer / Data Engineer(Hybrid – 3 days/week onsite) – Austin, TX
Start Date: ASAP
Type: Temporary Project
Estimated Duration: 12+ months with possible extensions
Work Setting: Onsite 3 days per week (Monday, Wednesday, Friday); remote 2 days per week.
Required:

• Experience with designing, developing, and supporting enterprise data integration solutions as a Data Engineer/Systems Analyst (8+ years)
• Experience with developing and maintaining ETL workflows using Informatica PowerCenter and Informatica Cloud Data Integration, including mappings, sessions, workflows, and reusable transformations (8+ years)
• Experience with ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts) into Oracle databases (8+ years)
• Experience with 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 gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications (8+ years)
• Experience with 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 (8+ years)

Preferred:

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

Responsibilities include but are not limited to the following:

• Design, develop, and support enterprise data integration solutions across multiple business systems
• Build and maintain ETL workflows using Informatica PowerCenter, including mappings, sessions, and reusable transformations
• Ingest and integrate data from diverse source systems into Oracle and Snowflake environments
• Perform source-to-target mapping and maintain data flow and design documentation
• Monitor and optimize ETL performance, including batch job scheduling and orchestration
• Troubleshoot and resolve data quality issues, job failures, and production performance bottlenecks
• Collaborate with business and technical stakeholders in structured SDLC and change management environments