Salesforce Data & File Migration Technical Lead

We are looking for a hands-on Salesforce Data, File & Legacy Systems Migration Technical Leadto lead complex enterprise data and document migration activities into Salesforce.

Hands-On Technical Leadership Expectation This role should be approximately
60–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
• Share Point
• 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.

• 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.

• 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.

• 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.

• 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…