ERP Data Migration Developer
Mississauga - Canada
Job Summary
Flynn is seeking an ERP Data Migration Developer to join the ERP project team at our Mississauga office and support a major enterprise ERP implementation. Reporting to the ERP Data Migration Lead this newly created role will work closely with business stakeholders ERP functional teams and Project Managers to support data conversions.
This role will focus on converting data from legacy systems into the target ERP solution by extracting cleansing transforming validating and loading master reference and transactional data.
- Partner with Business SME ERP BA and application teams on mappings rules and dependencies.
- Translate conversion requirements into reliable mapping transformation rules and data load solutions. Collaborate with various Business SME / Data Champions to document data conversion business rules.
- Develop and support repeatable ERP data conversion processes for extraction transformation validation and loading.
- Build and optimize transformations procedures pipelines reports and validation routines.
- Support master reference and transactional data conversion across ERPs and connected systems.
- Develop load files and support batch near-real-time API and middleware load patterns.
- Prepare and validate load files across mock and implementation of conversion cycles.
- Support mock conversions migration testing cutover rehearsals go-live readiness and stabilization.
- Monitor exceptions resolve load errors and support data clean-up with business SMEs.
- Perform profiling reconciliation duplication checks validation and cross-referencing for accurate migration.
- Support data quality metrics issue tracking trend monitoring and remediation follow-up.
- Document designs mappings transformation logic validation rules procedures and standards.
- Support large scale multi-entity ERP implementation spanning across North America.
Experience
- 7 years in ERP data conversion Data ETL and Integration or related BI / Data Warehouse technical role.
- 5 years large scale ERP experience with leading solutions such as Dynamics SL IFS Global INFOR and Dynamics 365.
- Strong SQL skills with SQL Server Oracle or similar relational databases.
- Hands-on experience with ETL tools pipelines batch loads and near-real-time data movement.
- Experience reconciling validating profiling cleansing and troubleshooting data.
- Experience working with the construction and/or building industries is desired.
- Knowledge of ERP data domains such as finance procurement inventory projects service or manufacturing would be an asset.
- Ability to work with business SMEs ERP teams data teams application teams and technical stakeholders.
- Strong documentation communication analytical and problem-solving skills.
- Able to work independently manage priorities and communicate with technical and non-technical audiences.
Qualifications
- Bachelors degree in Computer Science Information Systems or related field.
- Hands on experience in Microsoft Cloud technologies Fabric Azure Data Factory Data Pipelines Azure Dev Ops Purview.
- Familiarity with CI/CD GitHub version control and automated testing for data workflows.
- Experience with Python APIs cloud data platforms or integration of middleware such as Boomi and Workato.
- Proficiency on data visualization toolsis an asset(e.g. Power BIQlikView etc.)
- Solid knowledge of medallion architecture and data governance dataanalysisanddatacatalog tools ( Microsoft PurviewOracleeDQ Qlik Talendetc.)
- Proficiencyin database management systems (e.g. SQL DB Oracle DB etc.).
- Data governance certifications (CDGP CDMP) would be an asset.
- 5% estimated travel across North America during ERP implementation.
Required Experience:
IC
About Company
With 35 offices across the United States and Canada, Flynn is the leading commercial roofing, glazing, & cladding contractor in North America.