Quick Overview
Seniority
Mid Senior
Work mode
Hybrid
Location
Austin, TX, United States
Posted
Yesterday
OracleSQLETLSnowflake
Job Description
Job Title: Sr. Informatica ETL Developer / Data Engineer
Location: Austin, TX, (Hybrid)-2 days remote with 3 days (Mon, Wed & Fri) required to be onsite
Position Type: Contract
Interview Mode: MS Teams
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.
II. CANDIDATE SKILLS AND QUALIFICATIONS
|
Minimum Requirements:
Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity.
|
||
|
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, including mappings, sessions, workflows, and reusable transformations
|
|
8
|
Required
|
Experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) into Oracle databases
|
|
8
|
Required
|
Strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning of ETL-related queries
|
|
8
|
Required
|
Experience with Snowflake, including data loading, schema design, and query performance optimization
|
|
8
|
Required
|
Experience with Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development
|
|
8
|
Required
|
Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications
|
|
8
|
Required
|
Experience troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines
|
|
8
|
Required
|
Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads
|
|
3
|
Preferred
|
Experience with SAP Business Objects Universe design and/or maintenance 11
|
|
3
|
Preferred
|
Experience working in a state government or large enterprise IT environment, following formal SDLC and change management processes
|
Similar jobs
- OR
Senior Data Engineer- Fusion Experience
NewOracle
Cleveland, Ohio🇺🇸$102.3k - $209.5k/yrOn-site30 minutes agoOracleETLAgile+1Technology - TR
ETL Data Engineer
NewTriosysIT Inc.
Washington, DC🇺🇸HybridYesterdayOracleSQLSQL Server+7Technology - GE
Data Engineer - Hybrid
NewGenesis10
Charlotte, NC🇺🇸$78/hrHybridYesterdayFastAPISQLAPI Gateway+6Technology - VE
W2// Hyperion Essbase Data Engineer
NewVensIT Corp
Charlotte, NC🇺🇸On-siteYesterdayOracleSQLAWS+6Technology - QU
Data Engineer Role
NewQuinnox Inc
United States🇺🇸HybridYesterdaySQLAWSETL+4Technology - NI
Data Engineer - Snowflake DBT Talend Snowflake Snowflake Cortex
NewNityo Infotech Corporation
Atlanta, GA🇺🇸HybridYesterdaySQLSnowflakedbtTechnology