Data Migration Developer
Hollstadt & Associates
Get more replies from employers
Send a job-specific resume in minutes.
Benefits offered by this job
Job summary
Hollstadt Consulting is seeking a Data Migration Developer to design, develop, and execute automated data conversion and migration solutions. You will focus on Passenger Service System migration activities, performing data analysis, mapping, transformation, validation, and reconciliation between legacy and target platforms.
The role collaborates with business, IT, and vendor teams to create repeatable migration processes and validation tools, with potential expansion to other airline data
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.
Responsibilities
- 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.
- 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.
- 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.
- 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.
Skills
Tools
Job description
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.
Data Migration Developer
Hybrid - Las Vegas, NV
6 months (extensions as needed)
$65/hour W2
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.
- Passenger Service System data conversion and migration
- Integration
- Microsoft SQL Server, T-SQL, SSIS or comparable ETL tooling, PowerShell, source control
- Customers, reservations, inventory, schedules, fares, fees, ancillaries, loyalty, and operational reference data
- Hands-on development role supporting analysis, automation, testing, cutover, and reconciliation
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Microsoft SQL Server
- T-SQL
- SQL Server Management Studio
- SSIS
- ETL/ELT Development
- Data Modeling
- Data Reconciliation
- Git / Source Control
- PowerShell
- Azure SQL
- Power BI
- Python
- MongoDB
- REST APIs
- Azure DevOps
- 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.
- Medical
- Dental
- Vision
- Life insurance
- Short-term disability
- Long-term disability
- Paid sick leave
- Retirement benefits
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.
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).
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.
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!
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.
'/%3e%3cpath%20d='M101.744%2012.4726L102.894%2016.1947L99.0021%2013.2201L101.744%2012.4726ZM105.3%208.40937H100.488L99.0026%203.59473L97.5116%208.41047L92.7%208.40385L96.5965%2011.3834L95.1055%2016.1942L99.0021%2013.2196L101.408%2011.3834L105.3%208.40992V8.40937Z'%20fill='white'/%3e%3cdefs%3e%3clinearGradient%20id='paint0_linear_5593_1381'%20x1='90'%20y1='9.44471'%20x2='99'%20y2='9.44471'%20gradientUnits='userSpaceOnUse'%3e%3cstop%20stop-color='%2300AD70'/%3e%3cstop%20offset='0.998594'%20stop-color='%2300B67A'/%3e%3cstop%20offset='1'%20stop-color='%23DCDCE6'/%3e%3c/linearGradient%3e%3c/defs%3e%3c/svg%3e){kind=small}
