Request not to be named as a co-author on my own paper In a semi-hypothetical situation, assume that I'm a postdoc at a certain university and my supervisor pushed (forced) me to work on a journal paper that I hated but finished eventually. I say I hated it because the work is so silly, not at par with my previously published excellent work and will be published in a mediocre journal. My concern is that it may hurt my CV and compromise my profile. I should also say that it is not in the exact field in which I have been building a profile.

Although I have finished the paper, can I possibly tell my supervisor that I don't wish to be named on it?
You certainly can refuse to be named as co-author, but at this point it's probably easier just to sign off publication, unless there are stronger reasons than you've given.

Most reputable journals have processes that require all credited authors to sign off on publication, so you can't be credited as an author if you don't want to be*. However, this may mean that the paper can't be published at all - your supervisor shouldn't be claiming sole author credit for something that is largely your work, and even a mediocre journal is likely to balk at accepting a paper if it learns that one of the authors is unwilling to be associated with that work. 

Publishing this paper probably won't help your career significantly, but from the description you've given it doesn't sound likely to harm it either, especially if it's not in the field that you're aiming for. I changed career and I have several publications on my CV that have no relevance to my current career; I doubt any of my co-workers have even bothered looking them up, let alone passing judgement on whether they're a valuable contribution to the literature.

*Some loopholes may apply. I had an ex-boss who listed me and another researcher as co-authors on a poster and conference presentation, even though he knew we had significant objections to the content. While the associated journal required sign-off from all authors on published papers, this was not the case for conference material. We had to write in to request that the "error" be corrected for the published proceedings.