Convert data from flat and unstructured document file formats such as LDIF, CSV, MFVL, text and XML
Convert > 100 datatypes including EBCDIC and packed decimal, dates and numerics, UTF-16 Filter records and re-map layouts and perform basic data cleansing
Experience in importing data from ODBC libraries such as Oracle, DB2, MySQL and SQL Server
Data Cleaning to remove unwanted observations from your dataset, including duplicate observations or irrelevant observations, structural errors, unwanted outliers, missing data and validate through a rigorous QA process.
Data Archiving Inventory and determination of which data must be archived based on compliance regulations. Assignment of a retention schedule for each category. Development of an all-inclusive archive policy with proactive protection of the data archive's integrity and delivery of a data archive product that suits your needs.
Creation of Migration Plans including exploring and assessing the Source and how it fits within the target system. Design migration plans, conducting live tests and perform the actual migration as well as auditing the results.
Data Validation and Reconciliation including data sampling, validating the database and validation of the data format.
Migrate to Azure SQL using Sql Server Integration services (SSIS) with almost no downtime. Identify and mitigate migration issues using the Azure Migration Assistant to identify issues before they occur.