12 Sep
|
JRD Systems
|
Bengaluru
12 Sep
JRD Systems
Bengaluru
Job DescriptionRole Summary:
NThe 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 new ERP, implementing the matching and deduplication logic defined by the Lead Data Architect.
NKey Responsibilities:
N
- n
- Build CRM (multiple Salesforce instances and Pipedrive) → staging → ERP extraction and transformation pipelines for up to six source systems. N
- Implement matching, deduplication, and survivorship logic technically, in close collaboration with the Lead Data Architect. N
- Define data lineage between different CRM systems and ETL process N
- Develop and execute data validation and reconciliation test plans to ensure data integrity post-migration. N
- 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. N
- Leverage generative AI for creating synthetic test data, optimizing ETL scripts,
and documenting pipelines. N
- Produce the clean, representative test dataset required for Q4 2026 UAT entry, and finalize it for Jan 1st, 2027. N
- Produce the final production migration dataset for Q1 2027 cutover and contribute to project data quality KPIs. N
- Build reconciliation and exception reports to surface unresolved data issues for the Business Data Steward. N
- Develop catch process for any inconsistency post day 1 live with process for notification and validation. N
- Create and maintain data dictionary and glossary for all the data transformations N
nRequired Qualifications & Experience:
N
- n
- Solid SQL and ETL development background ( possibly with Alteryx). N
- Experience in performance tuning of ETL pipelines and large-scale database operations. N
- Strong Salesforce data model, SFDC API, and multi-instance Salesforce migration experience N
- Prior experience on at least one
📌 Hiring: Etl Data Migration Engineer (Bengaluru)
🏢 JRD Systems
📍 Bengaluru