Systems Analyst 3 (Hybrid)

Serigor•Austin, TX

5d•Hybrid

About The Position

This role involves understanding business objectives and problems, identifying alternative solutions, and performing cost-benefit analyses. The Systems Analyst will analyze user requirements, procedures, and problems to automate processing or improve existing computer systems. This includes conferring with personnel to analyze operational procedures, identify problems, and understand specific input and output requirements. The analyst will write detailed descriptions of user needs and program functions, and review computer system capabilities to determine the feasibility of requested programs or changes. The position requires an Informatica ETL/Data Engineer with over 8 years of experience in designing, developing, and supporting enterprise data integration solutions. Key expertise includes Informatica PowerCenter, Oracle SQL/PLSQL, ETL workflows, data ingestion from diverse sources, and production support. Hands-on experience with Snowflake, Informatica PowerCenter, source-to-target mapping, data quality management, performance optimization, and batch job scheduling in large enterprise environments is essential. Strong analytical and communication skills are needed, along with experience in structured SDLC environments and collaboration with business and technical stakeholders to deliver scalable data engineering solutions.

Requirements

8+ years of experience as a Data Engineer/Systems Analyst designing, developing, and supporting data integration solutions in an enterprise environment.
8+ years of hands-on experience developing and maintaining ETL workflows using Informatica PowerCenter, including mappings, sessions, workflows, and reusable transformations.
8+ years of experience ingesting data from multiple heterogeneous source systems (flat files, APIs, relational databases, mainframe extracts, etc.) into Oracle databases.
8+ years of strong working knowledge of Oracle SQL/PL-SQL, including stored procedures, packages, and performance tuning of ETL-related queries.
8+ years of experience with Snowflake, including data loading, schema design, and query performance optimization.
8+ years of experience with Informatica Power center / Informatica Cloud Data Integration for cloud-based ETL/ELT development.
8+ years of experience gathering data requirements, performing source-to-target mapping, and documenting data flow/design specifications.
8+ years of experience troubleshooting and resolving data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
8+ years of experience with job scheduling/orchestration tools (e.g., Control-M, Autosys, or Informatica scheduler) supporting batch data loads.
Strong analytical and communication skills.
Experience working in structured SDLC environments.
Experience collaborating with business and technical stakeholders to deliver scalable data engineering solutions.

Nice To Haves

3+ years of preferred experience with SAP Business Objects Universe design and/or maintenance.
3+ years of preferred experience working in a state government or large enterprise IT environment, following formal SDLC and Change management processes.

Responsibilities

Understand business objectives and problems.
Identify alternative solutions and perform cost/benefit analysis.
Analyze user requirements, procedures, and problems to automate processing or improve existing computer systems.
Confer with personnel to analyze current operational procedures, identify problems, and learn specific input and output requirements.
Write detailed descriptions of user needs and program functions.
Review computer system capabilities, specifications, and scheduling limitations.
Design, develop, and support enterprise data integration solutions.
Develop and maintain ETL workflows using Informatica PowerCenter.
Ingest data from multiple heterogeneous source systems into Oracle databases.
Perform source-to-target mapping and document data flow/design specifications.
Troubleshoot and resolve data quality issues, job failures, and performance bottlenecks in production ETL pipelines.
Support batch data loads using job scheduling/orchestration tools.