Is it good to work in a digital agency or in a private organisation as a social media marketing executive for a good career further?

As per my opinion, I would say social media marketing executive as it would help you learn a lot, you'll use a range of social media platforms and techniques. You could also do a digital marketing course side by side. All the best.