Job description:

Role Purpose: -
The purpose of this role is to design solution architecture for cross-system interactions and business logic integration, ensuring seamless interoperability across multiple applications.
Job Description: -
Role Summary: The Data Migration Engineer builds the extraction, transformation, and load (ETL) pipeline that moves customer data from up to six CRM sources into a staging layer and then into the recent ERP, implementing the matching and deduplication logic defined by the Lead Data Architect.
Key Responsibilities:
· Build CRM (multiple Salesforce instances and Pipedrive) → staging → ERP extraction and transformation pipelines for up to six source systems.
· Implement matching, deduplication, and survivorship logic technically, in close collaboration with the Lead Data Architect.
· Define data lineage between different CRM systems and ETL process
· Develop and execute data validation and reconciliation test plans to ensure data integrity post-migration.
· Partner with business teams during User Acceptance Testing (UAT),



translating technical data validation results into clear, business-friendly reports to build trust in the migrated data.
· Leverage generative AI for creating synthetic test data, optimizing ETL scripts, and documenting pipelines.
· Produce the clean, representative test dataset required for Q4 2026 UAT entry, and finalize it for Jan 1st, 2027.
· Produce the final production migration dataset for Q1 2027 cutover and contribute to project data quality KPIs.
· Build reconciliation and exception reports to surface unresolved data issues for the Business Data Steward.
· Develop catch process for any inconsistency post day 1 live with process for notification and validation.
· Create and maintain data dictionary and glossary for all the data transformations
Required Qualifications & Experience:͏-
Strong SQL and ETL development background ( possibly with Alteryx).
· Experience in performance tuning of ETL pipelines and large

📌 SAP ERP Data Migration Consultant (Pune)
🏢 Wipro
📍 Pune