Data Migration Developer

The Data Migration Developer will support the integration program by designing, developing, and executing automated data conversion and migration solutions. This role is primarily focused on Passenger Service System 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.

Primary Focus

• Passenger Service System data conversion and migration

Program Context

• Integration

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, and operational reference data

Working Model

• Hands-on development role supporting analysis, automation, testing, cutover, and reconciliation, 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., * 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.

• 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

4.04.0 out of 5 stars Minnesota Hybrid work $65 an hour, Pulled from the full job description

• Continuing education credits
• Health insurance
• 401(k) matching
• Vision insurance
• Dental insurance
• Paid sick time
• Life insurance, Hollstadt offers medical, dental, vision, life insurance, short-term disability, long-term disability, paid sick leave, and retirement benefits to eligible employees. With three different medical plans to choose from, you can enroll in the coverage you need from individual to family, or anywhere in between!

Remarketing Process

Hollstadt is based on retention and relationships. We get to know your strengths and career wishes throughout your assignment and then start remarket discussions 6-8 weeks prior to your end date. By being proactive, we are able to keep your down time between assignments as short as possible, unless you choose otherwise.

Professional Development

Hollstadt offers on-demand training through our consultant portal. Trainings give our consultants the continuing education they need to excel on their projects. Many of our courses apply towards continuing education credits and we have an entire training hub dedicated to upskilling in Artificial Intelligence (AI).

401k + Matching

One popular benefit is our 401(k) match on the first 4% of your contributions. Hollstadt wants to help you reach your long-term financial goals and understands that planning for your future is critical. Consultants also have access to support from a Financial Advisor.

Bonus Opportunities

We appreciate and reward loyalty. Join Hollstadt, stay for 5 years, and we’ll give you a $5,000 Longevity Award bonus! Additionally, we know great talent knows other great talent. If you are on contract with Hollstadt and refer one of your connections who gets placed, we’ll pay you $1,000!

Ongoing Support & Networking

We have made a significant investment in building a support program for our consultant team - so you never have to feel like you are going it alone. We also have a Consultant Coach program which acts like a ‘work buddy’ to provide a safe ear for questions or concerns at your client site.

Hollstadt Consulting is a management and technology consulting firm dedicated to placing professionals at engagements where they will excel. When you work with us, you’ll work with a refreshingly real company led and staffed by seasoned experts who are also down-to-earth, good people. We’re committed to treating you with respect and helping you achieve your career aspirations.

Since 1990, Hollstadt has been a trusted partner to more than 150 domestic and global companies and has successfully completed over 3,000 projects. Our continued growth has created challenging and rewarding opportunities for accomplished IT and Business Consultants. Hollstadt Consulting is an equal opportunity employer including disability/veteran.

By applying for this job, you agree to receive calls, AI-generated calls, text messages, or emails from Hollstadt Consulting and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to cancel at any time.