Data Migration Developer - ETL Tools

Data Migration Developer :

Experience : 7+ years

Location : Chennai (Work from Office/Work from Home)

Key Responsibilities :

- Handle pricing and configuration mismatches during migration and provide robust troubleshooting solutions.

- Design strategies for migrating bundle products where legacy standalone items map to bundled items

in the target system.

- Validate totals, configurations, and complex calculations post-migration to ensure data integrity.

- Perform Master Data Management (MDM) migrations including data deduplication using key columns or fuzzy logic.

- Implement attribute-level merge strategies for duplicate records.

- Conduct data cleansing activities, including VAT validation, address validation, and format standardization.

- Build and maintain ETL pipelines for data extraction, transformation, and migration. Willingness to learn Safe FME for advanced ETL tasks.

- Develop and utilize Python scripts for automation and data manipulation (knowledge preferred, willingness to learn required).

- Work with SOAP and REST APIs for data integration and validation, using Postman for testing.

- Utilize SQL for data querying, updates, merging, and aggregation operations.

- Work with data warehouses such as Snowflake (preferred).

- Collaborate with cross-functional teams to ensure data quality, accuracy, and smooth migration execution.

Required Skills and Experience :

- Hands-on experience in data migration, ETL, or data integration projects.

- Experience with data cleansing, validation, and deduplication processes.

- Proficiency in building data pipelines for ETL.

- Knowledge of SOAP/REST APIs and API validation tools (Postman).

- Experience in MDM data migration is required.

- I am willing to learn new ETL tools (Safe FME) and programming languages (Python).

Optional (Preferred) Skills :

- Working knowledge of Snowflake or other cloud data warehouses.

- Understanding Salesforce CPQ pricing, product bundles, and configuration rules.