Description

Key Responsibilities

Data Migration Leadership

• Lead enterprise-scale Salesforce and Azure data migration initiatives.
• Define migration strategies, cutover plans, reconciliation approaches, and rollback mechanisms.

Manage end-to-end migration of:

1. Salesforce data between multiple Salesforce orgs
2. Legacy applications to Salesforce
3. On-premises databases to Azure
4. Structured and unstructured data repositories

Oversee migration of large data volumes, including attachments, content documents, files, and large objects.

Salesforce Data Architecture

• Design Salesforce data models and data migration frameworks.
• Lead Salesforce Org-to-Org migration projects.
• Define object mapping, transformation rules, and migration sequencing.
• Work with Salesforce Data Loader, Bulk API, Data Import Wizard, and third-party migration tools.
• Ensure data quality, integrity, and governance throughout migration activities.

Azure Data Engineering & Integration

Design and implement integration solutions using Azure services.

Work with:

1. Azure SQL Database
2. Azure SQL Managed Instance
3. Azure Data Factory (ADF)
4. Azure Blob Storage
5. Azure Functions
6. Logic Apps
7. Azure Data Lake

Define scalable ETL/ELT architectures.

• Establish data synchronization and data replication strategies.
• Database Design & Data Modeling

Create and maintain:

1. ER Diagrams (ERDs)
2. Logical data models
3. Physical data models
4. Data lineage documentation

• Develop and optimize SQL and PL/SQL scripts.
• Perform performance tuning and database optimization.

Define data archival and retention strategies.

File & Large Object Migration

Lead migration of:

1. Attachments
2. Content libraries
3. SharePoint documents
4. Blob storage repositories
5. Images, PDFs, and other large objects

Define metadata preservation, indexing, and retrieval strategies.

Ensure integrity and completeness of migrated file assets.

ETL & Data Transformation

• Design and oversee ETL pipelines and data transformation frameworks.
• Define source-to-target mappings and transformation logic.
• Lead data cleansing, deduplication, enrichment, and reconciliation activities.
• Automate migration and validation processes using scripts and tools.

Data Governance & Quality

• Define data quality KPIs and reconciliation measures.
• Lead mock migrations, dress rehearsals, and production cutovers.
• Ensure regulatory, security, and compliance requirements are met.

Leadership & Stakeholder Management

• Lead cross-functional teams including architects, developers, analysts, vendors, and business stakeholders.
• Provide technical mentoring and guidance to data engineers and migration specialists.
• Present migration plans, risks, and status updates to executive leadership.
• Drive issue resolution and risk mitigation throughout the migration lifecycle.

Required Qualifications

• Bachelor's degree in Computer Science, Information Systems, Engineering, or related field.
• Master's degree preferred.

Experience

• 15+ years of experience in Data Management, Data Migration, and Data Integration.
• 8+ years working with Salesforce data architecture and migration.
• 8+ years working with Microsoft Azure data platforms.
• Should have experience working with Databricks, Kafka , MuleSoft and Integration Middleware tools.
• Proven experience leading enterprise-scale migration programs involving millions of records and large file repositories.
• Demonstrated experience leading distributed teams and vendor partners.

Technical Skills

• Salesforce
• Salesforce Data Loader
• Bulk API
• Salesforce Sales Cloud
• Service Cloud
• Salesforce Metadata API
• Salesforce Org-to-Org Data Migration
• Field Mapping & Data Transformation
• Microsoft Azure
• Azure SQL Database
• Azure SQL Managed Instance
• Azure Blob Storage
• Azure Data Factory (ADF)
• Azure Data Lake
• Azure Functions
• Logic Apps
• Databases
• SQL Server
• Oracle Database
• PL/SQL
• T-SQL
• Data Modeling
• Entity Relationship Diagrams (ERD)
• Logical Data Models
• Physical Data Models
• Data Lineage
• Master Data Management (MDM)
• Integration & ETL
• ETL/ELT Frameworks
• Data Mapping
• Data Quality Tools
• API Integrations
• Middleware Platforms
• Automation
• PowerShell
• Python
• Shell Scripting
• Automation Frameworks

Preferred Qualifications

• Salesforce Administrator Certification
• Salesforce Platform App Builder Certification
• Salesforce Data Architect Certification
• Microsoft Azure Data Engineer Associate (DP-203)
• Azure Solutions Architect Expert
• Experience with Informatica, Talend, MuleSoft, or similar ETL platforms.
• Experience with MDM implementations and customer master data migration.
• Experience in large-scale digital transformation or cloud migration programs

Key Skills

Education

Bachelor's or Master's degrees