Overview
Skills
Job Details
Data Migration engineer
Onsite: Remote
Interview Process: 1-2 internal interviews; no client round expected
Must have experience/skills:
- Experience with enterprise scale migrations of ERP data to Salesforce
- Expert level skill with tools such as Salesforce Data Loader and Workbench
- SQL and SOQL expertise
We are seeking a Data Migration Engineer to lead the technical implementation of migrating ad sales orders and related data from a custom Oracle-based system to Salesforce. This role will be central to ensuring the accuracy, completeness, and reliability of migrated data and will collaborate closely with the Solution Architect, Technical Architect, and QA team.
The ideal candidate has deep experience in large-scale CRM or ERP data migrations, is comfortable working with complex data mappings, and thrives in fast-paced, enterprise environments.
Key Responsibilities
- Migration Planning & Execution:
- Design, develop, and execute ETL processes to migrate ad sales orders, accounts, opportunities, and line items into Salesforce.
- Collaborate with Solution and Technical Architects to define migration scope, mapping rules, and transformation logic.
- Data Quality & Reconciliation:
- Perform cleansing, deduplication, and normalization of legacy data prior to migration.
- Validate migrated data at record and field levels, ensuring accuracy against business requirements.
- Work with QA engineers to support reconciliation testing and defect resolution.
- Optimization & Troubleshooting:
- Identify and resolve migration bottlenecks, optimizing performance for large data sets.
- Provide technical documentation of migration processes, mapping, and transformation logic.
Qualifications
- Experience:
- 5+ years of experience in data migration, ideally for Salesforce or similar enterprise CRM systems.
- Strong knowledge of Oracle data models and relational database concepts.
- Proven experience with ETL tools (Informatica, MuleSoft, Talend, or similar).
- Experience in ad sales data or order management systems (preferred).
- Technical Skills:
- Advanced SQL and data transformation skills.
- Familiarity with Salesforce objects, schema, and bulk data APIs.
- Experience with large-volume data migrations (millions of records).
- Soft Skills:
- Strong analytical and problem-solving abilities.
- Clear communication skills for cross-functional collaboration.
- Detail-oriented and comfortable working with complex data sets under tight timelines.
Preferred Certifications
- Salesforce Data Architecture & Management Designer
- Informatica, MuleSoft, or other ETL platform certifications
- ITIL or Agile delivery methodology knowledge