I've heard it once or twice, but not very regularly.
I think native Americans would find it amusing in the mouth of an Italian, though!
It's an equivalent, as GG says, of
Holy cow or
Holy smoke, an expression of astonishment like
Wow! or
Geez! or even, to select an expression of approximately the same (low) frequency of use,
Geez Louise!
CJ