Which enzyme catalyzes transcription and which translation?
Sorry, but you started on the right track. What you're looking for is called the central dogma of protein synthesis.

Genomic DNA is transcribed in the nucleus into messenger RNA (mRNA) by RNA polymerase. RNA polymerase is DNA-dependent; it needs a DNA template to make an RNA version of the message.

The messenger RNA moves into the cytoplasm where it gets translated by ribosomes into an a polypeptide (protein). Ribosomes are the enzyme that do the translating, and perhaps your confusion is because ribosomes are made up of both RNA molecules and proteins (a ribonucleotide complex).

Aminoacyl tRNA synthetases are the enzymes that make aminoacyl tRNAs (tRNA for short). These tRNA bring individual amino acids to the ribosome as the ribosome is extending the polypetide product of the mRNA message.