Advanced · 3–4 weeks
Product Search Service with Elasticsearch
Catalog service writes to PostgreSQL; CDC or events sync to Elasticsearch. Search API with facets, autocomplete, fuzzy matching, and relevance tuning.
Why this project
Search is a distinct skill from CRUD. Discuss index design, sync lag, and query DSL.
Tech stack
Java 17Spring Boot 3ElasticsearchPostgreSQLKafkaSpring Data Elasticsearch
Skills demonstrated
- Search index design
- CDC/event sync
- Faceted search
- Relevance tuning
Interview talking points
- Outbox vs dual-write problem
- Handling sync failure and lag
- Autocomplete edge n-grams
- When to reindex vs update
Problem statement
Catalog service writes to PostgreSQL; CDC or events sync to Elasticsearch. Search API with facets, autocomplete, fuzzy matching, and relevance tuning.