Salesforce Data Migration-Lead

We are seeking an experienced Salesforce Data Migration Specialist with 8+years of exp, to lead and execute complex data migration initiatives. In this role, you will be responsible for extracting data from legacy systems, transforming and cleansing it, and securely loading it into the Salesforce platform. You will work closely with integration architects, business stakeholders, and development teams to ensure data integrity, optimal performance, and a seamless transition of enterprise records.

Key Responsibilities

• Migration Strategy & Architecture: Design and execute scalable, end-to-end data migration strategies across Sales Cloud, Service Cloud, PRM, ARM, custom objects, and Data Cloud for enterprise clients.
• Agentforce & AI Data Readiness: Ensure legacy and transactional data is cleansed, standardized, and vectorized (RAG-ready) to support Agentforce Reasoning Engine, action triggers, and grounding context.
• Data Extraction & ETL/ELT: Extract data from legacy databases (SQL Server, Oracle, PostgreSQL, Snowflake) and transform it to meet target Salesforce and Data Cloud schema standards.
• Field & Relationship Mapping: Map complex source-to-target entity relationships (Master-Detail, Lookups, Junction Objects, Polymorphic fields) while preserving legacy record IDs and external IDs.
• Unstructured Data Ingestion: Prepare unstructured data assets (PDFs, knowledge articles, case histories) for migration into Data Cloud to power Agentforce retrieval workflows.
• High-Volume Execution & Automation: Leverage Salesforce APIs (Bulk API 2.0, REST/SOAP) and ETL/Zero-Copy tools to process millions of records without exceeding platform governor limits.
• Validation, QA & Governance: Create automated verification checks to reconcile post-migration record counts, relationship trees, deduplication rules, and Salesforce Einstein/Agentforce Trust Layer compliance.

Required Technical Skills & Qualifications

• Salesforce Expertise (5+ yrs): Strong hands-on experience with core Salesforce architecture, data security model, governor limits, and data import/export utilities.
• AI & Agentforce Data Concepts: Working understanding of Salesforce Agentforce, Atlas Reasoning Engine context grounding, RAG (Retrieval-Augmented Generation), vector databases, and how dirty data impacts AI agent decisions.
• Data Tools Mastery: Advanced experience with Salesforce Data Loader, MuleSoft, Jitterbit, Talend, Informatica Cloud (IICS), or Workbench.
• Data Cloud & Data Lakehouses: Practical knowledge of Salesforce Data Cloud ingestion, Data Streams, Identity Resolution, and Zero-Copy architecture (e.g., Snowflake, BigQuery integrations).
• SQL & SOQL: Advanced proficiency in writing complex SQL queries, stored procedures, joins, and SOQL/SOSL queries.
• Scripting/Programming: Hands-on capability in Python, Shell scripting, or Apex for custom data transformation and pre-migration sanitization.

Preferred Experience & Certifications

• Certifications:
• Salesforce Certified Data Cloud Consultant (Required / Highly Preferred)
• Salesforce Certified Administrator or Integration Architect
• Salesforce Agentforce / AI Specialist Certification
• Experience in complex Org-to-Org consolidations or migrating legacy knowledge bases to Salesforce for AI consumption.
• Familiarity with Model Context Protocol (MCP) or external API integrations for AI agent actions.
• Experience working in Agile/Scrum delivery environments.