Zscaler Softech Analytics Manager Interview Questions and Answers

Eligibility criteriaAbove 7 CGPACerner Corporation interview preparation:Topics to prepare for the interview - SQL, Database Management Systems, OOPS, DSA, System DesignTime required to prepare for the interview - 4 monthsInterview preparation tips for other job seekers

Tip 1 : Since this was a SQL post, I would suggest you to get the basics intact and try practicing few queries.
Tip 2 : Must do Previously asked Interview as well as Online Test Questions.
Tip 3 : Go through all the previous interview experiences from Codestudio and Leetcode.

Application resume tips for other job seekers

Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.

Final outcome of the interviewSelected

Interview preparation tips for other job seekers - My name is Saurabh Saxena
I live in nadaiya rampur Post govindpur tilhar shahjahanpur Uttar Pradesh
I have a complete graduation BCA

Interview preparation tips for other job seekers - Basic interview questions based on the skills mentioned in your resume.

Interview preparation tips for other job seekers - Please prepare all basics of MVC,SQL and C#

Interview preparation tips for other job seekers - It was a nice experience

Round: Test
Experience: The test was conducted online. All the questions were of medium standard and easy to crack if we have patience for thinking.

English comprehension level is slightly below the standard of CAT. Those who have the habit of reading English news paper can easily crack the test.

Data analysis questions were also of medium standard. Those who have knowledge about graphs, bar & pie charts can easily crack the exam.
Tips: Practice Aptitude questions from R S Agarwaal book and CAT material.

Round: Technical Interview
Experience: Over all interview experience is cool. Interviewers never grilled on anything. In many cases they have helped me to arrive at answers.
Tips: Read C++ and Oops concepts from E Balaguruswamy text book.
For Data structures and algorithms read 'Data structures' by Yeshwant kanethkar.
Minimum knowledge about all the courses of your department will be an added advantage. This will help you to depict you are sincere in your studies and don't have any personal constraints in learning a new thing.

General Tips: Just be confident and believe in yourself. You will get through.
Skills: Programming skill in C++
College Name: NIT Warangal
Motivation: No special motivation. It is a rapidly growing company offering good package.

Round: Test
Experience: The questions were tricky. We were given a paragraph and after reading it, a statement was given to us and we were asked to say if it is true, false or cannot say. The structure of the statement put us into a a tough place. So practice of such kind of questions is necessary.

For data interpretation questions a good hand on basic statistical mathematics is needed. One has to be quick because of the time crunch. The questions were approachable

Round: Technical Interview
Experience: In this round my resume was scanned and I was required to speak about myself, my projects and explain certain areas of my resume. The interviewer picked up one of my basic project, surprisingly, and asked me to elaborate on it. He asked me how I can improve the project. And I had to write a code to make that change. Basically, one should have a good idea about the projects they've done/ mentioned in their resume. And know it in detail.

Few questions on data structures. Prepare well for coding type questions and data structures.

Round: Puzzle Interview
Experience: The interviewer asked me two puzzles. They were moderate level. And also luckily he was helpful whenever I got stuck.

Round: HR Interview
Experience: HR round was good. Basic questions like " tell me more about yourself", brief information about my past history, college life, extra curricular activities. In the end she asked me, "should we hire you?" And I lightly answered " why not!" So it was a good interview overall.

Skills: Coding Skills, Team Working Ability, Project management
College Name: Visvesvaraya National Institute Of Technology

Round: Test
Experience: I was from civil branch so had the above listed sections for pen paper written test. We had to attempt any 2 of the first 3 and last two were cumpolsory (Same for mechanical branch also). For CS, IT, ECE and EEE there were only 2 sections - first was programming - 5 questions and second was situational based.

All the three sections consisted 5 questions in each sections. Questions were very easy and hardly a pen was needed to solve. Quants section consisted of questions on binary to decimal, pipes and cistern and number system. Verbal section consisted of a passage followed by 5 questions and Logical section consisted of 5 simple sequence and series questions.
In 4 th section, we were asked to write an algorithm/flowchart for a given scenarion with some contraints - opening a bank account.
Last section was situational based questions. We were asked to exoress our views in maximum of 100 words on what we would do in a given situation.
Tips: Skip vrbal part as there can be chance of getting wrong. Solve quants and logical as there would be 100% chance of being correct due to very easy questions.
In 4th section, draw flowchart/tree showing how you will proceed and what you think. Before proceeding further think like a layman person how he will fill the form and then decide how to write an algorithm so that even a layman can understand well how to proceed with that particular form. Show output screens, consider exceptions, find every possible combinations for the various options given in the problem.
For last question, try to be practical, brief, concise and to the point. Don't write anything in round about manner.
Above all, as this is pen paper test, write in a beautiful hand writting.
Duration: 45 minutes
Total Questions: 12

Round: Technical Interview
Experience: The technical interview was easy. The questions were straingh forward. Questions were based on projects that I had done. I had Informatics Practices (Java) in class 12 so I told interviewer about database management. I was asked to explain tables used in project and a SQL Querry which I failed to answer.
Then she asked me to write a program to determine which offer is better to invest if in one interest rate increases by 2 each year and the one in which it increases by 1. I quickly wrote it. She said to improve the DBMS part and applauded for the programming skills.
Tips: Be confident and true. They ask only what you say about yourself. Prepare well for SQL querries as they focus more on SQL. Also practice programming as one queston will be essentially on it. Don't try to learn all languages. Know only one but know well. For civil students, have one project that involves programming. Try to learn MATLAB programming during B.Tech. It will make a good impact.

Round: HR Interview
Experience: The HR round was very easy. HR was very friendly. I was asked to introduce myself and then he asked me to explain about my project which I had done in MATLAB. He then asked HR questions like why I wanted to join software industry, where I see myslef in 5 years, previous interview experiences.
Tips: Be cool and confident. If you made till HR round, the probability of being selected in 90%. For civil students, try to be familiar with programming languages and SQL. Also try to have some extra skills that make you different from others. Don't think civil engineers only build buildings and roads; there is a lot more for us to do. Its always good to stand away from crowd.
All the best!

General Tips: Have good command on basics of what learnt C++ or Java and MySQL in class 12. Try to have a project using any programming skill if you are from non CS/IT background as it will help you prove you interest in programming despite your branch. Knowing foreign language atleast till intermediate level will add stars to your extra skills.
Skill Tips: For civil and mechanical students, if you has C++ or Informatics Practices in class 12, be in touch with that knowledge. They test only basics. Familiarize yourself with OOPS and SQL querries.
Be confident with what you speak and speak in clear voice. If you don't know simply say no. Must attent the interview with a good explanations of questions asked about your weak skills.
Skills: Confidence, Programming Skills In Any Language Like C, Database Management
College Name: VIT Vellore
Motivation: Interest in programming.
Funny Moments: When HR asked where I see myself in 5 years I said that I see myself in Europe. To which he said that he is hiring for India and when I said that I am hired for India right now but not for 5 years. He smiled with the answer and wished me all the best.