Systems Analyst 3

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

Job summary

Radiant Digital Solutions Inc. seeks a Systems Analyst 3 to join a hybrid team in Austin, TX.

You will design, develop, and support enterprise ETL/data integration solutions using Informatica PowerCenter and Oracle SQL/PLSQL, ingest data from diverse sources, and optimize performance within SDLC guidelines. You will collaborate with stakeholders to gather data requirements, document data flows, and provide production support for ETL pipelines, with a focus on data quality and reliability in a

Qualifications

• Experience designing, developing and supporting ETL/data integration solutions.
• Strong understanding of data modeling and data quality.
• Familiarity with SDLC and change management processes.

Responsibilities

• Analyze business objectives, problems, and user requirements for data integration and automation.
• Conduct studies and cost/benefit analyses for process improvements.
• Collaborate with stakeholders to define data input/output requirements and reporting formats.
• Prepare detailed documentation of user needs and program functions.
• Assess system capabilities and scheduling limitations to determine feasibility of changes.
• Design, develop and support enterprise ETL/data integration solutions using Informatica PowerCenter and Oracle SQL/PLSQL.
• Ingest data from flat files, APIs, databases, and mainframes into Oracle and Snowflake environments.
• Create and maintain ETL workflows, mappings, sessions, and transformations.
• Optimize data integration processes and resolve data quality issues and bottlenecks.
• Gather data requirements, perform source-to-target mapping, and define data flow specs.
• Manage batch job scheduling with Control-M, Autosys, or Informatica Scheduler.
• Provide production support for ETL pipelines and ensure data quality.
• Work within SDLC and collaborate with business and technical teams.
• Preferred: experience with SAP Business Objects Universe and large enterprise/government environments.

Tools

Informatica PowerCenter

Oracle SQL/PLSQL

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.