Job Description: Data Migration Architect (SQL / SSIS to Salesforce)

Role Overview

The Data Migration Architect will lead the end‑to‑end design, planning, and execution of data migration initiatives from SQL Server–based environments (including SSIS packages) into Salesforce. This role requires deep expertise in data architecture, ETL/ELT processes, SSIS optimisation, and Salesforce data models. The architect will define migration strategies, govern data quality, and ensure secure, compliant, and high‑fidelity movement of enterprise data into Salesforce.

Key Responsibilities

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 best‑practice migration frameworks including delta loads, reconciliation processes, and rollback strategies.

-
Define data quality, validation, and exception‑handling 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 effective handling of large datasets, including partitioning, batching, and API‑aware load strategies.

Salesforce Data Integration

-
Architect and implement data loading patterns using Salesforce APIs (Bulk, REST, SOAP), Data Loader, or MuleSoft where applicable.

-
Develop and document Salesforce object mappings, lookups, deduplication logic, and relationship reconstruction.

-
Ensure compliance with Salesforce governor limits, data volume restrictions, and performance constraints.

Data Governance & Quality Assurance

-
Define and implement data validation rules, reconciliation controls, and data quality scorecards.

-
Collaborate with business stakehold

📌 Data Migration Architect (Uttar Pradesh)
🏢 Sparix Global
📍 Uttar Pradesh