i
ZS
Filter interviews by
Clear (1)
I was interviewed in Mar 2021.
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.
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...
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...
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.
Round duration - 30 Minutes
Round difficulty - Medium
Tip 1 : Go through the basics
Tip 2 : Know the concept well
Tip 1 : Mention the project and summarise well
Tip 2 : Skills should be mentioned properly
I was interviewed in Feb 2021.
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 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
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...
Round duration - 45 Minutes
Round difficulty - Medium
The interview was in the evening. The interviewer was a senior manager in the company.
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.
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.
I applied via Campus Placement and was interviewed in Jul 2021. There were 3 interview rounds.
I applied via Campus Placement and was interviewed in May 2021. There were 3 interview rounds.
ZS interview questions for designations
I was interviewed before Dec 2020.
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.
Given a 2D matrix, output all elements of the matrix in diagonal order, starting from the top-left element and proceeding diagonally.
Line 1: Two integers, R and ...
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
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 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.
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
Tip 1 : Have some projects which are solving real-life problems
Tip 2 : For the BTA role have some skills in SQL and python
Get interview-ready with Top ZS Interview Questions
I applied via Naukri.com and was interviewed in Oct 2020. There were 4 interview rounds.
I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 4 interview rounds.
I applied via Naukri.com and was interviewed in Jun 2019. There were 4 interview rounds.
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...
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
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...
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...
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...
I was interviewed before Sep 2016.
Top trending discussions
based on 11 interviews
4 Interview rounds
based on 76 reviews
Rating in categories
Associate Consultant
2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Decision Analytics Associate
1.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Business Technology Associate
1.2k
salaries
| ₹0 L/yr - ₹0 L/yr |
Associate Decision Analytics Consultant
889
salaries
| ₹0 L/yr - ₹0 L/yr |
Consultant
643
salaries
| ₹0 L/yr - ₹0 L/yr |
Wipro
TCS
Infosys
HCLTech