Common Lisp would have to be the mainstream Lisp implementation, and comes with what you need to get typical programming jobs done (where “typical” means bread and butter tasks such as text processing, file IO, database access, graphical user interface design, parsing).
Practical Common Lisp looks like a particularly interesting introduction to Common Lisp for programmers who want to put Lisp to such uses.