Role Overview
We are looking for a BPM/DB Consultant with strong experience in IBM DB2, IBM BPM, XML data extraction, and Azure-based data migration. The consultant will be responsible for extracting legacy data, transforming XML-based information, and migrating data into Microsoft Dataverse/Dynamics.
Key Responsibilities
- Extract and analyze legacy data from IBM DB2 and IBM BPM systems.
- Parse and transform XML-based data into structured formats suitable for migration.
- Develop Azure Data Factory (ADF) pipelines for data staging and migration.
- Stage data using Azure SQL or Azure Blob Storage and load it into Microsoft Dataverse.
- Prepare detailed source-to-target mappings, including column mapping and data-type conversions.
- Perform data validation, reconciliation, and troubleshooting.
- Support Dataverse/Dynamics data migration and production deployment.
- Manage secure access using Service Principals and Azure Key Vault.
- Conduct migration testing across lower environments using appropriately masked production data when required.
- Validate migration results before production deployment.