Data Migration Specialist

send resumes to selva@jjcpl.net

Position : Data Migration Specialist

Location : New York city NY

Duration : 6months +

Our Client is seeking a Data Migration Specialist to assist in the design and implementation of a vendor-supplied Special Education Student Information System (SESIS).  The Data Migration Specialist will focus on facilitating, analyzing and documenting the existing Client’s system data as it pertains to Special Education student. SESIS (Special Education Student Information System) is a COTS (Common Off The Shelf) vendor-supplied, configured and managed solution that will be used to track the full case-cycle of a student requiring Special Education Services within the New York City. Our client currently manages over 190,000 special education students in over 1500+ public schools.  Client currently tracks students using a mix of custom legacy solution and small distributed web applications.

The Data Migration Specialist will be responsible for, but not limited to, the following:

• Support the Vendor’s analysis of existing data feeds and current Client’s data systems, data conversion and integration solutions required to support SESIS business processes
• Analyze data in various applications, mapping the data between various Client source systems and ensuring the accurate importing of data to SESIS.
• Analyze, prepare and execute data cleansing services
• Support and perform User Acceptance Test activities for the SESIS Data Conversion, cleansing and integration solutions
• Ensure that proper documentation is captured, maintained, understood by and available to business and/or IT partners
• Escalate critical technical issues and potential problems as needed to the SESIS Project Manager to address any SESIS related issues in advance of deadlines

The selected candidate will work as a member of the SESIS deployment team reporting to the SESIS Project Manager.

Day-to-day responsibilities include:

• Participate in, or facilitate, business process and requirement sessions to ensure that the vendor fully understands the requirements and the data necessary to support those requirements
• Work with business analysts, business users and IT professionals to analyze and document the data as it exits
• Work closely with the various IT departments at our Client’s Company ensuring that their existing data conversion and integration needs within the system is met and that the integration solution is within the Client’s standards and guidelines
• Propose any refinements as needed to the existing documentation and standards
• Prepare, conduct and document focus group sessions as needed for information discovery

Required Skills

·         5+ year experience data migration projects and technologies

·         Demonstrated experience with Legacy (mainframe) Data migration and data cleansing efforts

·         Demonstrated experience in designing and documenting conversion and interface specifications

·         Demonstrated experience importing and exporting data from a variety of database applications

·         Demonstrated experience with data analysis and data mapping

·         2+ years experience with SQL, T-SQL, PL/SQL and DTS in SQL Server and Oracle

·         Experience with ETL and data quality tools like IBM’s Quality Stage products is a plus

·         Excellent analytical skills, detail and process-oriented

·         Proven ability to coordinate activities with business and technical teams

·         Excellent communication skills

Prior experience working on large IT vendor supplied COTS deployment projects for the Education or Government institutions preferred