Data Migration Analysts

Location: Chalk River, ON
Date Posted: 25-08-2017
  • Migrate data from spreadsheets and other sources into an environmental data management system using enterprise class COTS (Commercial Off The Shelf) software
  • Execute enterprise class workflows for data migration
  • Cleanse and transform data to prepare it for migration, using ETL (Extract, Transform, Load) principles and practices, Microsoft’s SSIS toolset, Excel, and any other tools the team selects
  • Interact with clients to resolve issues related to data migration
  • Generate reports and documentation that reflect the status of migration data and activities, and the environmental database
  • Configure enterprise software
  • Attend status meetings, submit periodic status reports and weekly timesheets
  • Train users in the operations, processes, templates and workflows used to put new environmental data into the system. Provide help desk like support to end users

  • 3 + years of experience Ensuring data is cleansed and transformed as to Data Mapping
  • Experience in the migration of large volumes of data
  • Experience in updating system data in support of data migration
  • Experience with automated workflows and scripts
  • Experience with SSIS configuration and automated scripts
  • Experience with the creation of data migration reports and documentation
  • Experience defining and executing functional, performance and user acceptance tests
  • Experience implementing software using Agile methodologies, processes and tools
  • Implementing software using Rapid Application Development (RAD) methodologies
  • Experience developing for mobile devices and environments and software, tools and processes, including:
    • VMWare environments
    • Microsoft SQL Server, SSIS, SSMS, SSRS
    • ArcGIS from ESRI, GIT, XML
  • Must be eligible for Government of Canada Enhanced clearance at a Minimum
DURATION:  11 Months + Possible Extension
this job portal is powered by CATS