Job Description

ONCORE CONSULTING LLC IS LOOKING FOR AN EXPERIENCED CONSULTANT TO JOIN OUR TEAM. THIS ROLE IS FOR A FULL-TIME EMPLOYEE, OR WE WILL CONSIDER A CONTRACTOR WITH THE EXPERIENCE, SKILLS AND FOCUS ON CUSTOMER DELIVERY WE DO AS A COMPANY. WE ARE SEEKING A CONVERSION DEVELOPER TO BECOME AN INTEGRAL PART OF OUR TEAM! IF YOU VALUE TREATING EMPLOYEES AS FAMILY, DELIVERING EXCEPTIONAL CLIENT SERVICE AND GIVING BACK TO THE COMMUNITY, GROW YOUR CAREER WITH US.

POSITION DESCRIPTION: As a SQL Server Data Conversion Developer, you will be responsible for maintaining, updating and running data conversion programs supporting the project data needs. These programs convert more than 2 billion records into approximately 180 different tables that support our new retirement system. We are currently in the testing phase of the project.

POSITION RESPONSIBILITIES:

• Analyzing, fixing and testing data conversion defects
• Designing and implementing enhancements and changes to the existing data conversion programs
• Documenting conversion logic in our data conversion mapping tools
• Analyzing and eliminating data conversion fallout
• Running the conversion programs that produce test data that can be used to test the application, reports and batch programs
• Some after-hours or weekend time may be necessary to monitor and support the production of data, but this time is minimal and spread across the conversion team

ESSENTIAL SKILLS:

• Excellent written and verbal skills
• Working knowledge of Microsoft Office products (Word, Excel, Visio, etc.) 2010 or later
• 5 years of data analysis, data fix, or data conversion experience
• 5 years of SQL experience
• 1 Year of SSIS experience
• Ability to work with analysts, testers, and application development to diagnose, resolve and test defects
• Ability to work independently or with a small group to analyze and fix defects

DESIRED SKILLS:

• Retirement business experience is greatly desired
• Experience with Microsoft SQL Server Management Studio (SSMS)
• Experience with Microsoft Visual Studio
• Experience with performance tuning Microsoft SQL Server queries and processes
• Experience with version control software such as Team Foundation Server

Company Description

Oncore Consulting, LLC is an equal opportunity employer committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or other protected characteristics outlined by federal, state, or local laws. Headquartered in Sacramento, California, OnCore Consulting is a leading provider of IT consulting services for the public sector in California. We are a rapidly growing organization that provides services and solutions across all facets of IT, including project management, technical architecture, software development and testing, system implementation, etc. Check us out at: https://www.oncorellc.com/