Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Austin, TX, United States
Posted
20 hours ago
OracleSQLETLSnowflake
Job Description
Informatica ETL/Data Engineer
Introduction:
We are seeking an experienced Informatica ETL/Data Engineer to join our team. The ideal candidate will have 8+ years of experience in designing, developing, and supporting enterprise data integration solutions. This role will involve working with Informatica PowerCenter, Oracle SQL/PLSQL, ETL workflows, data ingestion from diverse source systems, and providing production support.
Responsibilities:
- Design, develop, and maintain ETL workflows using Informatica PowerCenter
- Ingest data from multiple heterogeneous source systems into Oracle databases
- Work with Snowflake for data loading, schema design, and query performance optimization
- Collaborate with business and technical stakeholders to gather data requirements and perform source-to-target mapping
- Troubleshoot and resolve data quality issues, job failures, and performance bottlenecks in production ETL pipelines
- Utilize job scheduling/orchestration tools to support batch data loads
Requirements:
| Years | Required/Preferred | Experience |
|---|---|---|
| 8 | Required | Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment |
| 8 | Required | Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter |
| 8 | Required | Experience ingesting data from multiple heterogeneous source systems into Oracle databases |
| 8 | Required | Strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning |
| 8 | Required | Experience with Snowflake, Informatica Power center, and Informatica Cloud Data Integration |
| 8 | Required | Experience with data flow design, troubleshooting data quality issues, and job failures |
| 8 | Required | Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) |
| 3 | Preferred | Experience with SAP Business Objects Universe design and/or maintenance |
| 3 | Preferred | Experience working in a state government or large enterprise IT environment |
Similar jobs
- KT
Database Engineer
NewKforce Technology Staffing
Foster City, CA🇺🇸Hybrid20 hours agoMySQLSQLSQL Server+8Technology - PT
Azure Data Engineer - W2
NewPrudent Technologies and Consulting
Jackson, MI🇺🇸On-site20 hours agoMySQLOracleSQL+7Technology - HI
Data Engineer with ETL & Surveillance & Marketing Analytics @ Pittsburgh, PA - Onsite
NewHAN IT Staffing Inc.
Pittsburgh, PA🇺🇸Hybrid20 hours agoETLTechnology - KY
Software Data Engineer (No visa sponsorship available) - On W2
NewKyyba Inc
Fuquay-Varina, NC🇺🇸Hybrid20 hours agoDockerFastAPIFlask+8Technology - BA
Database Engineer with Security Clearance
NewBogart Associates
Tysons, VA🇺🇸Hybrid20 hours agoDockerGCPMySQL+21Technology - PE
Data Engineer with Security Clearance
NewPIONEERING EVOLUTION, LLC
Crystal City, VA🇺🇸$100k - $155k/yrHybrid20 hours agoDockerSQLETL+10Technology