Bull City Talent Group is looking for 2 SSIS Developers with ETL Experience using SSIS in SQL Server (2016) environments. Must be US or GC and able to work on W2. Not able to do CTC.
- Microsoft Visual Studio 2016 and higher
- Oracle databases (80%)
- MS SQL Server databases (20%)
- Version controlling TFS
SSIS Responsibilities Include:
Design and develop SSIS packages to move data from various sources into destination flat files and databases
Troubleshoot previous SSIS packages to solve issues
- Performance tuning existing scripts and processes
Perform Unit testing related to those packages and other updated data loads
Employing error handling techniques and promoting parallelism
Creation of SQL Agent jobs to schedule package runs
Communicate with various team members related to status updates, sprints, reviews, etc…
They are looking for someone who has experience using the SSIS integration tool. Need to know how to get into the package feature. Candidate will be building out integration packages (database to files). The team is very busy so they will be required to work independently. Oracle experience is a must. They will be connecting Oracle and SQL database. Build out packages and push out flat files.