Systems Analyst 3

Systems Analysis, Systems Analysis, Systems Engineering, Database Extract Transform and Load (ETL), Informatica, Oracle PL-SQL, Stored Procedures, Performance Tuning/Optimization, Oracle Database, Snowflake Schema, Candidates that do not meet or exceed the minimum stated requirements (skills/experience) will be displayed to customers but may not be chosen for this opportunity. Years Required/Preferred Experience 8 Required Experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment 8 Required Hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations 8 Required Experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) into Oracle databases 8 Required Strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning of ETL-related queries 8 Required Experience with Snowflake, including data loading, schema design, and query performance optimization 8 Required Experience with Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development 8 Required Experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications 8 Required Experience troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines 8 Required Experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads 3 Preferred Experience with SAP Business Objects Universe design and/or maintenance 11 3 Preferred Experience working in a state government or large enterprise IT environment, following formal SDLC and change management processes