Data Migration Architect (SQL / SSIS to Salesforce)

Years of Experience 3+ years

Migration Architecture & Design

 Design and own the overall data migration architecture from SQL

Server sources into Salesforce.
 Analyse existing SQL/SSIS pipelines and define transformation logic,
mapping rules, and staging strategies.
 Establish bestpractice migration frameworks including delta loads,
reconciliation processes, and rollback strategies.
 Define data quality, validation, and exceptionhandling rules across the
migration lifecycle.
ETL/SSIS Development & Optimisation
 Review, enhance, and modernise SSIS packages to support required
transformations, performance standards, and governance policies.
 Implement data cleansing, enrichment, and harmonisation steps as
required for Salesforce compatibility.
 Ensure efficient handling of large datasets, including partitioning,
batching, and APIaware load strategies.