Is MBA mandatory to get a job in HR?

I dont think so

Last time I checked, being female and the ability to draw rangoli are the only requirement.

Yes

Yeah, unless you're working as a freelance recruiter on contract, or something like that

Yes if you have to grow the ladder