Informatica ETL/Data Engineer

CivilSoft Technolgies Inc; Austin (TX); Hybrid; USD 115,000 - 145,000; Full time

Job summary

CivilSoft Technolgies Inc is seeking an Informatica ETL/Data Engineer for a hybrid role in Austin, TX. The contract position requires hands-on expertise in Informatica PowerCenter and Informatica Cloud, plus Oracle SQL/PLSQL and Snowflake experience.

The candidate should have 8 years of relevant experience, be comfortable with production troubleshooting, performance optimization, and batch orchestration. Knowledge of SDLC and change management is expected.

Qualifications

• Hands-on ETL/data integration design using Informatica PowerCenter and Informatica Cloud.
• Strong SQL skills including Oracle SQL/PLSQL and performance tuning.
• Experience with Snowflake data loading, schema design and query optimization.

Responsibilities

• Develop and support enterprise ETL/data integration solutions.
• Troubleshoot production issues and optimize ETL performance.
• Coordinate batch schedules with tools like Control-M, Autosys or Informatica Scheduler.

Skills

Informatica PowerCenter

Informatica Cloud

Oracle SQL/PLSQL

Snowflake

Job description

Job Overview

• Title: Informatica ETL/Data Engineer

• Location: Austin, TX

• Work Mode: Hybrid -- 3 Days Onsite

• Employment Type: Contract

• Experience Required: 8 Years

• Work Authorization: or H1

• Domain: State Government or Large Enterprise IT

• Key Skills: Informatica PowerCenter, Informatica Cloud, Oracle SQL/PLSQL, Snowflake

Role Summary

The role requires strong hands‑on experience developing and supporting enterprise ETL/data integration solutions using Informatica PowerCenter and Informatica Cloud . The position also requires Oracle SQL/PLSQL, Snowflake, production troubleshooting, ETL performance optimization, and batch scheduling/orchestration experience.

Experience with SAP BusinessObjects Universe, formal SDLC, and change management is required.
Looking for 8 years of hands‑on experience with:

• Informatica PowerCenter --- mappings, sessions, workflows & transformations
• Informatica Cloud Data Integration / cloud ETL & ELT
• Oracle SQL/PLSQL --- stored procedures, packages & performance tuning
• Snowflake --- data loading, schema design & query optimization
• Enterprise ETL/data integration across multiple source systems
• Source-to-target mapping & data flow documentation
• Data quality, production troubleshooting & ETL performance optimization
• Batch scheduling/orchestration tools such as Control‑M, Autosys or Informatica Scheduler.
  Must have SAP BusinessObjects Universe experience & Formal SDLC & change management experience