Have a look at some great stuff from Bungie's Lead Artist Richard Lico, as he talks about in-game animation workflow while he was at the Pixel Challenge. Richard is also an iAnmate Games instructor. He goes into some detail on what they used in Destiny.