Map HR Roles and Peoples Gender

I have a list of roles that needs to be mapped as: Sales & Mkting/ Technology/Operations.

There is also a list of first names that needs to be mapped to gender M/F

Please see attached sheets. an HR background will be essential.