Could be Manila tamarind, Pithecellobium dulcis. If so, I doubt it would grow in any climate where winter temperature gets down to freezing point (i.e. 0 deg C or 32 deg F)

It sounds like your not describing a berry but some sort of bean. Do you have more info? How does it tastes like? Leaf shape? Tree shape? Flowers?
Another guess, can it be some kind of Inga species, the ice cream bean?

Could it be guamuchil or kamachile?

Here is a link that might be useful: Guamuchil

What was it called in Tamil?
Hlily