Where are current offsets stored?

Current offsets are stored in the metadata database. You can see a bit of context here.

If you’re still learning about Kafka ingestion, this tutorial is worth reading, and @TijoThomas put this great video together about best practices: