Pilat Media Global interview questions

I applied online and got a call for an assessment centre. Assessment centre consisted of a written test testing the qa basics followed by a short interview with qa lead. Time was not enough in completing the test though I managed to finish the important sections .Got email the next week asking me to come for a final round of interview. It was with the HR and the QA head. HR questions were quite simple and qa head expected a lot technically though it was entry level position

Asked in for a 3 hour assessment which covers: * Database modeling and SQL similar to the employee, department model. * SQL questions using that data model which are so large as to be difficult to work up on paper when anyone with experience has been using SQL tools most of their life. * XML component to the test which consisted of some basic questions about XML and XSD and a lot of XPATH queries against a supplied dataset which is designed with the same tags at different levels in the model to catch out those trying to rush. * A process flow question so you will need to remember all the flow charting you haven't done in the 10 years since university. * A PL/SQL component which anyone with 12 months experience should do well in except that some of the questions are either very poorly worded or were put together by someone with limited PL/SQL design experience. They time the assessment which is silly because the assessment is designed to catch people out people who rush but the right candidate should invariably take longer to complete the test because they will check their work. A week later was asked in for an interview with the GM and a technical staff member who asked a number of open ended technical questions expecting singular answers. How long is a piece of string type questions. Asked questions using non standard jargon acronyms and generally made me not want the job despite having broader skills and double the experience of the interviewer.