Flight Booking Engine Completion

Project Overview

We are developing a flight booking system built with React (frontend), Node.js + Express (backend), and Microsoft SQL Server (database). The project is ~70% complete.

The application already connects with Galileo GDS and consumes JSON APIs for flight availability and pricing.

We need an experienced engineer to finish the remaining functionality, specifically around results filtering, passenger input, booking persistence, and PNR workflows.

Previous hands-on experience with Galileo/Travelport GDS JSON APIs is mandatory.


---

Responsibilities

Flight Search Form

Complete search flow (origin, destination, Google calendar picker for dates, passenger details).

Implement robust field validation with clear error handling.


Flight Results Page

Integrate search results from Galileo GDS JSON responses.

Implement filters for:

Airlines

Departure/arrival times

Fare types (refundable / non-refundable)

Stops & duration


Add sorting (price, airline, time).

Ensure filters match UI requirements.


Flight Modify Form

Allow users to modify search and re-query GDS without breaking flow.


Passenger Page

Capture passenger details (PII validation).

Re-confirm flight availability and fare with Galileo before proceeding.

If fare changes → alert user → require confirmation to continue.


Payment & PNR

On payment success, generate PNR using Galileo GDS APIs.

Store booking, passenger details, and PNR in MSSQL.

Implement transaction-safe DB persistence (rollback on failure).


Notifications

Send confirmation email + SMS to customer and business once PNR is generated.

Emails include itinerary, PNR, pricing, and passenger details.


Testing

Implement unit, integration, and end-to-end tests.

Cover entire flow: search → filter → select → passenger → payment → PNR → notifications.




---

Tech Stack

Frontend: React (hooks, functional components).

Backend: Node.js + Express.

Database: Microsoft SQL Server.

APIs: Galileo GDS (JSON).

Notifications: SMTP/SendGrid for email, Twilio (or similar) for SMS.

Testing: Jest, Mocha, Cypress/Playwright.



---

Must-Have Skills

Proven experience integrating Galileo/Travelport GDS APIs (flight search, pricing, booking, PNR).

Strong knowledge of React + Node + Express + MSSQL.

Experience handling PNR workflows and fare rule confirmations.

Ability to deliver well-commented, production-ready code.



---

Deliverables

Completed booking flow with Galileo JSON integration.

MSSQL schema updates + migration scripts.

Fully functional PNR generation & persistence.

Working email + SMS notifications.

Documented end-to-end test suite.

Full source code with README and setup guide.