Salesforce Data & File Migration Technical Lead Job Washington area,District of Columbia USA,Software Development

Role Summary

Salesforce Data & File Migration Technical Lead:
We are looking for a hands‑on Salesforce Data, File & Legacy Systems Migration Technical Lead to 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.

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…