Data Migration Lead Engineer

$166,400 - $197,600/Yr

EPAM Systems - Newtown, PA

Full-time

Remote - Newtown, PA

Professional, Scientific, and Technical Services

About the position

The Data Migration Lead Engineer will play a crucial role in guiding and supporting the migration of data from legacy systems to Salesforce Greenfield org. This temporary position, lasting 45 months, requires a highly experienced individual with a strong background in data migration, particularly using Talend and Salesforce. The role may involve travel, but fully remote work is also an option.

Responsibilities

• Coordinate and manage client data migration from legacy systems to SF Govt Cloud org.
• Collaborate with client team and solution architect to develop and maintain data migration scripts and solutions.
• Understand Sales Cloud, Service Cloud, and Government Cloud data models.
• Extract, transform, and load data using Salesforce data tools.
• Plan data sandbox activities and export object data from multiple Salesforce orgs.
• Map data between systems, perform data deduplication, and ensure data governance.
• Capture data migration requirements, planning, and deployment.
• Run data import tests and stay updated with data migration technology trends.
• Provide training and support to clients on data migration processes and procedures.
• Develop and maintain relationships with clients to ensure their data integration needs are met.
• Handle clients' sensitive data carefully per contract.

Requirements

• Extensive experience with Talend in data migration for Salesforce projects.
• Strong knowledge of Salesforce data model and administration.
• Practical knowledge of databases including complex queries, data export, and manipulation.
• Experience loading flat files (csv, txt, excel) to Salesforce.
• Proficiency in ETL/ELT tools, specifically Talend.
• Skills in data preparation for loading, including data cleansing and deduplication.
• Familiarity with data transformation techniques, including formulas, functions, and basic Java scripts.
• Experience with big data volume loads and resolving potential upload issues.
• Knowledge of query performance fine-tuning and optimization techniques.
• Experience with Bulk API and data archival processes and tools.
• Excellent communication and interpersonal skills.
• Ability to work collaboratively with various teams.
• Fluency in English.

Benefits

• Health benefits: High Deductible Health Plan with an attached HSA (Health Savings Account) including Pharmacy coverage after 60 days from start of employment.
• Condition Management resources.
• Family Planning resources.
• Dental Plan.
• Vision Plan.