First, I’m a bit confused about your
goals you mention finance/investment banking,corporate strategy, and strategy consulting. Those could be three different things, or they could overlap, and it’s not clear to me.
Regardless, I think it would be a particular challenge to convince an MBA or EMBA adcom that you can make a major career switch via MBA at this phase (10 years) of your career. There might be some logical transition from your current role to, say, strategy consulting (as people tend to go into that after having some specific functional expertise and experience).
As for your age, you’re on the older side for an MBA, and in the range for some of the younger trending EMBAs. Also, note that European regular MBA programs trend a little older than US ones. But – many and probably most EMBA programs are not set up for career changers. That is changing however, so you have to research EMBA programs to see what they offer in career development and recruiting.
As to where it’s better for you – US, India, or elsewhere – I just can’t tell without more information. A key factor in answering that is where you want to work post-MBA (company and geography).
Also, what GMAT you need depends on which schools you are targeting, and whether it’s regular MBA or EMBA. Some EMBA programs no longer require the GMAT. For top-20 level regular MBA programs you should score 720+ (partly due to being in the
Indian ITdemographic). For top EMBA programs that do require the GMAT, often a high-600 score suffices.