SQL ETL Developer
Share
Job Location:
Chapel Hill, NC - USA
Hourly Salary:
$ 45 - 50
Posted on:
21 hours ago
Vacancies:
1 Vacancy
Job Summary
Position Summary
This temporary position provides short-term support for SQL Server database operations data integration and reporting activities within the School of Medicine Information Technology department. The role focuses on operational support of existing systems including SQL development SQL Server Agent jobs SSIS packages and ETL processes to ensure continuity of data services. Essential Duties and Responsibilities: * Develop maintain and optimize SQL Server queries views functions and stored procedures in support of operational and reporting needs. * Monitor and support SQL Server Agent jobs including reviewing job status troubleshooting failures and validating scheduled executions. * Support SQL Server Integration Services ( SSIS ) packages by monitoring data loads validating data movement and assisting with issue resolution. * Perform routine data and database checks to support data quality integrity and performance. * Assist with data extraction transformation and loading ( ETL ) processes using Informatica ( IICS ) SSIS or comparable ETL tools. * Support integration of data from multiple source systems into SQL Server environments. * Assist with query performance tuning and indexing activities under the guidance of senior technical staff. * Support operational and ad hoc reporting requests using SQL Server and approved reporting tools. * Prepare and maintain documentation related to database objects scheduled jobs and data processes
Work Schedule
Monday Friday (8:00 AM 5:00 PM)
This temporary position provides short-term support for SQL Server database operations data integration and reporting activities within the School of Medicine Information Technology department. The role focuses on operational support of existing systems including SQL development SQL Server Agent jobs SSIS packages and ETL processes to ensure continuity of data services. Essential Duties and Responsibilities: * Develop maintain and optimize SQL Server queries views functions and stored procedures in support of operational and reporting needs. * Monitor and support SQL Server Agent jobs including reviewing job status troubleshooting failures and validating scheduled executions. * Support SQL Server Integration Services ( SSIS ) packages by monitoring data loads validating data movement and assisting with issue resolution. * Perform routine data and database checks to support data quality integrity and performance. * Assist with data extraction transformation and loading ( ETL ) processes using Informatica ( IICS ) SSIS or comparable ETL tools. * Support integration of data from multiple source systems into SQL Server environments. * Assist with query performance tuning and indexing activities under the guidance of senior technical staff. * Support operational and ad hoc reporting requests using SQL Server and approved reporting tools. * Prepare and maintain documentation related to database objects scheduled jobs and data processes
Work Schedule
Monday Friday (8:00 AM 5:00 PM)
Required Experience:
Staff IC
About Company
The University of North Carolina at Chapel Hill, the nation’s first public university, is a global higher education leader known for innovative teaching, research and public service. A member of the prestigious Association of American Universities, Carolina regularly ranks as the best ... View more
