Our artists use Autodesk 3DS Max or Maya to model things, they use zbrush or mudbox to add uber details used in the normal maps, Photoshop to do textures, and the levels are done with the Unreal Editor that comes with the game. (It already has thousands of models and textures we can use in a level, and then we import our custom stuff as well.)
Also moving this to General Discussion.