They are usually called makeup artist. In India its a common practice to call them as Makeup Man.