Job Description
Client is moving from legacy IFS ERP to Microsoft Dynamics 365, and they need a hands-on data conversion specialist to help us migrate our data cleanly and accurately.
\n
What You'll Do
\n
- \n
- Extract data from the legacy IFS ERP on a SQL database
- Write and tune complex SQL queries to pull, transform and reconcile data
- Cleanse the data: remove duplicates, standardize formats, fix gaps and validate it
- Map legacy data to D365 data entities and prepare load-ready files (Data Management Framework / data packages)
- Convert master and transactional data, including:
- Suppliers / Vendors
- Customers
- Products / Items
- Invoices (AP & AR)
- Purchase Orders
- Sales Orders
- Costs / Standard Costing
- Run mock conversions, reconcile record counts and balances, and support cutover
- Work with functional consultants and business users to resolve data issues
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
\n
What We're Looking For
\n
- \n
- Oracle SQL : strong skills in joins, CTEs, stored procedures and data manipulation
- Data migration / conversion: hands-on experience on ERP projects
- Microsoft Dynamics 365 F&O: experience preparing data for D365 (Finance & Operations or Business Central)
- IFS ERP: experience is a plus
- Business processes: understanding of procure-to-pay and order-to-cash data flows
- Data quality: detail-oriented, with solid data validation and reconciliation habits
- Communication: able to work with both technical and business teams
\n
\n
\n
\n
\n
\n
\n
\n
Nice to Have
\n
- \n
- SSIS, Azure Data Factory or other ETL tools
- Excel / Power Query for data validation
- D365 Data Management Framework (DMF) experience
\n
\n
\n
\n