Senior Data Engineer – Agile Integration & ETL Automation (Public Sector Projects)- Onsite in Austin, Texas (W2 Only)

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Engineer focused on Agile Integration & ETL Automation for public sector projects in Austin, Texas. The contract length is unspecified, with a pay rate of "W2 Only." Key skills required include 8+ years in data engineering, Oracle SQL, and Informatica.
🌎 - Country
United States
💱 - Currency
$ USD
💰 - Day rate
Unknown
Unknown
🗓️ - Date discovered
April 25, 2025
🕒 - Project duration
Unknown
🏝️ - Location type
Unknown
📄 - Contract type
W2 Contractor
🔒 - Security clearance
Unknown
📍 - Location detailed
Austin, Texas Metropolitan Area
🧠 - Skills detailed
#"ETL (Extract #Transform #Load)" #Data Pipeline #Data Integration #SQL (Structured Query Language) #Informatica PowerCenter #IICS (Informatica Intelligent Cloud Services) #Oracle #Automation #Data Engineering #Informatica #Agile #Leadership
Role description

We’re seeking a Senior Data Engineer with extensive experience in systems analysis, SQL development, ETL automation, and agile project leadership. You’ll play a key role in building and optimizing a state-level Data Integration Hub supporting mission-critical applications for public health and human services.

You’ll be part of an Agile team modernizing data pipelines using Oracle, Informatica (PowerCenter/IICS), and automated validation tools—delivering real impact for state-wide programs.

🛠️ Key Responsibilities

   • Lead technical development within an Agile data engineering team.

   • Design and develop ETL pipelines using Informatica PowerCenter/IICS.

   • Write and validate complex SQL scripts for data transformation and integration.

   • Automate data acquisition from multiple sources for internal/external use.

   • Build Oracle database views and materialized views for dimensional modeling.

   • Participate in sprint ceremonies, story writing, and architectural discussions.

   • Collaborate with architects and business stakeholders to refine requirements.

✅ Minimum Qualifications

   • 8+ years of experience in systems analysis and data engineering roles.

   • Strong expertise with Oracle SQL, Informatica PowerCenter/IICS.

   • Hands-on experience with data integration and transformation projects.

   • Experience working in Agile development environments.

   • Ability to document technical designs and collaborate with cross-functional teams.