Job Description
Systems Analyst 3 (1785)Austin, Texas - Position will be 2 days remote with 3 days (Mon, Wed & Fri) required to be onsite at the location listed above.
Program will only allow candidates who are LOCAL TO THE AUSTIN AREA ONLY (Within 50-mile radius).
10 Months Contract
Required
8 Years - Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment
8 Years - Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations
8 Years - Experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) into Oracle databases
8 Years - Strong working knowledge of 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 Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development
8 Years - Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications
8 Years - Experience 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
Preferred
3 Years - Experience with SAP Business Objects Universe design and/or maintenance 11
3 Years - Experience working in a state government or large enterprise IT environment, following formal SDLC and change management processes