TRAX Aviation Data Migration Support
Budget / SalaryHourly project
TypeFreelance project
LocationRemote
Posted1 hour ago
I am kicking off a data-migration project that will move our TRAX aviation maintenance data into another aviation maintenance system. To begin, I want a paid proof of concept that focuses on a single aircraft, covering only its aircraft and component master records and retaining the current details for each record.
The scope for this first phase includes:
• Writing robust Oracle SQL extraction scripts against the TRAX source tables
• Designing clear source-to-target mappings for the new platform
• Building an ETL routine (your choice of tooling, as long as it can be automated and version-controlled)
• Running a trial load, then validating and reconciling counts and key attributes between source and target
I will supply schema information, sample data, and secure VPN access to both databases. A short findings report summarising load results and any data quality issues will complete the proof of concept. If this phase goes smoothly, there is significant follow-on work to migrate the remaining fleet and additional data domains.
Prior work with TRAX, Strong Oracle SQL and hands-on ETL development experience are must-haves; TRAX or other aviation MRO datasets will make onboarding faster. The role is fully remote and can start right away once we agree on the approach and timeline.
The scope for this first phase includes:
• Writing robust Oracle SQL extraction scripts against the TRAX source tables
• Designing clear source-to-target mappings for the new platform
• Building an ETL routine (your choice of tooling, as long as it can be automated and version-controlled)
• Running a trial load, then validating and reconciling counts and key attributes between source and target
I will supply schema information, sample data, and secure VPN access to both databases. A short findings report summarising load results and any data quality issues will complete the proof of concept. If this phase goes smoothly, there is significant follow-on work to migrate the remaining fleet and additional data domains.
Prior work with TRAX, Strong Oracle SQL and hands-on ETL development experience are must-haves; TRAX or other aviation MRO datasets will make onboarding faster. The role is fully remote and can start right away once we agree on the approach and timeline.
Apply on Freelancer →
Project sourced from Freelancer.com. Applications happen directly on the original platform — we never collect your data.