How do I manage map transitions?

It’s called level streaming.
Download Content Examples pack and open Level_Streaming.umap.

There are also several tutorials on YouTube:

https://www.youtube.com/results?search_query=unreal+level+streaming