test Kafka functionality using testcontainers

[elliVM]

Description
Implement integration tests using testcontainers, already in use for SQL testing.

Benefits:

• avoid mocking
• uses real brokers
• isolation
• tests actual code
• local setup