Had my tranny fluid changed at the dealer and they put in Mazda fluid and it makes that noise. I am going back as it is quite annoying.
Best fluid for our car is the Motorcraft synthetic.
http://k-mansparts.com/items/focus/...ission-fluid-XT-M5-QS-quart-xtm5qs-detail.htm