Does this work in Competitive, Ranked, and Conquest modes?

Yes. Aimbot, ESP, radar, and wallhack work in Competitive PvP, Ranked matches, Conquest, Domination, and PvE farming on Windows PC.