Salesforce Data & File Migration Technical Lead

Yudrio Inc.; Washington (District of Columbia); Hybrid; USD 140,000 - 190,000; Full time

Job summary

Yudrio Inc. seeks a hands-on Salesforce Data & File Migration Technical Lead to guide enterprise data and document migration into Salesforce. The role blends 60–70% hands-on execution with 30–40% leadership, architecture, reviews, and coordination.

The ideal candidate will migrate data from Oracle, SQL Server, SharePoint, file repositories, AWS services, and legacy systems, and define migration architecture while performing analysis, development, testing, and cutover activities.

Qualifications

• 8+ years of data/integration experience and 5+ years in Salesforce data migration.
• Hands-on lead for complex migration initiatives with architectural oversight.
• Strong SQL and ETL/ELT design skills across Oracle, SQL Server, SharePoint, and cloud repos.

Responsibilities

• Own end-to-end migration strategy for Salesforce data and documents.
• Lead discovery, profiling, mapping, transformation, testing, and cutover.
• Provide technical leadership to developers, DBAs, AWS resources, and SMEs.
• Review scripts, mappings, and reconciliation processes; identify risks and blockers.

Skills

Salesforce

Data migration

ETL

SQL

AWS

Education

Bachelor's degree in Computer Science

Tools

Data Loader

Salesforce CLI

Job description

Salesforce Data & File Migration Technical Lead:

We are looking for a hands-onSalesforce Data, File & Legacy Systems Migration Technical Leadto lead complex enterprise data and document migration activities into Salesforce.Hands-On Technical Leadership ExpectationThis role should be approximately60–70% hands-on technical execution and 30–40% technical leadership, architecture, review, and coordination.

The ideal candidate should have strong experience migrating structured data and unstructured files/documents from a wide range of legacy platforms, including:

• Oracle databases
• SQL Server and other relational databases
• SharePoint
• Network and shared file repositories
• AWS-based repositories and services
• Legacy case management systems
• Mainframe or custom enterprise applications
• Document management systems
• On-premise databases
• Cloud-based applications and storage platforms
• Third-party and internally developed legacy systems

This is a hands-on Technical Lead role. The individual should be able to define the migration architecture, and personally perform analysis, development, troubleshooting, testing, validation, and cutover activities.

Key Responsibilities:

Technical Leadership

• Own the end-to-end technical strategy for Salesforce data and document migration.
• Lead source-system discovery, data profiling, mapping, transformation, development, testing, reconciliation, and production cutover.
• Provide technical leadership to Salesforce developers, ETL developers, data engineers, DBAs, AWS resources, integration teams, and business SMEs.
• Review migration scripts, ETL jobs, mappings, transformation rules, technical designs, and reconciliation processes.
• Identify migration risks, dependencies, performance issues, data-quality problems, and blockers.
• Serve as the primary technical escalation point for migration-related issues.

Hands-On Data Migration

• Personally perform migration analysis, development, troubleshooting, testing, and validation.
• Extract and analyze data from Oracle, SQL Server, SharePoint, APIs, legacy systems, flat files, and custom applications.
• Build or review SQL queries, ETL jobs, scripts, APIs, and automated migration processes.
• Perform data profiling to identify missing, duplicate, invalid, inconsistent, or incomplete records.
• Develop transformation logic between source-system data structures and Salesforce objects.
• Troubleshoot Salesforce data-load failures, lookup dependencies, relationships, validation rules, automation conflicts, and API issues.

ETL & Data Integration

• Design and implement enterprise ETL/ELT solutions supporting Salesforce migration.
• Develop extraction, transformation, and loading processes across multiple source systems.
• Create reusable and repeatable ETL frameworks for large-scale migration activities.
• Implement data cleansing, normalization, enrichment, validation, and exception handling.
• Support incremental loads, delta migrations, full loads, and production cutover loads.
• Implement logging, monitoring, error handling, restartability, and reconciliation within ETL processes.
• Optimize ETL jobs for performance and high-volume data processing.
• The Technical Lead should understand when to use each migration approach based on data volume, performance, security, automation, and operational requirements.

Legacy Systems Migration

• Assess data structures and business rules across multiple legacy platforms.
• Analyze poorly documented or undocumented legacy applications.
• Develop extraction strategies when standard APIs or interfaces are unavailable.
• Work with data originating from databases, spreadsheets, CSV, XML, JSON, flat files, APIs, and custom applications.
• Design migration approaches for historical data with complex relationships and legacy identifiers.
• Maintain traceability between source-system records and Salesforce target records.

SharePoint & Document Migration

• Analyze SharePoint sites, libraries, folders, metadata, document structures, and business relationships.
• Define how legacy documents should map to Salesforce records.
• Extract documents and metadata from SharePoint and other enterprise repositories.
• Handle duplicate documents, inconsistent folder structures, missing metadata, versioning, and orphaned files.
• Preserve appropriate document metadata and business relationships.
• Validate document counts, metadata, file integrity, and Salesforce record associations after migration.

Database Migration

• Analyze Oracle, SQL Server, PostgreSQL, MySQL, and other relational database schemas.
• Understand tables, relationships, keys, constraints, and historical structures.
• Develop complex SQL queries for extraction, profiling, reconciliation, and validation.
• Handle complex parent-child relationships and referential integrity.
• Translate normalized or legacy relational data structures into Salesforce object models.

Salesforce Data Migration

• Define source-to-target mappings between legacy platforms and Salesforce.
• Understand Salesforce objects, relationships, record types, external IDs, lookups, master-detail relationships, and ownership.
• Determine migration sequencing and dependencies across related Salesforce objects.
• Support high-volume migration using Bulk API, Data Loader, Salesforce CLI, ETL tools, APIs, and custom frameworks.
• Design approaches for maintaining source-system IDs and migration traceability.
• Validate Salesforce records against source-system data.

AWS & Cloud Integration

• Work with AWS services supporting migration and integration.
• Experience with AWS S3, Lambda, API Gateway, Glue, and related services is preferred.
• Design scalable approaches for processing and moving large volumes of data and documents.
• Troubleshoot integrations between Salesforce, AWS, databases, ETL tools, and legacy applications.

Data Mapping & Transformation

• Lead source-to-target data mapping workshops.
• Define transformation, normalization, cleansing, enrichment, and defaulting rules.
• Identify source fields that do not have direct Salesforce equivalents.
• Recommend appropriate Salesforce target designs.
• Maintain detailed mapping specifications and transformation documentation.
• Ensure technical and business approval of critical migration decisions.

Data Quality, Validation & Reconciliation

• Establish comprehensive migration-validation and reconciliation processes.
• Compare source and target record counts.
• Perform field-level validation for critical data elements.
• Validate parent-child and cross-object relationships.
• Identify missing, duplicate, failed, or incorrectly transformed records.
• Develop automated reconciliation and exception reports.
• Validate document counts, metadata, and file integrity.
• Ensure migrated data can be traced back to its original source system.
• Provide evidence that migration completeness and accuracy requirements have been met.

Required Qualifications

• 8+ years of overall data, integration, or enterprise application experience.
• 5+ years of hands-on Salesforce data migration experience.
• Experience acting as a Technical Lead for complex migration initiatives.
• Strong Salesforce platform knowledge.
• Strong SQL skills.
• Strong experience with Oracle, SQL Server, or comparable enterprise databases.
• Strong ETL/ELT design and development experience.
• Hands-on experience with Salesforce Data Loader.
• Hands-on Salesforce CLI experience.
• Experience with Salesforce Bulk API and REST/SOAP APIs.
• Experience migrating from SharePoint or enterprise document repositories.
• Experience migrating from legacy/custom enterprise applications.
• Experience developing or reviewing migration scripts using SQL, Python, Java, Apex, shell scripting, or similar technologies.
• Experience with AWS or another major cloud platform.
• Strong knowledge of data profiling, cleansing, transformation, mapping, validation, and reconciliation.
• Experience with large-volume structured and unstructured data migrations.
• Strong troubleshooting and root-cause-analysis skills.

Preferred Qualifications

• Salesforce Government Cloud experience.
• Salesforce Service Cloud and/or Experience Cloud experience.
• Public Sector or government project experience is a strong plus.
• Federal government experience is a plus.
• Experience with government case-management or claims-processing systems.
• Experience working in highly regulated environments.
• SharePoint-to-Salesforce migration experience.
• Oracle-to-Salesforce migration experience.
• AWS-to-Salesforce integration experience.
• Experience with enterprise ETL platforms such as Informatica, MuleSoft, Talend, AWS Glue, DataStage, Boomi, or SSIS.
• Experience with enterprise document-management platforms.
• Experience with large-scale production migration cutovers.
• Experience designing automated migration and reconciliation frameworks.