BPM/DB Consultant

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.