How do I fetch user profile data in search api entity (node) view?
Your search api view is only able to list what has been indexed, so you should add the node author to the search api index.

After this, in search api, you should be able to add 'related fields'. 

After adding items to be indexed in search api, make sure you reminded your site!