Are you asking about an H-1 visa?

If you work in the US you MUST pay into Social Security and Medicare so you MUST get a SS number.

It's not automatic. You have to apply.

L-1 can get SSN, yes. Apply for one here: Social Security Number and Card