Systems Analyst 3

Radiant Digital Solutions LLC; Town of Texas (WI); Hybrid; USD 90,000 - 115,000; Full time

Job summary

Radiant Digital Solutions LLC is seeking a Systems Analyst 3 to design and support enterprise ETL/data integration systems. You will work on data ingestion from diverse sources into Oracle and Snowflake, develop mappings, and optimize data flows.

The role requires experience with Informatica PowerCenter, Oracle SQL/PLSQL, and scheduling tools, with preferred exposure to SAP Business Objects Universe and large enterprise environments. Hybrid work in Austin, TX.

Qualifications

• Enterprise ETL/data integration experience with strong SQL/PLSQL skills.
• Experience with Informatica PowerCenter and Snowflake data environments.
• Familiarity with batch scheduling tools (Control-M/Autosys/Informatica Scheduler).
• Preference for government or large enterprise environment exposure.

Responsibilities

• Analyze business objectives, problems, and user requirements to identify data integration and automation solutions.
• Conduct cost/benefit studies and evaluate alternatives to automate processes.
• Collaborate with stakeholders on data input/output requirements and reporting formats.
• Prepare detailed documentation of user needs and program functions.

Skills

ETL development

Data integration

SQL/PLSQL

Informatica PowerCenter

Snowflake

Job scheduling

Data quality

SDLC

Tools

Informatica Scheduler

Control-M

Autosys

SAP Business Objects Universe

Job description

Position: Systems Analyst 3

Location: Hybrid - Austin, Texas 78751

Duration: 11 Months

Job Summary

• Analyze business objectives, problems, and user requirements to identify data integration and automation solutions.
• Conduct studies, cost/benefit analysis, and evaluate alternative solutions for improving or automating processes.
• Collaborate with stakeholders to understand operational procedures, data input/output requirements, and reporting formats.
• Prepare detailed documentation of user needs, program functions, and steps for developing or modifying computer programs.
• Assess computer system capabilities, specifications, and scheduling limitations to determine feasibility of requested changes.
• Design, develop, and support enterprise-level ETL/data integration solutions, primarily using Informatica PowerCenter and Oracle SQL/PLSQL.
• Ingest data from diverse sources (flat files, APIs, databases, mainframes) into Oracle and Snowflake environments.
• Create and maintain ETL workflows, mappings, sessions, and reusable transformations.
• Optimize data integration processes for performance and resolve data quality issues, job failures, and bottlenecks.
• Gather and document data requirements, perform source-to-target mapping, and define data flow/design specifications.
• Manage batch job scheduling/orchestration using tools like Control-M, Autosys, or Informatica Scheduler.
• Provide production support for ETL pipelines and ensure data quality management.
• Work within structured SDLC and change management processes; collaborate effectively with business and technical teams.
• Preferred: Experience with SAP Business Objects Universe and/or working in government or large enterprise environments.