Help required for urgent data analyst role job preparation.

This is for a close friend at data analyst role. The person has to look out for new job in a month.
The skill set he has is PL/SQL, python, data analysis.
Experience :7 years
He is currently working in one of the investment banks.
Since this came suddenly, he is not at all prepared or aware of market standards. Can you please suggest what questions will be expected or what topics are generally asked in interviews for data analyst role?
Any preparation links would be of great help.
For now seeking any offer is priority.

Please help blinders. #hiring #jobopening #recruiting
#deloitte #ihsmarkit #rbs #deutschebank #oracle #ey #kpmg #optum #adobe #sap #morganstanley #salesforce #atlassian