As a social media executive, will it be good to work in a digital agency or a private organisation? Which will be good for my career?

Hi Preet! If the profile suits your skill-set, you should just go for the job, irrespective of the fact that it is a digital agency or a private organisation. The pay scale would be similar in both.