Data Migration Specialist, ETL, SSIS, Data Mapping

FNZ Group

. Design and implement complex client-focused data mapping in line with the FNZ Migration SDLC .

Posted 9/23/2026full-timeToronto • CanadaMid-LevelSenior💰 CA$126,000 - CA$170,000 per yearWebsite

Core Competencies

Role fit

Core Competencies

Use this summary to align your resume positioning with the role.

Demonstrates expertise in designing and implementing complex data mapping solutions, with a strong focus on ETL processes and relational database design using MS SQL Server. Capable of managing migration projects end-to-end while providing effective communication and support to clients and internal teams.

Highest-signal resume keywords

Data MappingETL ProcessesMS SQL ServerSSISBusiness Intelligence

ATS Keywords

Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills

Data Mapping TechniquesRelational Database DesignETL Workflow DevelopmentData Validation RulesData Profiling

Soft Skills

Team CommunicationAnalytical ThinkingInitiativeWorkload PrioritizationClient Interaction

Tools & Technologies

SSISInformatica

Industry Keywords

Migration SDLCData ModelsTechnical Migration OutputsPost-Implementation SupportTesting Support

Tech Stack

Tools & technologies

ETLInformaticaMS SQL ServerSDLCSQLSSIS

About the role

Key responsibilities & impact

Design and implement complex client-focused data mapping in line with the FNZ Migration SDLC
Manage the end-to-end delivery lifecycle for migration projects
Design, develop, maintain and support Extract, Transform and Load (ETL) processes involving big data
Analyse requirements before designing and implementing solutions
Work with internal and client subject matter experts to provide complex data mapping solutions
Produce technical migration outputs, including data models, data mapping definitions and data validation rules
Design, create and maintain SSIS packages to migrate data to FNZ databases
Design and develop ETL workflows using best practices and reusable components
Provide solutions and recommendations for technical issues
Support testing, resolve data issues, complete unit testing and document ETL processes
Provide post-implementation support to project and service and support teams

Requirements

What you’ll need

Confident, and able to take initiative given client and delivery-focused environment
Good team communication skills, confident in dealing with internal and external clients
Highly developed written and oral communication skills
Strong relational database design experience working with MS SQL Server
Proficient in data mapping and profiling techniques
Experience in using ETL tools, e.g. SSIS, Informatica
Experience in working on Business Intelligence projects
Superior analytical thinking
Able to prioritise own workload and work to aggressive deadlines with minimal supervision