Filter interviews by
Clear (1)
Top trending discussions
I appeared for an interview before Sep 2019.
I appeared for an interview in May 2021.
Round duration - 60 minutes
Round difficulty - Medium
Started with project description, deep dive into project
Questions about ML, Statistics
Coding questions for Python, SQL
You are provided with a list, DICTIONARY[]
, which contains a collection of words, along with a stream of characters (queries). The task is to implement a class Chara...
Implement a class to check if a string formed by the last queried characters exists in a dictionary of words.
Initialize the class with the dictionary of words.
Implement a method to check if the string formed by the last queried characters exists in the dictionary.
Use appropriate data structures to efficiently solve the problem.
Ensure the class handles multiple test cases and character queries.
Example: DICTIONARY[] = ['...
Use a subquery to retrieve the second highest salary from a SQL database.
Use a subquery to select the maximum salary from the table.
Then use another subquery to select the maximum salary that is less than the maximum salary found in the first step.
Combine both subqueries to retrieve the second highest salary.
Round duration - 60 minutes
Round difficulty - Easy
Projects
Machine Learning
Questions about Statistics
Answering aptitude questions related to statistics
Statistics is the study of collecting, analyzing, interpreting, presenting, and organizing data.
Key concepts include mean, median, mode, standard deviation, and probability.
Examples of statistical questions include 'What is the average income of a population?' and 'What is the likelihood of an event occurring?'
Round duration - 60 minutes
Round difficulty - Easy
Behavioral Round
Questions asked about Amazon Leadership Principles
Round duration - 60 minutes
Round difficulty - Easy
Medium Python questions
Medium SQL questions
Calculate the fraction when one integer is divided by another, with repeating decimal parts enclosed in parentheses.
Divide the first integer by the second integer to get the fraction
Identify if the fractional part is repeating and enclose it in parentheses
Return the fraction for each test case
Use SQL query with window functions to find top 2 salaries for each department.
Use PARTITION BY clause to partition the data by department.
Use ORDER BY clause to order the salaries in descending order.
Use ROW_NUMBER() function to assign a rank to each row within the partition.
Filter the results to only include rows with rank 1 and 2.
Tip 1 : Practice String and array based questions for python coding test
Tip 2 : Practice Window Functions, Rank functions for SQL
Tip 3 : Describe the one project that you're confident with and have worked deeply
Tip 1 : Start with projects and then move to skills
Tip 2 : Explain each project in around 3 bullet points
Tip 3 : Include numbers in projects (ex increased x% revenue by applying ... )
I applied via Approached by Company and was interviewed in Jun 2022. There were 5 interview rounds.
I applied via Company Website and was interviewed in Sep 2023. There was 1 interview round.
I applied via Naukri.com and was interviewed before Nov 2020. There were 5 interview rounds.
I applied via Company Website and was interviewed in May 2019. There were 5 interview rounds.
I applied via Company Website and was interviewed in May 2019. There were 4 interview rounds.
Implemented a new customer feedback system that increased customer satisfaction by 20%
Implemented a new customer feedback system to gather insights and improve customer experience
Analyzed feedback data to identify common issues and areas for improvement
Implemented changes based on feedback to address customer concerns and enhance overall satisfaction
Trained team members on how to effectively use the new system and inte...
I applied via Recruitment Consultant and was interviewed in Aug 2017. There were 4 interview rounds.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Software Engineer
18
salaries
| ₹14.5 L/yr - ₹29 L/yr |
Research Analyst
15
salaries
| ₹10 L/yr - ₹15 L/yr |
Data Analyst
12
salaries
| ₹7.9 L/yr - ₹20 L/yr |
Software Developer
11
salaries
| ₹9 L/yr - ₹25.5 L/yr |
Senior Software Engineer
10
salaries
| ₹28 L/yr - ₹45.2 L/yr |
Adobe
Salesforce
Oracle
SAP