Camara played for Saint-Étienne, Lens and Marseille in France (playing in the 1999 UEFA Cup Final for the latter) before transferring to Liverpool.
A cult hero and crowd favourite at Anfield, Camara is best remembered for playing at Anfield against West Ham in October 1999, the morning after the death of his father, scoring the winning goal and then dropping to his knees in front of the Anfield Road stand with tears flowing. He also managed to score in three successive Premier League games for the Reds in late autumn of 1999. On 13 February, he scored the winner at Highbury, leading Liverpool to a 1–0 win over Arsenal. Despite his short spell at Liverpool, he was voted in 91st position in the 2006 poll "100 Players Who Shook The Kop", which was conducted by the official Liverpool Football Club web site. Camara's placing made him the second highest placed African player, behind Bruce Grobbelaar.
Signed by manager Harry Redknapp on 21 December 2000 for a fee of £1.5 million which, depending on other factors, could have risen to £2.6 million, Camara announced, "I've come to West Ham to play, play, play – and score, score, score. If it was a question of money, I could have stayed at Liverpool and picked it up. I need to play, and if I don't it is totally pointless." Making his West Ham debut on 23 December 2000 in a 2–1 away defeat to Leicester City, Camara went on to play only fourteen games, in all competitions, without scoring at all.
In January 2003 Camara was sent out on loan to Al-Ittihad for the remainder of the 2002–03 season.
Following West Ham's relegation in 2003 from the Premier League Camara left the club for Al-Siliya after his contract was terminated by mutual consent.
Titi Camara was a stalwart of the Guinea team from the early 1990s until the early 2000s. He is regarded as a key protagonist in Guinea's return to respectability in African football and played for his country at the 2004 African Nations Cup, where he scored 3 goals in the Group Stage, which meant he finished just one goal behind the leading scores of the tournament.
In December 2005, he was linked with the vacant manager's job with the Guinea national team. On 13 May 2009, Captain Moussa Dadis Camara, the President of Guinea publicly announced that he wanted him to manage the national team. At the end of May 2009, Camara was named the National Technical Director (NTC). On 9 June 2009, Camara was named the Head Coach of the Syli National to succeed Robert Nouzaret. Camara was serving in dual capacities of NTC and head Coach of the Syli National. On 15 September 2009, three months following his nomination as head coach of the Syli National, Camara was replaced by Mamadi Souaré, a former Captain of the Syli National, following poor results, lack of cooperation/understanding with certain conspicuous members of the Guinean Football Federation (FGF), and absence of "cordial" relations with certain key elements of the Syli National.
In September 2003, alleging breach of contract Camara sued West Ham United. In 2006 West Ham successfully defended the High Court breach of contract claim brought by Camara.
In December 2010 Camara was made Sports Minister of Guinea by newly elected president Alpha Condé making him the country's first ex-sportsman to hold a government post. He was replaced in October 2012.