Overview
On Site
Depends on Experience
Contract - W2
Skills
T-SQL
SSIS
SSMS
ETL
Visual Studio
MSSQL
PeopleSoft
Azure
agile
Cloud Computing
Data Conversion
Data Mining
Database
Development Testing
Enterprise Resource Planning
Extract
Transform
Load
Microsoft Azure
Microsoft SQL Server
Microsoft SQL Server Management Studio (SSMS)
Microsoft SSIS
Microsoft Visual Studio
Oracle
SQL
RDBMS
Transact-SQL
Job Details
General Description:
Performs highly advanced (senior-level) ETL development work as part of a team on the Data Conversion Project at ERS. ERS has embarked on a multi-year project to convert data from their legacy PeopleSoft system to a cloud solution. The ETL development work will be extracting data from an Oracle database and transforming/loading it to an in-house SQL Server database. Extensive T-SQL skills will be key to the process.
Duties and Responsibilities
Essential Functions:
- Performs advanced ETL development work on data primarily residing in SQL Server
- Translates rules provided by PeopleSoft developers (Oracle based) into efficient T-SQL scripts to load data into the target database on SQL Server
- Troubleshoots, supports and maintains the ETL processes developed by the team
- Designs, deploys, and manages standardized, centralized data sources
- Helps to establish best practices for development, testing, migration and error handling of the ETL activities
- Performs other duties as assigned
Qualification Requirements
Education/Special Requirements:
- Bachelor s degree in computer science, engineering, or related business field.
Experience and Training
- Three (3) years of hands on experience in T-SQL and SSIS/SSMS development
- Three (3) years of hands on experience in ETL development
- Three (3) years of hands on experience moving and manipulating large data sets
Preferred Qualifications
- Experience in health/life insurance, accounting and financials, or investment data related activities
- Experience with data tools (i.e. Visual Studio, SSIS, MSSQL )
- Experience with Azure and agile iterations
- Experience with ERP applications (i.e. PeopleSoft, etc.)
Knowledge, Skills and Abilities
- Uses all knowledge, skills, and abilities to apply critical thinking to all aspects of the job. Critical thinking is a process of forming reasoned opinions through observation, information collection, interpretation, analysis, inference, evaluation, and other skills necessary to successfully meet performance standards of the job.
- Experience with PeopleSoft HRMS or Finance packages preferred
- Experience with ERD Modeling & Maintenance
- Knowledge of RDBMS architecture and troubleshooting is desirable.
- Knowledge of data mining methods
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.