I have mainly used C and C++, but before that it was Fortran, including various proprietary versions for HPC from Cray and CM. Perhaps the most obscure langauge I used back then was another HPC-specific one called Tao, which had some fun features like being able to define (not just overload) your own operators and syntax. I have also programmed in some assembly langauges which gives you a rather different perspective on things (goto not considered harmful!).

I used to do a lot of Perl and bash and csh and a bit of Python, but not so much now. I dabbled with Ruby too, just out of curiousity. I've never had to write Java, but I ocasionally have to read it.

I think that while it would be unusual to ask specifically for an awk programmer, having reasonable knowledge of a variety of such tools will make you more efficient in your work.

I agree with era that Emacs Lisp is enjoyable, but I haven't done any in ages; I have probably forgotten it all now.