Job Description :
Posting Title: IT - DAS - SSIS / ETL / Data Conversion Specialist /SQL DBA
Location: Columbus, OH
Interview Type: In person

Job description:
These positions will be part of a larger data conversion team that is responsible for extracting, manipulating and converting customer data from the legacy eLicensing system (CAVU) and preparing it to be loaded into the Salesforce eLicense system.

Job Duties:
Create detailed mapping between legacy and new system data elements,
Contact customers to verify business rules and/or clarify data analysis,
Identify problems and make recommendations on how to overcome any issue,
Perform data verification,
Ensure that data is migrated accurately,
Develop and run conversion programs and scripts,
Develop and modify SQL queries,
Documentation,
Provide post conversion support to answer questions and address problems if they arise,
Develop standardized procedures for common conversion routines to increase efficiencies,
Develop/maintain utility programs/scripts to automate common pre/post conversion tasks.

Mandatory Requirements/Time:
8-10 years of experience in large and complex enterprise data conversion projects - 5 million plus records,
8-10 years of programming concepts and skills,
8-10 years of experience writing, modifying and executing complex SQL queries,
Experience with Active Server Pages (ASP),
3-4 years of experience with SQL Server 2008 R2 creating SSIS Packages, writing stored procedures and complex queries, and data analysis
3-4 years of experience with Salesforce, Data Loader, Jitterbit a plus,
8-10 years analyzing Information, Problem Solving, Attention to Detail, Software Design, Software Debugging, Software Development Fundamentals
Strong oral and written communication skills

Required Soft Skills :
Strong communication/ leadership skills.
Strong influence, collaboration and negotiation experience.
Ability to collaborate with supporting resources across business and/or functional lines.
Have excellent oral and written skills/possess strong meeting and work session facilitation skills.
Have the ability to work independently and as part of a team, the ability to manage time and resources to meet assigned deadlines.
Have strong understanding of prioritization stemming from the elicitation of system and/or user equirements.
Have excellent organizational skills, proven analytical, planning, problem solving, and decision-making skills.

Desired Skills/Time:
Previous experience with professional licensing system, enforcement, and/or complaint management a plus