Job Description :
Title: SSIS Integration Developer

Location: Remote (If they were in / near Philly that would be ideal)

Type: 2-3 month contract (with possible extension)

Interview: Phone and Skype

Note: The migration work from 2008 - 2017 is very important



Job Description:

Reason for Need:


They are moving from a SQL Server 2008 R2 environment to SQL Server 2017. That will entail reviewing a bunch of SSIS packages and making sure they work in the new environment


Top 3 Things:


Deep SQL Server background (must have 2008 R2 through 2017)
Strong T-SQL development skills
Advanced SSIS skills


Internal Job Notes (Optional):


Related to SSIS in SQL Server 2017, please highlight any experience related to new SSIS features (Scale Out, Linux with SSIS, deploying packages to SSISDB on Azure, Azure-SSIS Runtime, Azure Data Factory, SSDT, etc
Should be coming out of large environments (healthcare, retail, financial services, etc
Please highlight any healthcare experience


The client was recently bought by Humana but will operate business as usual. Humana did not buy them to simply absorb them, so they appear to be in a great position to run as their own company, but with the financial backing of Humana

Day to Day:


Inspect existing SSIS packages
Modify existing and develop new SSIS packages as needed
Implement best practice processes related to a migration to SQL Server 2017
Testing and documentation duties will be included


Required Skill Sets:


Deep SQL Server background (must have 2008 R2 through 2017)
Advanced SQL programming / performance tuning / index creation and T-SQL procedures development
Proficiency in developing and deploying SSIS ETL Processes for performance and scalability
Related to SSIS in SQL Server 2017, please highlight any experience related to new SSIS features (Scale Out, Linux with SSIS, deploying packages to SSISDB on Azure, Azure-SSIS Runtime, Azure Data Factory, SSDT, etc




Thanks and Regards,

Shivangi Singh | Team Lead | KPG99, INC

Certified Minority Business Enterprise (MBE)

Direct| |