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.

Project ID: 39750986