Senior Data Engineer building and supporting enterprise ETL/ELT data integrations: day to day this means Informatica PowerCenter and Informatica Cloud development, Oracle SQL/PL/SQL work, Snowflake loading and performance tuning, source-to-target mapping, and production support of data pipelines. On-site role in Austin, TX.
Informatica PowerCenter, Informatica Cloud Data Integration, ETL, ELT, Oracle SQL, PL/SQL, Snowflake, Data Integration, Data Warehousing, Source-to-Target Mapping, Control-M, Autosys, SAP Business Objects, Data Quality, Performance Tuning, Enterprise ETL, SDLC
8+ years of experience as a Data Engineer or Systems Analyst supporting enterprise data integration solutions.
8+ years of hands-on experience with Informatica PowerCenter ETL development.
Experience integrating data from multiple source systems into Oracle databases.
Strong expertise in Oracle SQL and PL/SQL, including stored procedures, packages, and ETL query optimization.
Experience with Snowflake data loading, schema design, and query performance tuning.
Experience with Informatica Cloud Data Integration for cloud ETL/ELT development.
Experience gathering data requirements, performing source-to-target mapping, and documenting data flows.
Strong troubleshooting skills for ETL pipelines, data quality issues, and production support.
Experience with enterprise job scheduling and orchestration tools.
Preferred Qualifications
3+ years of experience with SAP Business Objects Universe design and maintenance.
Experience working in a State Government or large enterprise IT environment following formal SDLC and change management processes.