FNZ

Data Migration Specialist (ETL/SSIS, Data Mapping)

FNZ
Apply
23 hours ago
Toronto, Canada or Vancouver, CanadaMid Level

Responsibilities

  • Create complex client-focused data mapping solutions aligned with client requirements, FNZ solutions, and the migration software development lifecycle.
  • Produce data models, data mapping definitions, and data validation rules for target products and migration requirements.
  • Design, create, and maintain SSIS packages for migrating data to FNZ databases.
  • Design and develop ETL workflows and reusable components using best practices.
  • Recommend and implement solutions for technical issues while meeting specifications, design, and non-functional requirements.
  • Support testing, resolve data issues, complete unit testing, and document ETL processes.
  • Provide post-implementation support to project and service and support teams for issue identification and resolution.
  • Analyze requirements and collaborate with internal and client subject matter experts.

Requirements

  • Strong relational database design experience with MS SQL Server.
  • Proficiency in data mapping and profiling techniques.
  • Experience using ETL tools such as SSIS and Informatica.
  • Experience working on Business Intelligence projects.
  • Strong analytical thinking and the ability to develop long-term technical solutions.
  • Ability to take initiative, communicate effectively with internal and external clients, prioritize workload, and meet aggressive deadlines with minimal supervision.

Tech Stack

InformaticaMicrosoft SQL Server

Categories

Data Engineering
FNZ

About FNZ

5,001-10,000 employees

FNZ builds an end-to-end wealth management platform that combines software with investment operations and custody for banks, insurers, and wealth/asset managers. Its B2B model spans platform licensing and outsourced administration under regulated frameworks. Founded in 2003 and headquartered in London, FNZ is backed by Caisse de dépôt et placement du Québec and supports over US$2.5 trillion in assets for nearly 30 million investors worldwide.

Contact me