It was about only basics and about sql queries and behavioral questions, and it was very time taking process. For System analyst role you need to know only basics of sql and prepare for aptitude. In aptitude learn questions like profit lose and persentage.