It's a totally made up word, from putting together 'suck' and 'fantastic'. It basically means a job that fantastically sucks. A job that people hate to do. So maybe unblocking drains could be described as sucktastic. Generally though, what comes to my mind is crap jobs for bad money and which generally make the employee feel miserable.