Translators should absolutely be detail-oriented, mainly because professional translation is all about details. This concerns linguistic details, of course, but project-related details also, as well as cultural details, DTP details and other IT-related details.
Translators need to pay attention to all the details of the source text, but should also remain focused on the details of their translation. This double layer of attention to detail can be challenging to some translators, but are an essential aspect of a professional translator's daily job.