Filter interviews by
Simple case question about expected value. Question involved the expected price of attending a baseball game by purchasing tickets online, vs. a scalper, vs. watching online, etc.
Another simple case question. This time it was about optimizing a train station. You had to talk about which graphs you would make.
I worked with data to analyze customer feedback and improve product features.
Collected customer feedback through surveys and reviews
Organized data in spreadsheets for analysis
Identified trends and patterns to make recommendations for product improvements
Top trending discussions
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
Union combines the results of two or more SELECT statements, while Union all includes all rows, including duplicates.
Union removes duplicate rows from the result set, while Union all includes all rows.
Union sorts the result set, while Union all does not.
Union is slower than Union all because it performs a distinct operation.
Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;
Example: SELECT column1 FRO
Joins are generally faster than unions.
Joins are typically faster than unions because they combine data from multiple tables based on a common column, while unions combine data from multiple queries into a single result set.
Joins can utilize indexes on the columns being joined, which can improve performance.
Unions involve combining the results of multiple queries, which can be slower as it requires merging and sorting ...
A problem space was given with the list of metric and access to data with respect to the skillz free games
Had to answer the questions and perform an EDA and suggest recommendations
SQL question were asked
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
SQL query to retrieve employee names and their salaries from a table
Use SELECT statement to retrieve data
Specify the columns you want to retrieve (employee names and salaries)
Specify the table name where the data is stored
VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value.
VLOOKUP searches for a value in the first column of a table and returns a value in the same row from a specified column.
The formula syntax is =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]).
Example: =VLOOKUP(A2, B2:D10, 3, FALSE) will search for the value in cell A2 in the range B2:D10 and return the...
I applied via LinkedIn and was interviewed in Aug 2023. There were 2 interview rounds.
Contained aptitude test with both numericals as well as coding questions
It was a one on one round
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for a job that aligns with my career goals and offers growth opportunities.
I am open to exploring new cities and cultures.
I understand that relocation may come with some challenges, but I am prepared to face them.
I am excited about the prospect of working with a new team and contributing to the success of the company.
I applied via Referral and was interviewed before Apr 2023. There were 2 interview rounds.
I have 5 years of experience in manual testing, including creating test cases, executing tests, and reporting defects.
Created detailed test cases based on requirements
Executed test cases manually to identify defects
Reported defects and worked with developers to resolve issues
Performed regression testing to ensure quality of software
Used tools like Jira and TestRail for test management
I applied via Company Website and was interviewed in Dec 2019. There were 4 interview rounds.
Explanation of row number, rank, dense rank, partition by, indexing joins, and query optimization techniques.
Row number is a function that assigns a unique number to each row in a result set.
Rank is a function that assigns a rank to each row based on the values in a specified column.
Dense rank is a function that assigns a rank to each row based on the values in a specified column, but with no gaps in the ranking.
Partit...
Real-time examples of data analytics
Predictive maintenance in manufacturing
Real-time fraud detection in banking
Personalized recommendations in e-commerce
Real-time traffic analysis for smart cities
Real-time health monitoring in medical devices
I applied via Company Website and was interviewed before Apr 2020. There were 3 interview rounds.
Pole To Win
International Game Technology
Ubisoft Entertainment
Aristocrat Technologies