REAL ESTATE SALES RECOMMENDATION ENGINE

REAL ESTATE SALES RECOMMENDATION ENGINE
REAL ESTATE SALES RECOMMENDATION ENGINE
REAL ESTATE SALES RECOMMENDATION ENGINE
The real estate sales platform is a service for fast and convenient selling real property. A seller visits the site and answers certain questions to get a piece of advice. The consumer adds information about the address of the building and receives a recommendation on an approximate house price and the best sales method, real estate agent, cash offer or real estate company.
Challenge 1/4:
Ingest about 1TB of data to DB and run this ingestion continuously once per month for new data

Solution:

Built ETL process on AWS DataPipeline using Bash and NodeJS that ingest all data and create the necessary indexes/slices/views for less than 12 hoursRight db choice
Challenge 2/4:
Run geospatial queries on large tables > 200MLN records for less than 300ms

Solution:

Decided to use AWS Aurora as a main operational database and PostGIS extension to run geospatial queries and added required indexes and optimizations to make the execution as fast as possible
Challenge 3/4:
Integrate with more than 20 external API and 10 microservices through REST

Solution:

Implemented declarative utility client on top of base HTTP client with built-in backoff, retries, and circuit breaker. Added common library and whole architecture for all microservices in a system
Challenge 4/4:
Implement intellectual recommendation engine

Solution:

Developed the recommendation engine, that takes a lot of answers and other inputs from external sources and makes a decision about the best selling option
LANGUAGES
DATABASES
TOOLS
Made on
Tilda