AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
i
ZS
Compare
Filter interviews by
ZS Technology Analyst Interview Questions and Answers
ZS Technology Analyst Interview Experiences
4 interviews found
Anonymous
It was a aptitude test
(1 Question)
- Q1. It was a sql round
(1 Question)
- Q1. It was a techno manegerial round
(1 Question)
- Q1. Basic HR round it was
Mohit Awasthi
Any regular Apti test containing a number of questions
About a food industry
General GD to talk on anything
Selected
I applied via Campus Placement and was interviewed before May 2023. There were 4 interview rounds.
Normal Qunatative apti
There will be some data and tables , you will be asked to analyse the data and write SQL queries so study well SQL and its implementation on data.
(2 Questions)
- Q1. Tell me about joins in SQL
- Ans.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
Joins are used to retrieve data from multiple tables based on a related column.
Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.
INNER JOIN returns rows when there is at least one match in both tables.
LEFT JOIN returns all rows from the left table and the matched rows from the right table.
RI...
- Q2. Tell me about aggregation
- Ans.
Aggregation is the process of combining data from multiple sources into a single, unified view.
Aggregation is commonly used in databases to summarize and analyze large amounts of data.
It can involve grouping data based on certain criteria, performing calculations, and presenting the results in a meaningful way.
Examples of aggregation functions include SUM, AVG, COUNT, MAX, and MIN.
Aggregation is also used in data visua...
(1 Question)
- Q1. Tell me about your college project
Interview Preparation Tips
Skills evaluated in this interview
Pushkar Kale
I appeared for an interview in Dec 2016.
Interview Questionnaire
2 Questions
- Q1. A case study based on database management and the actions to be taken based on graphs and data provided for a new product launched by a company.
- Q2. Tell me about yourself? What do you know about this profile? What have you learned during your 4 years in campus? Explain any one of your projects in detail, what you did, what you learnt, what difficultie...
- Ans.
I am a technology enthusiast with 4 years of campus experience, specializing in technology analysis.
I have a strong background in technology analysis and research.
During my 4 years in campus, I have learned various analytical tools and methodologies.
One of my projects involved analyzing data to identify trends and patterns, which helped in making informed decisions.
I faced challenges in data collection and analysis, bu...
Interview Preparation Tips
Experience: Test taken on ZS.hirepro.in/campus. 75 questions on aptitude (Quant, Verbal, LR) + 10 questions on basic programming (2-3 on SQL). Sufficient time provided
Tips: Practice for aptitude from various sites or books if you are slow.
For programming just see some basic output type questions.
Total Questions: 85
Round: Case Study Interview
Experience: Test taken on ZS.hirepro.in/campus. 75 questions on aptitude (Quant, Verbal, LR) + 10 questions on basic programming (2-3 on SQL). Sufficient time provided
Tips: Practice for aptitude from various sites or books if you are slow.
For programming just see some basic output type questions.
Round: Case Study Interview
Experience: Case was provided to all of us and 30 minutes given to write the answers to the questions asked. Questions were to make a table by taking minimum data from given 5 tables, find discrepancies in data, remove errors, propose schemes to increase customers based on current customer data and starting schemes for current customers.
After this the case was discussed individually for each candidate by the interviewer and all the unanswered questions as well as answered ones were discussed. He checked observation skills on the tables provided.
Finally he asked a puzzle
Tips: Observe the data carefully
Ask questions if you do not understand anything
College Name: IIT Kharagpur
ZS interview questions for designations
Interview questions from similar companies
I appeared for an interview in Nov 2020.
Interview Questionnaire
1 Question
- Q1. Oops concept, collections, spring annotations, SQL queries
Interview Preparation Tips
2nd round was technical interview and 3rd round was managerial round
Selected
I applied via Company Website and was interviewed before Jan 2022. There were 2 interview rounds.
(2 Questions)
- Q1. Tell us about yourself
- Q2. Why do you want to join EY
Interview Preparation Tips
I applied via Campus Placement and was interviewed in Oct 2020. There were 3 interview rounds.
Interview Questionnaire
1 Question
- Q1. Introduce yourself, about the role and cross questions on profile
Interview Preparation Tips
I applied via Recruitment Consultant and was interviewed in Feb 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Details about Top 2-3 bullets on my CV
Interview Preparation Tips
I appeared for an interview before Oct 2020.
Interview Questionnaire
2 Questions
- Q1. Asked questions related to my projects.
- Q2. Situational questions with no exact answers
Interview Preparation Tips
Subhradeep Chakraborty
I applied via Referral and was interviewed in Mar 2020. There were 3 interview rounds.
Interview Questionnaire
7 Questions
- Q1. Technical : Based on ETL and SAP BODS
- Q2. What will you do in some ABC situations?
- Q3. Why do you want to leave present company and want to join us
- Q4. What motivates you the most
- Q5. How have you handled customer escalations.
- Ans.
I have handled customer escalations by actively listening to their concerns, empathizing with their situation, and providing a timely and satisfactory resolution.
Listen to the customer's concerns without interrupting them
Empathize with their situation and acknowledge their frustration
Provide a timely and satisfactory resolution to their issue
Follow up with the customer to ensure their satisfaction
Document the escalatio
- Q6. What's your long term vision?
- Ans.
To create a sustainable future by leveraging technology and innovation.
Develop and implement eco-friendly solutions in various industries
Promote renewable energy sources and reduce carbon footprint
Encourage research and development in emerging technologies
Collaborate with like-minded organizations to achieve common goals
- Q7. Why I should consider you as good team player?
Interview Preparation Tips
First round: It was complete technical one and it lasted for 1 hour almost. Interviewer asked me to introduce myself at first. I introduced myself, told little bit about my background, my hometown, my college and b.tech curriculum etc. Then I moved to my technical specializations, I told about what I have done so far, what are the tools and technologies I have used, my daily responsibilities etc. Then he digged more into technical stuffs. I won't say its a hardcore interview rather technical discussion.
Advice :
Firstly, You should thoroughly go through JD. You need to go through each and every line and prepare yourself accordingly.
Secondly, You shouldn't lie. If you work in XYZ technology and not comfortable in ABC or PQRS technology. Just state that I am only comfortable in XYZ. They will start digging up based on your CV and initial introduction and in next 1 hour they will come to an conclusion if your cv is suitable for that particular profile.
Second and Third round : These 2 rounds were majorly a stress test. It was a mixed of technical + behavioural round. Questions were like - what you will do in some abc situation? How will you react in xyz situation? Why I should consider you as a good team player? Why you want to leave a corporate giant company and want to join pwc? How will you handle customer escalations? How motivated you are? What are your long term vision etc.
Advice : You should answer these questions very carefully. Based on your answer they can again ask you some counter questions. You should show positive attitude during interview. You should stay calm and answer in a polite positive way.
ZS Interview FAQs
Tell us how to improve this page.
ZS Interviews By Designations
- ZS Decision Analytics Associate Interview Questions
- ZS Business Technology Associate Interview Questions
- ZS Business Operations Associate Interview Questions
- ZS Associate Interview Questions
- ZS Business Technology Analyst Interview Questions
- ZS Business Analyst Interview Questions
- ZS Associate Decision Analytics Consultant Interview Questions
- ZS Consultant Interview Questions
- Show more
Interview Questions for Popular Designations
- Technology Consultant Interview Questions
- Technology Specialist Interview Questions
- Business Technology Analyst Interview Questions
- Associate Information Technology Consultant Interview Questions
- Associate Technology Interview Questions
- Assistant Manager Information Technology Interview Questions
- Technology Architect Interview Questions
- Technology Engineer Interview Questions
- Show more
ZS Technology Analyst Interview Process
based on 3 interviews
1 Interview rounds
- Aptitude Test Round
Interview Questions from Similar Companies
Fast track your campus placements
ZS Technology Analyst Reviews and Ratings
based on 9 reviews
Rating in categories
|
Associate Consultant
2.1k
salaries
|  ₹9.3 L/yr - ₹27 L/yr |
|
Decision Analytics Associate
1.7k
salaries
| ₹7.5 L/yr - ₹18.5 L/yr |
|
Business Technology Associate
1.2k
salaries
| ₹7 L/yr - ₹17.4 L/yr |
|
Associate Decision Analytics Consultant
919
salaries
| ₹10.4 L/yr - ₹27.2 L/yr |
|
Consultant
658
salaries
| ₹14.7 L/yr - ₹37 L/yr |
Deloitte
Ernst & Young
PwC
KPMG India
- Home >
- Interviews >
- ZS Interview Questions >
- ZS Technology Analyst Interview Questions
