Database Administrator/Developer
Previous Job
Database Administrator/Developer
Ref No.: 16-04929
Location: Minneapolis, Minnesota
Position Type:Contract
Start Date / End Date: 07/27/2016 to 02/27/2017
 The components as a deliverable of this scope will be:
  • Data Mapping Documents – Field mapping from the legacy system data sources to the staging database and the data store, if necessary, then the target transactional database of the new Land Management System.
  • ETL Code - Documented, accurate code to load the data into the target databases.
  • Data Cleaning Requirement - Define data integrity/cleansing requirements for the transform process.
Primary Responsibilities:
  • Create accurate code using documented conversion specifications or using specification derived using reverse engineering techniques to load the data into the target database.
  • Conduct on site analysis of legacy system(s) and database(s) with the goal of producing the Data Mapping for the Extract process to support the Data Store and new system.
  • Writing or enhancing SQL queries to convert data into the target databases.
  • Work with users to ensure successful data conversion to the new system; may assist in user quality testing.
  • Create and update data verification plans, and expected outcomes, to be used for script runs.
  • Test all conversion programs in succession (assembly test) in order to identify and document programmatic dependencies.
  • Identify and resolve risks and issues related to data conversion activities.
  • Participate in routine meetings and documentation reviews.
  • Provide input for defining data integrity/cleansing requirements for the transform process.
  • Develop field mapping from the legacy system data sources to the target transactional databases.  Review and understand existing ETL code.
  • Modify ETL code to repair defects & bugs.
  • Communicate and finalize solutions with the user on decisions for data that may not be converted or may be altered in form, to the new system.
  • Identify new fields that may need to be created in new system for data not identified in the original configuration.
Required Experience/Knowledge:
  • 5+ years of IT Delivery Experience, including a recent role in data conversion.
  • 5 + years of experience supporting mission-critical implementation projects.
  • Solid knowledge and expertise in data conversion methods, tools, and procedures.
  • Strong communication skills with ability to effectively present information to technical and business audiences.
  • Proven experience with performing data analysis, data mapping and reporting data issues.
  • Experience in Microsoft SQL Server, Access, and other data sources.
Preferred Experience/Knowledge:
  • Experience in Oracle SQL
  • Experience in TSQL
  • Technical writing skills for business audiences
  • Experience with InfoSphere Information Server
  • Public Sector experience
Work Environment:
  • On site in office
  • Up to 40 hours per work for the duration of the services