ACADEMIC AFFAIRS is looking to develop and maintain PL/SQL web pages for student and advisor facing functionalities, manage Unix shell scripts for job execution and scheduling, perform data loading and testing, troubleshoot issues related to student conditional accesses in Banner, conduct migration testing for Banner systems, and develop ETL processes for data segregation and movement between various systems including CommonApp, Banner, TargetX on Salesforce, and UCCM.
Requirements
- PL/SQL objects such as Functions, Procedures and Packages
- Unix shell scripts on Linux
- Cron jobs
- SQL PLUS on RHEL servers
- Banner forms and banner tables
- Informatica IICS' Cloud Data Integration
- Informatica's REST API v3 functionality
Responsibilities
- Develop and test PL/SQL objects such as Functions, Procedures and Packages to maintain PL/SQL web pages for student and advisor facing functionalities.
- Develop and maintain Unix shell scripts on Linux to execute PL/SQL jobs and schedule using Cron jobs.
- Perform data loading and PL/SQL script testing using SQL PLUS on RHEL servers.
- Utilize Banner forms and banner tables to troubleshoot issues on student conditional accesses on banner.
- Perform migration testing of on-premise banner systems to Ellucian managed cloud services.
- Develop and maintain ETL processes using Informatica IICS' Cloud Data Integration to segregate and move data from sources like CommonApp and Banner to TargetX on Salesforce.
- Perform ETL integrations using IICS CDI between systems such as UCCM to load data to banner tables.
Other
- Full Time
- Each agency within the Commonwealth of Virginia is dedicated to recruiting, supporting, and maintaining a competent and diverse work force.
- Equal Opportunity Employer
