Job Title: Data Migration Developer
Job Type: Contract
Job Location: Hybrid with some travel
Overview
Support integration program by designing, developing, and executing automated data conversion and migration solutions. This role is primarily focused on migration activities, including data analysis, mapping, transformation, validation, and reconciliation between legacy and target platforms.
Working closely with business, IT, integration, and vendor teams, the developer will create repeatable migration processes, conversion utilities, and validation tools that enable accurate, traceable, and efficient movement of critical airline data. Additional work may extend to airline operational platforms such as crew, maintenance, flight operations, loyalty, and other enterprise systems.
Core Technologies
• Microsoft SQL Server
• T-SQL
• SSIS or comparable ETL tooling
• PowerShell
• Source control
Likely Data Domains
• Customers
• Reservations
• Inventory
• Schedules
• Fares
• Fees
• Ancillaries
• Loyalty
• Operational reference data
Working Model
• Hands-on development role supporting analysis, automation, testing, cutover, and reconciliation
Key Responsibilities
Data Analysis and Mapping
• Analyze source and target system data structures, schemas, interfaces, and business rules.
• Develop source-to-target mapping documents and transformation specifications.
• Perform data profiling, quality assessments, and gap analysis.
• Work with business and technical stakeholders to define migration requirements and conversion logic.
Data Migration Development
• Design, develop, and support automated data migration and conversion processes.
• Create and optimize SQL scripts, stored procedures, ETL processes, and migration utilities.
• Develop repeatable migration frameworks supporting multiple test and production migration cycles.
• Automate transformation, cleansing, enrichment, and validation activities.
Validation and Reconciliation
• Develop automated reconciliation and data quality checks.
• Validate migration accuracy, completeness, and data integrity.
• Investigate and resolve migration defects, exceptions, and discrepancies.
• Support testing activities, including mock conversions and user acceptance testing.
Integration and Cutover Support
• Participate in migration planning, rehearsals, and production cutover activities.
• Collaborate with application teams, vendors, and project stakeholders to resolve data issues.
• Support documentation, runbooks, and migration readiness reviews.
Required Qualifications
• 5+ years of experience in data migration, database development, ETL, or systems integration.
• Advanced SQL and Microsoft SQL Server development experience.
• Strong experience with T-SQL, stored procedures, views, functions, query optimization, data modeling, and performance tuning.
• Experience developing ETL or ELT solutions and data transformation processes.
• Experience with SQL Server Integration Services or comparable ETL tooling.
• Experience developing automation using SQL, PowerShell, Python, or similar technologies.
• Strong understanding of data mapping, data quality, validation, and reconciliation techniques.
• Excellent analytical, troubleshooting, verbal communication, and written communication skills.
Preferred Qualifications
• Experience with airline technology platforms and airline data models.
• Experience supporting Passenger Service Systems, preferably Navitaire New Skies or a similar reservation platform.
• Experience supporting mergers, acquisitions, or large-scale enterprise integration programs.
• Experience migrating reservation, customer, loyalty, inventory, fare, ancillary, and operational data.
• Experience with Azure SQL, Azure Data Factory, Microsoft Fabric, Power BI, MongoDB, REST APIs, or Azure DevOps.
• Familiarity with airline operational systems such as maintenance, crew scheduling, flight operations, and loyalty platforms.
Technical Skills Required:
• Microsoft SQL Server
• T-SQL
• SQL Server Management Studio
• SSIS
• ETL/ELT Development
• Data Modeling
• Data Reconciliation
• Git / Source Control
• PowerShell
Preferred
• Azure SQL
• Power BI
• Python
• MongoDB
• REST APIs
• Azure DevOps
Success Measures
• Deliver automated, repeatable migration processes.
• Achieve high levels of migration accuracy and reconciliation.
• Reduce manual effort through automation.
• Successfully support PSS and airline operational system migration activities.
• Produce high-quality migration documentation, validation evidence, and cutover support artifacts.
The projected hourly range for this position is $70 to $75.
On-Demand Group (ODG) provides employee benefits which includes healthcare, dental, and vision insurance. ODG is an equal opportunity employer that does not discriminate on the basis of race, color, religion, gender, sexual orientation, age, national origin, disability, or any other characteristic protected by law.