The test was divided into two parts. One was General Aptitude which included logical reasoning, Quantatitive Analysis. The other section was SQL based. The Apti section had too many questions compared to the time provided to us. A general suggestion would be to practice General Aptitude so that you can improve your speed. The SQL section was basic and quite easy.
The interview started with basic questions like introduction and company's info. Then it went toward discussion related to the project I did. At the end of the interview he asked me if there's any questions I have.
1. Practice Quantatitive Analysis
2. Learn what the company does, it's history and what your role would be
3. Be confident and honest during your interview