Data Migration Specialist

About MAXVAL:

MAXVAL started as an IP services company in 2004, with a keen focus on efficiency, cost-effectiveness, and continuous improvement through metrics-based processes. Our focus on these core values led to the tech-enablement of our offerings even before this buzzword became an industry standard. Over the years, MAXVAL developed many internal applications to increase our quality and efficiency, and customer satisfaction. As these systems grew and became more sophisticated, we have productized them and offered them to our clients. Today, MAXVAL serves over 600 clients across the full IP life cycle with the industrys leading products and services. Our 600 plus employees represent the most IP and tech-savvy individuals in the industry." At MAXVAL, we do the right things and innovate ceaselessly as a winning team to achieve customer success and employee success.

Summary:

As a Data Migration Specialist, you will play a crucial role in transferring data from

legacy systems to Symphony and Salesforce, ensuring data integrity, accuracy, and

security. You will work closely with cross-functional teams and contribute to both manual

and automated data migration processes. The role involves significant hands-on work

with Python, MS SQL, and Salesforce APIs to execute scalable, reliable migrations from

multiple data sources.

Key Responsibilities:

1. Data Analysis

• Assess source systems and Symphony to understand data structures, formats,

and requirements.

• Identify potential data quality issues and discrepancies requiring remediation.

2. Data Mapping

• Create detailed data mapping documents that define the relationship between

source data fields and Symphony/Salesforce fields.

• Document transformation rules in a clear and structured manner.

3. Data Extraction

• Extract data from various sources including CSV files, Excel files, SQL

databases, legacy systems, and APIs.

• Verify and validate data accuracy during extraction.

4. Data Transformation

• Perform data cleansing, standardization, format conversions, and enrichment.
• Apply transformation logic using SQL, Python, or ETL tools as required.

5. Data Loading

• Load transformed data into Symphony and Salesforce while maintaining data

integrity.

• Monitor data load processes, resolve errors, and optimize batch operations.

6. Data Validation

• Develop and execute validation rules and scripts to verify migrated data.
• Identify, document, and resolve data discrepancies post-load.

7. Testing

• Participating in system testing and User Acceptance Testing (UAT).
• Validate that migrated data meets business and functional requirements.

8. Collaboration

• Work with developers, business analysts, Salesforce teams, DBAs, and project

managers to support smooth migration workflows.

9. Automation & Python Development

• Design and automate ETL pipelines using Python (pandas, SQL alchemy,

requests, simple salesforce, etc.).

• Build scripts for data extraction, validation, reconciliation, and loading.
• Create automation tools to reduce manual effort and improve process efficiency.
• Implement robust error-handling, logging, and retry mechanisms.

10. Salesforce Data Integration

• Integrate with Salesforce using REST API, SOAP API, and Bulk API.
• Perform large-scale data loads while adhering to Salesforce governor limits.
• Understand Salesforce object relationships, constraints, and data architecture.

11. Database & Performance Optimization

• Work with MS SQL Server, including stored procedures, indexing, and

performance tuning.

• Write efficient SQL queries for extraction, transformation, and validation.

Qualifications and Skills:

• Bachelors degree in computer science, Information Technology, Data

Management, or a related field.

• Strong analytical and problem-solving skills.
• In-depth understanding of data migration concepts, methodologies, and best

practices.

• Strong SQL skills include complex queries, optimization, and performance tuning.
• Hands-on experience with Python for automation, ETL, and data processing.
• Familiarity with ETL tools or data migration frameworks (preferred).
• Experience working with MS SQL Server and relational databases.
• Experience with Salesforce data migration and APIs (preferred).
• Basic understanding of data security, compliance, and privacy principles.
• Excellent documentation, communication, and teamwork skills.
• Ability to manage time effectively and meet project deadlines.
• Adaptability and willingness to learn new tools and technologies.

Website Link: