This part is really important and I completely agree with DarthViper on. Yes, the end result matters the most and that’s usually program agnostic.
However, internal pipelines/workflows are built around specific software packages and assets must work within that pipeline. So yes, you can learn Blender and do most of your work in that program. Along the way, though, you’ll probably need a working knowledge of Max or Maya for getting the asset through the pipeline and into the engine.
This is why so many production artists recommend having a familiarity with Max or Maya. If I run a dev studio that uses Maya in-house, I’m looking for applicants who can onboard as seamlessly as possible into the pipeline without having to make special considerations or exceptions.