Pierian Services - Data Migration Developer - ETL Tools

Description :

Data Migration Developer.

Experience 7+years.

Location Remote.

Key Responsibilities :

• Strategize and execute complex data migrations, ensuring accurate preservation of legacy data structures and pricing models.
• 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 :

Optional (Preferred) Skills :

(ref : hirist.tech)