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

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.
Only candidates able to relocate as required should apply to avoid removal from future consideration.
Our client is filling this contract position exclusively through approved staffing partners, so this opportunity is not available by applying directly with the client. If you're interested, we'd be happy to represent you throughout the hiring process.

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)

• 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)

• 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