He has won the Under-23 player of the tournament for IPL 2010 representing Mumbai Indians as he had a fairly successful tournament, scoring 419 runs in 16 matches, at an average of 29.92 and strike rate of 135.59. He was signed by Royal Challengers Bangalore for the 2011 Indian Premier League at a price of USD 1.6 million.In 2014 IPL auctions,he was signed by Delhi Daredevils for 70 lakhs Indian rupees. However after the signing, he has become very inconsistent and is described by spectators as 'a real waste of money' in the IPL. In the 2016 IPL, Tiwary and Albie Morkel were swapped from the Delhi Daredevils team and joined the Rising Pune Supergiants.
He was called into the squad for the 2010 Asia Cup, but did not play. He made his ODI debut against Australia in Visakhapatnam in October 2010 after a few first-choice players were rested. He was bought by Delhi Daredevils in Indian Premier League 2014 but was replaced by Imran Tahir (South Africa) after he was sidelined by an injured shoulder.