Premium Employer

i

This company page is being actively managed by ZS Team. If you also belong to the team, you can get access from here

ZS Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Clear (1)

ZS Business Technology Analyst Interview Questions, Process, and Tips

Updated 13 Jan 2025

Top ZS Business Technology Analyst Interview Questions and Answers

  • Q1. Ways To Make Coin Change Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these ...read more
  • Q2. Diagonal Order Problem Statement Given a 2D matrix, output all elements of the matrix in diagonal order, starting from the top-left element and proceeding diagonally. In ...read more
  • Q3. What SQL query would you use to generate a report of customer churn based on the data in the case study?
View all 11 questions

ZS Business Technology Analyst Interview Experiences

19 interviews found

I was interviewed in Mar 2021.

Round 1 - Video Call 

(2 Questions)

Round duration - 30 Minutes
Round difficulty - Medium

In this round Business case studies were asked. The interviewer was friendly and helped me. The round was about 30 minutes. Some Sql question was also asked. One guesstimate and and a coding question was also asked.

  • Q1. 

    Ways To Make Coin Change

    Given an infinite supply of coins of varying denominations, determine the total number of ways to make change for a specified value using these coins. If it's not possible to make...

  • Ans. 

    The task is to determine the total number of ways to make change for a specified value using given denominations of coins.

    • Create a function that takes the number of denominations, the denominations array, and the value to make change for as input parameters.

    • Use dynamic programming to iterate through all possible combinations of coins to make the change.

    • Keep track of the number of ways to make change for each value from...

  • Answered by AI
  • Q2. What is an index in SQL?
  • Ans. 

    An index in SQL is a data structure that improves the speed of data retrieval operations on a database table.

    • Indexes are used to quickly locate data without having to search every row in a table.

    • They can be created on one or more columns in a table.

    • Examples of indexes include primary keys, unique keys, and non-unique indexes.

  • Answered by AI
Round 2 - HR 

Round duration - 30 Minutes
Round difficulty - Medium

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Business Technology Analyst in DelhiEligibility criteriaResumeZS Associates interview preparation:Topics to prepare for the interview - Python, MySQL, Business case studies, Excel, Machine learningTime required to prepare for the interview - 1 monthInterview preparation tips for other job seekers

Tip 1 : Go through the basics
Tip 2 : Know the concept well

Application resume tips for other job seekers

Tip 1 : Mention the project and summarise well
Tip 2 : Skills should be mentioned properly

Final outcome of the interviewRejected

Skills evaluated in this interview

I was interviewed in Feb 2021.

Round 1 - Coding Test 

Round duration - 180 Minutes
Round difficulty - Hard

This round consisted of an MCQ round + Problem-Solving round + a video interview round, all were elimination rounds.
The MCQ round contained problems to test problem-solving skills, data interpretation, and aptitude.
If we clear the MCQ round then the problem-solving round is unlocked immediately. This round contained questions that tested the candidate's problem-solving abilities and how he reaches the optimal solutions to that problem.
If we clear this round then the video interview round is unlocked.
Video interview contained situation based questions which we were given 10 seconds to read and then answer them on camera for more than a minute.

Round 2 - Coding Test 

(1 Question)

Round duration - 120 minutes
Round difficulty - Medium

This round consisted of a business case study.
A case study was given to the candidate to study and analyze it and then formulate the approach on how to reach answers to those questions. The time for all this was 1 hour.
After that, an interviewer discussed the approach and solutions to the questions that we formulated. Why and how did we choose the particular path to that approach, everything was discussed. MySQL questions were also asked

  • Q1. What SQL query would you use to generate a report of customer churn based on the data in the case study?
  • Ans. 

    Use SQL query to generate a report of customer churn based on case study data.

    • Identify the criteria for customer churn in the case study data (e.g. last purchase date, account status)

    • Select the relevant fields from the database tables (e.g. customer ID, churn date)

    • Filter the data to include only customers who meet the churn criteria

    • Group the data by relevant time periods (e.g. monthly, quarterly) to analyze churn trend...

  • Answered by AI
Round 3 - HR 

Round duration - 45 Minutes
Round difficulty - Medium

The interview was in the evening. The interviewer was a senior manager in the company. 

Interview Preparation Tips

Professional and academic backgroundI applied for the job as Business Technology Analyst in PuneEligibility criteriaAbove 6.5 CGPAZS Associates interview preparation:Topics to prepare for the interview - SQL, DBMS, Guesstimates, Puzzles, Analytical Aptitude,Time required to prepare for the interview - 3 MonthsInterview preparation tips for other job seekers

Tip 1 : Practice a lot of questions on MySQL in platforms like Hackerrank as it would help a lot in the technical round.
Tip 2 : Practice plenty of guesstimates, puzzles, and business case studies.
Tip 3 : Follow a comprehensive approach to solve a case study and focus on the right approach rather than focusing on the correct answer.

Application resume tips for other job seekers

Tip 1 : A good project will help a lot in cracking the behavioral interview
Tip 2 : Put only genuine things on the resume as cross-questions will be asked them definitely.

Final outcome of the interviewSelected

Skills evaluated in this interview

Business Technology Analyst Interview Questions Asked at Other Companies

asked in ZS
Q1. Ways To Make Coin Change Given an infinite supply of coins of var ... read more
asked in Deloitte
Q2. Sort 0 1 2 Problem Statement Given an integer array arr of size ' ... read more
asked in Deloitte
Q3. Bursting Balloons Problem Given an array ARR of size N, where eac ... read more
asked in ZS
Q4. Diagonal Order Problem Statement Given a 2D matrix, output all el ... read more
asked in ZS
Q5. What SQL query would you use to generate a report of customer chu ... read more

I applied via Campus Placement and was interviewed in Jul 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL queries, Puzzles, and situational questions in the technical round and questions from resume or project which you have done in the fit round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be honest and try to come up with a new approach every time a constraint is added to the question.

I applied via Campus Placement and was interviewed in May 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. How many traffic lights are in your hometown?

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL

ZS interview questions for designations

 Technology Analyst

 (4)

 Business Technology Associate

 (35)

 Associate Business Analyst

 (1)

 Business Technical Analyst

 (1)

 Business Analyst

 (18)

 Associate Business Technology Consultant

 (1)

 Senior Technology Consultant

 (1)

 Business Consultant Analyst

 (1)

I was interviewed before Dec 2020.

Round 1 - Coding Test 

(1 Question)

Round duration - 90 Minutes
Round difficulty - Medium

Timing: 11 pm till 11 am the next day.
Environment: You should need a hassle-free environment
You should need a webcam and earphone with a microphone in it, internet speed of minimum 2mbps.

  • Q1. 

    Diagonal Order Problem Statement

    Given a 2D matrix, output all elements of the matrix in diagonal order, starting from the top-left element and proceeding diagonally.

    Input:

    Line 1: Two integers, R and ...
  • Ans. 

    The problem involves outputting elements of a 2D matrix in diagonal order, alternating directions.

    • Iterate through the matrix diagonally, starting from the top-left element.

    • Alternate the direction of traversal from bottom-left to top-right and vice versa.

    • Handle large matrices efficiently by taking advantage of matrix properties.

    • Example: For a 3x3 matrix [1, 2, 3, 4, 5, 6, 7, 8, 9], the output should be 1 2 4 7 5 3 6 8 9

  • Answered by AI
Round 2 - Face to Face 

Round duration - 35 Minutes
Round difficulty - Hard

This round was a face to face round in which we had to describe our approach towards the case study which we had solved.
and also we were asked some SQL queries and DBMS fundamentals.

Round 3 - HR 

Round duration - 50 Minutes
Round difficulty - Medium

This was and EBI/FIT round in which we were asked guestimates and puzzles and some situational based question.

Interview Preparation Tips

Professional and academic backgroundI completed Computer Science Engineering from TIET - Thapar Institute of Engineering And Technology. I applied for the job as Business Technology Analyst in GurgaonEligibility criteriaAbove 7 cgpaZS Associates interview preparation:Topics to prepare for the interview - Case studies, Aptitude, DBMS, SQL, Computer fundamentalsTime required to prepare for the interview - 1 MonthInterview preparation tips for other job seekers

Tip 1 : Just focus on your problem-solving ability.
Tip 2 : For the BTA role focus on SQL
Tip 3 : You should be well sound of python and cloud computing

Application resume tips for other job seekers

Tip 1 : Have some projects which are solving real-life problems
Tip 2 : For the BTA role have some skills in SQL and python

Final outcome of the interviewSelected

Skills evaluated in this interview

Get interview-ready with Top ZS Interview Questions

I applied via Naukri.com and was interviewed in Oct 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. 1st round was case study round. Where we can use our SQL knowledge to answer the question.
  • Q2. 2nd round was interview round where all the work related questions and questions based on resume where asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare everything mentioned in the resume

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. PySpark and Sql related questions were asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was quite easy. Pyspark and Basic Sql syntaxes should be known.

I applied via Naukri.com and was interviewed in Jun 2019. There were 4 interview rounds.

Interview Questionnaire 

6 Questions

  • Q1. 1. Different Informatica Transformations and functionality
  • Ans. 

    Informatica Transformations are used to manipulate data during ETL process.

    • Aggregator: performs calculations on groups of data

    • Filter: filters rows based on a condition

    • Joiner: joins data from two sources based on a common key

    • Lookup: retrieves data from a database table or flat file

    • Rank: assigns a rank to each row based on a specified column

    • Router: routes data to different targets based on a condition

    • Sorter: sorts data b...

  • Answered by AI
  • Q2. 2. What is SCD and types with example
  • Ans. 

    SCD stands for Slowly Changing Dimensions. It is a technique used in data warehousing to track changes in data over time.

    • Type 1 SCD: Overwrite the old data with new data. Example: Customer address change.

    • Type 2 SCD: Create a new record for the change. Example: Employee promotion.

    • Type 3 SCD: Create a new attribute to store the change. Example: Product price change.

    • Type 4 SCD: Create a separate table to store the change

  • Answered by AI
  • Q3. 3. Difference between dynamic and status lookup
  • Ans. 

    Dynamic lookup is done at runtime while status lookup is done at design time.

    • Dynamic lookup is used when the lookup values are not known at design time.

    • Status lookup is used when the lookup values are known at design time.

    • Dynamic lookup requires more processing power as it is done at runtime.

    • Status lookup is faster as it is done at design time.

    • Example of dynamic lookup: retrieving a list of available payment methods fr...

  • Answered by AI
  • Q4. 4. What should be ensured to maintain for Knowledge Transfer of project/jobs developed
  • Ans. 

    To maintain knowledge transfer of project/jobs developed, ensure documentation, training, and continuous communication.

    • Document all project/job details, processes, and procedures.

    • Provide training sessions to transfer knowledge and skills.

    • Encourage continuous communication and collaboration among team members.

    • Establish a knowledge sharing platform or repository.

    • Conduct regular knowledge transfer meetings or workshops.

    • As...

  • Answered by AI
  • Q5. Overview about US healthcare
  • Q6. What's fact, dimensions , what's stored in them
  • Ans. 

    Fact and dimensions are components of a data warehouse. Facts are numerical data while dimensions are descriptive data.

    • Facts are quantitative data that can be measured, such as sales revenue or number of customers.

    • Dimensions are descriptive data that provide context for the facts, such as time, location, or product.

    • Facts and dimensions are stored in a data warehouse, which is a large repository of data used for analysi...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - 1. Be confident.
2. Just say NO if you don't know the answer.
3. Ask again if question not understood very well.
4. Don't loose your concentration even if behaviour/tone of interviewer changes. Answer politely at all times.
5. don't forget to ask interviewer questions about his/her experience,journey etc

Skills evaluated in this interview

I was interviewed before Sep 2016.

Interview Questionnaire 

1 Question

  • Q1. Case study related to a startup.

Interview Preparation Tips

Round: Test
Tips: Manage your time efficiently. It is very important.
Duration: 1 hour 25 minutes
Total Questions: 65

Round: Case Study Interview
Experience: Business questions related to a company need to be answered using analysis and the raw data given.

Various reports need to be generated using the data.

Way of approach will be tested rather than output.
Tips: You will be given enough time. Check your analysis througly.

The most important thing is to convey your thought process to the interviewer.

Round: Behavioural Interview
Tips: Be honest and communicate your best.
Your communication skills matter. A lot !

College Name: NIT Jamshedpur
Contribute & help others!
anonymous
You can choose to be anonymous

ZS Interview FAQs

How many rounds are there in ZS Business Technology Analyst interview?
ZS interview process usually has 2-3 rounds. The most common rounds in the ZS interview process are Aptitude Test, Technical and Coding Test.
What are the top questions asked in ZS Business Technology Analyst interview?

Some of the top questions asked at the ZS Business Technology Analyst interview -

  1. 4. What should be ensured to maintain for Knowledge Transfer of project/jobs de...read more
  2. What's fact, dimensions , what's stored in t...read more
  3. 1. Different Informatica Transformations and functionali...read more

Recently Viewed

SALARIES

Cholamandalam MS Risk Services

JOBS

Cholamandalam MS Risk Services

No Jobs

DESIGNATION

INTERVIEWS

Tata Technologies

No Interviews

INTERVIEWS

Accenture

No Interviews

INTERVIEWS

Kirloskar Pneumatic

No Interviews

INTERVIEWS

Accenture

No Interviews

INTERVIEWS

HSBC Group

No Interviews

DESIGNATION

INTERVIEWS

IDFC FIRST Bank

No Interviews

Tell us how to improve this page.

ZS Business Technology Analyst Interview Process

based on 11 interviews

4 Interview rounds

  • Aptitude Test Round
  • Coding Test Round
  • Case Study Round
  • Personal Interview1 Round
View more
Join ZS Where passion changes lives

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.7k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Deloitte Interview Questions
3.8
 • 2.9k Interviews
View all
ZS Business Technology Analyst Salary
based on 554 salaries
₹6 L/yr - ₹15 L/yr
33% more than the average Business Technology Analyst Salary in India
View more details

ZS Business Technology Analyst Reviews and Ratings

based on 76 reviews

3.2/5

Rating in categories

3.4

Skill development

2.0

Work-life balance

3.8

Salary

3.7

Job security

3.5

Company culture

3.2

Promotions

2.9

Work satisfaction

Explore 76 Reviews and Ratings
Associate Consultant
2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Decision Analytics Associate
1.7k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Business Technology Associate
1.2k salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Associate Decision Analytics Consultant
889 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Consultant
643 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare ZS with

Wipro

3.7
Compare

TCS

3.7
Compare

Infosys

3.6
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview