Hi I'm 33 years old and have about 10 years of work experience after graduation.
I wish to pursue post grad study for better career prospects and typically to switch industries (consulting, automobile),
I'm looking at Germany simply because of the low fees. Not looking at any institute beyond 15000 Euros for tuition fees.
Can you please recommend if I should pursue MSc in Management or MBA? I believe it will be more apt for me to do MBA since I have so much work experience. However, I've read MBA degree is not very popular in Germany. Hence the confusion.

Also, can you please recommend which one is better between Berlin School of Economics & Law, Reutlingen or Offenburg?

I plan to take intensive German language classes before commencement of course.

Complete an intensive German course. Get the DSH. Go directly to work. No point taking a Fachhochschule degree in English.

What are your career goals? If they include staying in Germany to work after the program, then yes, I agree with Duncan that you should first learn the language and then see what your options are after that.

If your goals are just to study (inexpensively) and then go back to your home country, perhaps an English-language program could be appropriate. MSc's are indeed aimed more at students with little to no work experience, so that could be a factor in your choice (do you really want to attend classes with a much younger cohort?)