Senior Systems Analyst — ETL & Data Integration

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

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