Hybrid Informatica ETL/Data Engineer (Snowflake)

TexcelVision Inc.; Austin (TX); Hybrid; USD 96,000 - 165,000; Part time

Job summary

TexcelVision Inc. is seeking an Informatica ETL/Data Engineer with 8+ years of experience to design, develop, and support enterprise data integration solutions in a hybrid Austin environment.

The role requires expertise in PowerCenter, Oracle SQL/PL-SQL, and Snowflake, with strong SDLC collaboration and production support capabilities. The candidate will ingest data from diverse sources (APIs, flat files, databases), design efficient ETL/ELT pipelines, and optimize performance across large

Qualifications

• Experience designing, developing, and supporting enterprise data integration solutions in an enterprise environment.
• Hands-on experience with ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
• Experience ingesting data from multiple heterogeneous sources (APIs, flat files, relational DBs, mainframe extracts) into Oracle databases.
• Strong Oracle SQL/PL-SQL knowledge, including stored procedures, packages, and performance tuning of ETL queries.
• Experience with Snowflake data loading, schema design, and query performance optimization.
• Experience with Informatica Cloud Data Integration for cloud-based ETL/ELT development.
• Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specs.
• Experience troubleshooting data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
• Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads.
• Experience with SAP Business Objects Universe design and/or maintenance.
• Experience working in a state government or large enterprise IT environment with formal SDLC and change management processes.

Responsibilities

• Design, develop, and support enterprise data integration solutions.
• Collaborate with business and technical stakeholders to deliver scalable data engineering solutions.
• Triage data quality issues, job failures, and performance bottlenecks in production ETL pipelines.

Skills

Informatica PowerCenter

Oracle SQL/PL-SQL

Snowflake

APIs

ETL/ELT

Batch scheduling

Control-M Autosys

SAP Business Objects Universe

Data quality

Tools

Informatica PowerCenter

Informatica Cloud Data Integration

Job description

TexcelVision Inc. is seeking an Informatica ETL/Data Engineer with 8+ years of experience to design, develop, and support enterprise data integration solutions in a hybrid Austin environment.

The role requires expertise in PowerCenter, Oracle SQL/PL-SQL, and Snowflake, with strong SDLC collaboration and production support capabilities. The candidate will ingest data from diverse sources (APIs, flat files, databases), design efficient ETL/ELT pipelines, and optimize performance across large