ZS interview experience Real time questions & tips from candidates to crack your interview

Business Technology Analyst

ZS
upvote
share-icon
3 rounds | 4 Coding problems

Interview preparation journey

expand-icon
Preparation
Duration: 2 months
Topics: Data structures, Algorithms, MySql, OOPS, Puzzles, Guesstimates
Tip
Tip

Tip 1 : Practice Sql questions 
Tip 2 : Prepare atleast 2-3 projects 
Tip 3 : Practice alteast 300 data structures questions

Application process
Where: Campus
Eligibility: 70 percentage throughout
Resume Tip
Resume tip

Tip 1 : Having some projects on resume
Tip 2 : Do not put false things and add database skills

Interview rounds

01
Round
Easy
Online Coding Interview
Duration60 minutes
Interview date9 Aug 2022
Coding problem0

It was an aptitude round of 60 minutes

02
Round
Medium
Online Coding Interview
Duration90 minutes
Interview date12 Aug 2022
Coding problem2

It was a case study round, where sql mcq questions and sql query questions were asked in the section 1 and then in section 2, there were 2 coding questions on data structures and algorithms.

1. SQL based questions

Tables were given with train details
And query was
Write an Oracle SQL query to display:

The employee ID, employee name, department ID and department name of all employees who have a department assigned with the department location as 'CHENNAI'.

Problem approach

Tip 1: practice sql query questions 
Tip 2: revise Sql theory

2. SQL based question

Write an SQL query to find:

The type description and the count (use alias count) of each type of train from the train details table.

Problem approach

Tip 1: practice sql query questions of joins 
 

03
Round
Medium
Video Call
Duration70 minutes
Interview date12 Aug 2022
Coding problem2

It was the final round of technical interview where questions were asked on Resume projects, internship experiences and topics like data structures, Oops, Java, Sql.

1. OOPs based questions

what is polymorphism, abstraction?

2. Basic HR Questions

What were the major problems faced by you during the internship and how did you managed to solve them?

Here's your problem of the day

Solving this problem will increase your chance to get selected in this company

Skill covered: Programming

What is recursion?

Choose another skill to practice
Similar interview experiences
Business Technology Analyst
3 rounds | 3 problems
Interviewed by ZS
1969 views
1 comments
0 upvotes
Business Technology Analyst
1 rounds | 2 problems
Interviewed by ZS
1151 views
0 comments
0 upvotes
Business Technology Analyst
3 rounds | 7 problems
Interviewed by ZS
992 views
0 comments
0 upvotes
Business Technology Analyst
2 rounds | 4 problems
Interviewed by ZS
688 views
0 comments
0 upvotes