Candidate must have excellent data analysis, technical analysis, problem solving and interpersonal skills. Preferably, candidate should have previous experience in designing, developing, maintaining, and executing ETL/data conversion routines for large, enterprise-scale systems. Candidate should be experienced with the Microsoft development stack and have very strong T-SQL and SQL Server skills. Knowledge of DoD Property Accountability, DoD Logistics is a plus. Candidate should be capable of multi-tasking, very detail-oriented, and accustomed to working in a fast-paced and dynamic work environment.
Essential Job Functions:
• Contacts customer to elicit and analyze data conversion requirements and schedule.
• Performs data mapping between current data elements and system standard conversion elements.
• Works with functionals and developers to understand and integrate business functionality into conversion code.
• Modifies, as necessary, existing data conversion routines and designs, develops, and tests new data conversion routines to meet customers’ conversion requirements using technologies including, but not limited to: T-SQL, SSIS, C#, VB.Net, MS Access, Excel, VBA
• Creates mock conversion data and performs test runs of the data conversion.
• Reads database diagrams and can easily determine existing database relationships and data integrity rules.
• Creates validation programs designed to check data in data files and edit data field content and ensure correctness in relation to other data in file.
• Executes validation program against conversion data. Sends error reports and supporting documentation to user to gain their input as to how to correct documented errors. Finds solutions to correct data errors.
• Submits completed data files for final validation check and then load to production environment.
• Performs post-conversion reconciliation to ensure that data was properly converted.
• Contacts users to notify of successful data conversion.
This position will be based in Camp Hill, PA. Candidate must be a team player with a willing attitude and possess strong interpersonal skills to be able to interact with team members and senior managers. Candidate must have excellent problem-solving skills and be able to perform independent analysis and complete assigned tasks with minimal supervision.
Position may require travel < 10%. Candidate must be eligible to obtain a security clearance.
*Required & DesiredEducation: A Bachelor of Science with a major in Computer Science or a related major is desired. Looking for 0-2+ years of experience.
Information Assurance DOD 8570.01-M certification of IAM Level 1 desired. CompTIA Security+ certification desired.
*Required Skills: Candidate shall be experienced with the following tools and technologies:
• SQL Server 2008/2008 R2/20122014 and Transact SQL (T-SQL)
• Visual Basic .Net
• Entity Framework/LINQ
• Microsoft Visual Studio
• Microsoft Team Foundation Server (TFS)
*Desired Skills: It is desired that the individual have an understanding of best commercial practices in information technology and have proven successful analytical ability with high visibility programs and the ability to assist with solution requirements.