Application Developer SSIS
Duties
Develop and modify SSIS packages and related stored procedures on MSSQL Server. Analyze data flow across multiple systems.
The assignment will be approximately 50% evaluating SSIS packages and tracing data, with approximately 50% modifying/creating new SSIS packages, and modifying stored procedures
Skills
Ability to work across multiple remote teams
Intermediate to advanced T-SQL skills: Experience with large amount of code with complex JOINs, subqueries, stored procedures, indexes, temp tables and CTEs
Use of GitHub for deployments
Intermediate to advanced SSIS development with numerous source and destination types, to include connecting with Teradata
Familiarity with ESP is a plus
Solving server issues such as permissions, blocks, locks, long running jobs, indexing is a plus
Experience with Medicare, Medicaid, and Risk Adjustment nice to have, but not necessary
AWS experience is a plus, especially using Glue
Education
Bachelor's in Computer Science or equivalent work experience
For more information please contact Tom Mazzulla (url removed)
Since 1995, iTech Solutions Inc., has been providing IT Consulting and Direct Hire Services to the Insurance, Financial, Communications, Manufacturing and Government sectors with local offices in Connecticut, Minnesota, Colorado, Massachusetts, Tennessee, North Carolina, and New Jersey / Pennsylvania area.
Our recruiting strategy is simple, if you want to find qualified IT professionals then use IT professionals to find them. So at iTech Solutions, our personnel are all career IT professionals with a wide range of IT experience. We can honestly say our staff understands the technologies, the complexities of finding and selecting the appropriate personnel and the pressures of running successful IT projects.
Employer will not sponsor applicants for any employment visas, at hiring or in the future, including but not limited to H-1B visas. Corp-to-Corp or subcontract personnel will not be considered for this position.