✨ AI Summary
The Salesforce Data Migration Architect is responsible for defining and owning the end-to-end migration architecture for a large-scale Salesforce transformation program. This role requires extensive experience in data migration strategies, Azure Data Factory, Salesforce integration patterns, data governance, performance optimization, and cutover planning. The ideal candidate will have over 12 years of IT experience, with at least 5 years focused on Salesforce programs and Azure Data Engineering/Migration. Experience with large-scale Salesforce migration programs and managing terabytes of enterprise data is crucial.
Key responsibilities include designing scalable migration solutions using Azure Data Factory, defining source-to-target data mapping, architecting high-volume bulk migrations into Salesforce, and establishing robust data quality, cleansing, and reconciliation frameworks. The architect will also define migration waves, cutover strategies, and establish migration governance and best practices, while driving performance optimization for multi-terabyte datasets. Collaboration with Salesforce Architects, Business Teams, and Azure Platform teams, along with leading risk assessment and mitigation planning, is expected. Adherence to security, compliance, and audit requirements is mandatory.
Requirements
The Salesforce Data Migration Architect will own the end-to-end migration architecture for a large-scale Salesforce transformation program. Key responsibilities include defining migration strategies, Azure Data Factory architecture, Salesforce integration patterns, data governance standards, performance optimization, and cutover planning. Mandatory skills include strong Salesforce platform architecture knowledge, experience with Standard and Custom Objects, Salesforce Data Architecture, Bulk API, Integration Patterns, and experience in Salesforce Transformation Programs. Azure skills required are Azure Data Factory (ADF), Azure Data Lake Storage, Azure SQL/Synapse, and monitoring/performance tuning of ADF pipelines. Extensive experience in large-scale data migration (>1 TB preferred), data reconciliation, data quality management, ETL/ELT design, and migration cutover management is essential.
Description
Role SummaryThe Salesforce Data Migration Architect will own the end-to-end migration architecture for a large-scale Salesforce transformation program involving terabytes of enterprise data. The role is responsible for defining migration strategies, Azure Data Factory architecture, Salesforce integration patterns, data governance standards, performance optimization, cutover planning, and overall migration governance.Key ResponsibilitiesDefine enterprise-wide Salesforce data migration architecture.Design scalable migration solutions using Azure Data Factory.Define source-to-target data mapping strategy.Architect high-volume bulk migration mechanisms into Salesforce.Design data quality, cleansing, and reconciliation frameworks.Define migration waves and cutover strategy.Establish migration governance and best practices.Drive performance optimization for multi-terabyte datasets.Review Salesforce object model and migration dependencies.Collaborate with Salesforce Architects, Business Teams, and Azure Platform teams.Lead migration risk assessment and mitigation planning.Ensure adherence to security, compliance, and audit requirements.Mandatory SkillsSalesforceStrong understanding of Salesforce platform architecture.Experience with Standard and Custom Objects.Knowledge of Salesforce Data Architecture.Salesforce Bulk API and Integration Patterns.Experience in Salesforce Transformation Programs.AzureAzure Data Factory (ADF)Azure Data Lake StorageAzure SQL / SynapseMonitoring and performance tuning of ADF pipelinesData MigrationLarge-scale data migration experience (>1 TB preferred)Data reconciliationData quality managementETL/ELT designMigration cutover managementExperience12+ years overall IT experience5+ years Salesforce programs5+ years Azure Data Engineering/Data MigrationAt least 2 large-scale Salesforce migration programsCogAE106