I am pre-loading now....just wanted to know when do you get the Typhoon in the campaign?

It's a common weapon, some generic enemies carry them. As for it's first appearance I think it's the second mission.