The Yiddish word for connesseur is קאָננעססעור
Some other yiddish translations that we have are:PihpyschoMawgenstootzgood kidgimmickNervous personkerplemptfriendshipavi