Data Migration Specialist (Contract)

4FMV

  • Toronto, ON
  • Contract
  • Full-time
  • 9 days ago
Our client, located near Union Station, is looking for a Data Migration Specialist for a 3 month contract. This is a Hybrid position - you will be expected to be in the office 2 times per week.Data Migration Development
  • Work under the direction of the Configuration and Implementation Manager on the successful delivery of multiple Data Migration projects and processes
  • Translate functional requirements into technical specifications for ETL development; Support the Data Consultant with developing Source-to-Staging-to-Target mappings and actively work with Development, Test and Implementation efforts
  • Work with the Data Migration team to identify the appropriate strategy that ensures the migration happens in the appropriate timeframe
  • Write validation scripts to run over the Staging tables to report any invalid data. Invalid data should be identified to the Data Consultant to address with the client.
  • Identify and test for bugs and bottlenecks in the ETL solution
  • Design data migration processes including collection of source data, data transfer mechanism and data upload mechanism
  • Execute data migrations incrementally and provide resulting data to the Data Consultants
  • Maintain appropriate levels of data security and privacy relating to customer data
Skills
  • Minimum 5-8 yearsu0027 experience on large scale data migration projects
  • Expert knowledge of Procedural SQL (Oracle, Postgres, SQL Server) and ETL development
  • Strong relational database design experience
  • Logical, clear and concise written and verbal communication skills
  • Excellent programming experience in writing Complex Stored Procedures, Queries, Views, User Defined Functions, Cursors and Common Table Expressions

4FMV