Senior ETL Developer

About the Role

We are seeking an experienced
Senior ETL Developer

to lead the design and implementation of data migration from a Legacy Transportation Management System (TMS) to
McLeod TMS

. This role is critical to ensuring data integrity, accuracy, and performance throughout the migration process. You will work closely with business stakeholders, TMS subject-matter experts, and technical teams to deliver a reliable, repeatable, and scalable data migration solution.

Key Responsibilities

• Lead end-to-end
  ETL development

for migrating data from Legacy TMS to McLeod TMS, including extraction, transformation, loading, validation, and reconciliation.
- Design, build, test, and deploy ETL pipelines using enterprise tools and scripting to support complex transportation data structures.
- Develop detailed
data mapping, transformation rules, and migration logic

; document mapping artifacts and transformation log...