Job Description :
What is the specific title of the position ETL/SSIS DevOps
PROJECT: Pathway. Pathway is the mission critical integrated care management application for Complex Care Management. It will deliver an improved user experience to approximately 2000 clinical & corporate users enabling comprehensive medical management and clinical documentation, integrated outreach, practice, and revenue cycle management to improve efficiency & effectiveness through increased quality, accuracy and completeness of data and information.
TOP REQUIREMENTS:
? Strong SSIS - ETL resource.
? Experience working on SQL Server database writing SQL queries and stored procedures
? DevOps experience building and deploying SSIS packages via TFS
* What experience will set candidates apart from one another Knowledge of Salesforce integration with hands-on SSIS development.
Is this person a sole contributor or part of a team
If so, please describe the team (Name of team, size of team, etc Pathway team, Dev - 20, QA - 10
What are the top 5-10 responsibilities for this position (Please be detailed as to what the candidate is expected to do or complete on a daily basis)
? Strong SSIS - ETL resource with 5 plus years of experience
? Experience working on SQL Server database writing SQL queries and stored procedures
? Experience integrating with Salesforce is a plus
? DevOps experience building and deploying SSIS packages via TFS
? Resource will be involved with 50% Development and 50% DevOps related work.
What software tools/skills are needed to perform these daily responsibilities
TFS, SSIS, SQL Server.
What skills/attributes are a must have
SSIS, TFS knowledge
Familiar with code migrations and branching strategy.
Good understanding of Stored procedures and Optimizing SQL queries.
Knowledge of Salesforce is plus.
Knowledge of Agile Methodology.
Knowledge of TFS and be able to manage release folders along with the ability to create builds and releases in the TFS dashboard to support the release folders.
What skills/attributes are nice to have
Good knowledge of ETL/SSIS development.
Good Problem solving skills.
Experience integrating with Salesforce.
Troubleshooting the problems related to Transact SQL.
Where is the work to be performed (Please list preferred Client facility, if other please specify i.e. remote work, rural, etc Client Facility at Optum Circle, Eden Prairie, MN
What are the work hours (ex. 9am-5pm, day/night shifts, rotating shifts, etc) 9am-5pm
What type of interview process is preferred (Face to face, phone, Skype, or a combination of the three) Phone interview followed by Face to face.