ETL Informatica Engineer w2 local to austin texas

ETL Informatica Engineer w2 local to austin texas

• Design, develop, and support enterprise data integration solutions as a Data Engineer/Systems Analyst.
• Develop and maintain ETL workflows using Informatica PowerCenter (mappings, sessions, workflows, reusable transformations).
• Ingest data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts) into Oracle databases.
• Utilize strong Oracle SQL/PL-SQL skills for stored procedures, packages, and ETL-related query performance tuning.
• Perform data loading, schema design, and query optimization in Snowflake.
• Develop cloud-based ETL/ELT workflows using Informatica PowerCenter and Informatica Cloud Data Integration.
• Gather data requirements, perform source-to-target mapping, and document data flows/design specifications.
• Troubleshoot and resolve data quality issues, job failures, and ETL pipeline performance bottlenecks.
• Manage and schedule ETL jobs using job orchestration tools (e.g., Control-M, Autosys, Informatica scheduler).
• Design and maintain SAP Business Objects Universes.
• Work in a state government or large enterprise IT environment, adhering to SDLC and change management processes.