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.