Data Migration Architect (Uttar Pradesh)

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

Role Overview

The Data Migration Architect will lead the endtoend design, planning, and execution of data migration initiatives from SQL Serverbased 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 highfidelity 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 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 productive handling of large datasets, including partitioning, batching, and APIaware 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 .