The 32-year-old joined Spurs in 2008 but moved to the German side in January after falling behind Hugo Lloris and Brad Friedel in the pecking order at White Hart Lane.
Gomes' season ended prematurely due to a hand injury that required surgery and although his loan spell has now finished, he is hoping to move on from Spurs in search of regular first-team football.
"My spell in Germany was very good as I helped to save Hoffenheim from relegation to the second division," Gomes told Globo Esporte.
"I had a five-month loan deal as I was not playing at Tottenham.
"Now it's over and I have to report for duty with Tottenham but it's likely I will leave so I can continue my career as I am doing very well."