i
Slice
Filter interviews by
I applied via Referral and was interviewed in Jul 2024. There was 1 interview round.
Joins in SQL are used to combine rows from two or more tables based on a related column between them.
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
RIGHT JOIN returns all rows from the right table and the matched rows from the left table
FU...
I applied via Approached by Company and was interviewed before Jun 2023. There were 3 interview rounds.
Quantitative case study on cost benefit analysis of 2 types of public buses running in a city. Need to choose one of them with higher profits
Fraud detection model: 3rd party firm proposing to use thier model for fraud detection. Need to profit analysis of whether to go for it or not.
Top trending discussions
I appeared for an interview in Dec 2016.
I don't have the available data to answer this question.
Need data on number of barbers in Kanpur
Need data on average revenue per barber
Need data on number of working days in a year
Need data on number of customers per barber per day
To open an e-commerce website like Flipkart, one must keep in mind various factors such as target audience, product range, user experience, logistics, and marketing.
Identify the target audience and their preferences
Offer a wide range of products to cater to different needs
Ensure a seamless user experience with easy navigation and quick loading time
Establish a robust logistics network for timely delivery and hassle-free...
It depends on the job profile and its alignment with my career goals.
I would consider the job profile and evaluate its alignment with my career goals.
I would assess the job responsibilities and the skills required for the role.
I would also consider the company culture and work environment.
If the job profile aligns with my career goals and offers growth opportunities, I would accept it.
However, if it does not align with...
I would have pursued a certification in data science earlier.
I should have taken a course in data science during my undergraduate studies.
I could have pursued a certification in data science while working as a business analyst.
Learning data science earlier would have opened up more opportunities for me in the field.
I could have gained more experience in data analysis and visualization.
I could have applied for more adva...
I applied via Approached by Company and was interviewed in Sep 2024. There was 1 interview round.
I had a very bad interview experience. The interviewer didn't start with any introduction and immediately jumped into asking case study. After giving a case, he would leave for a few minutes, which made it seem like he was not interested in the process.
Questions asked:
Q1: You are an Analyst at UBER. The gross cab cancellation rate daily is 5% whereas on a particular day, it goes up to 10%. What could be the factors affecting the same?
To analyze the same list down the tables required in the database along with all the columns and write the query using the same table name & columns to find the required metrics.
Q2: Assume you work for YouTube Music and the CEO wants you to create a Business Health Dashboard. List down all the metrics the CEO will be interested in looking at.
Use a data migration tool to copy the dataset efficiently.
Utilize a data migration tool like AWS Data Pipeline, Apache Nifi, or Talend to copy the dataset.
Break down the dataset into smaller chunks to avoid overwhelming the system.
Ensure proper data validation and error handling during the copying process.
Consider using parallel processing to speed up the copying process.
Monitor the progress of the dataset copying to t...
No, data analysis job is not overrated as it plays a crucial role in decision-making and problem-solving.
Data analysis helps in identifying trends and patterns in data
It provides valuable insights for businesses to make informed decisions
Data analysis is essential for optimizing processes and improving efficiency
It can uncover hidden opportunities and potential risks
Many industries rely on data analysis for strategic p...
I applied via Campus Placement and was interviewed in Sep 2023. There were 3 interview rounds.
General aptitude questions and excel questions
posted on 12 Jun 2024
posted on 9 Oct 2024
I appeared for an interview in Sep 2024.
based on 2 interview experiences
Difficulty level
Duration
based on 2 reviews
Rating in categories
KYC Associate
165
salaries
| ₹3 L/yr - ₹4.7 L/yr |
Team Lead
61
salaries
| ₹4.5 L/yr - ₹10.3 L/yr |
Collections Executive
53
salaries
| ₹2.5 L/yr - ₹4.2 L/yr |
Customer Support Executive
49
salaries
| ₹3 L/yr - ₹6.5 L/yr |
Senior Quality Assurance Engineer
39
salaries
| ₹12.2 L/yr - ₹16 L/yr |
PhonePe
Fiserv
KFintech
Angel One