There are a lot of different jobs in game development:
game designer - decides how the game is going to work
programmer - writes the code that makes the computer / console play the game
modeler - creates the 3D shapes for the characters and props in the game
animator - creates the motions for the characters move around in the game.
level designer - creates the ground, buildings, sky, etc. for the game world
tester - plays the game over and over again to find bugs
audio guy - does the sound effects and music
Sometimes you can do more than one job, but mostly people specialize.
So the first thing you want to do is decide which of these areas you’re interested in. If you want to be a modeler or animator or level designer, than Maya is a great program to learn. It and 3D Studio Max are the two most popular for current game development.
If you want to be a game designer or programmer, then you don’t really need Maya. Try getting a beginner’s game engine like “Dark Basic” or “Blitz Basic”, and use it to create some games. (Also consider going to the web site gamedev.net - that’s a better site for game designers and programmers than cgtalk. cgtalk is mostly for modelers and animators.)
Good luck!
P.S. Oh yeah, for Xbox and PS2 games they mostly use Max and Maya for the art, and use C++ for the game code. You can go to www.gamasutra.com, and register, and read a bunch of articles, called “Post Mortems” on how many different video games were written. Sometimes these articles say how many people worked on a game, and what programs they used to create it. Max and Maya are the most common tools used for professional console video game 3D graphics.