Replace docker-compose with test containers

[mantzas]

Is your feature request related to a problem? Please describe

Flakyness is a difficult thing to manage especially when working with containers and tests.
We should try out testcontainers which can be used for testing and local development.

Describe the solution

Replace docker compose with test containers for testing and local development.