This is a classified position and does not appear in the organization chart of the Department of State, although it is easy to figure out where it would go. Also, from page 27 of this site it is obvious that the Senate Foreign Relations Committee would be the one conducting the hearing.
The hearing results were positive but because the position is classified, we don't know what happened in detail.
There was some tension because Vampy was uncomfortable with the fact that some of the Senators had a cross. Vampy also asked the lights to be dimmed several times. Vampy also stumbled in his response to the question of his overall mission. Vampy said, "we're going to make America Great Tasting, uh, I mean Great Again."
When one of the committee asked Vampy if he had ever drunk human blood, Vampy said back that every member of the committee has probably done so when they accidently bit their lip or at the dentist. Although it was a somewhat non responsive answer, the committee didn't seem to notice.
The committee will vote on this in secret and then the full Senate will act similarly.
UPDATE: Vampy was confirmed Feb 10. He immediately ordered all the lights dimmed in his area of the State Dept. and also had all the mirrors removed and told the cafeteria to ban the use of garlic.