Engineer Interview Questions

935,166 engineer interview questions shared by candidates

From SQL: 1. If there are 2 tables with m and n rows respectively, then what will be the minimum and maximum number of rows in all the joins. 2. Get the 3rd highest employee salary from employee salary table. 3. Given a product table, the new record gets appended in table with the new timestamp for the product ID. Find out the latest row for that particular product with or without analytical functions. 4. Given there are 2 tables of employee details and employee project details, which all employee are not yet assigned a project. For python: 1. Given a product data frame, the new record gets appended in table with the new timestamp for the product ID. Find out the latest data frame for that particular product with pandas.
avatar

Business Intelligence Engineer

Interviewed at Amazon

3.5
Jul 8, 2022

From SQL: 1. If there are 2 tables with m and n rows respectively, then what will be the minimum and maximum number of rows in all the joins. 2. Get the 3rd highest employee salary from employee salary table. 3. Given a product table, the new record gets appended in table with the new timestamp for the product ID. Find out the latest row for that particular product with or without analytical functions. 4. Given there are 2 tables of employee details and employee project details, which all employee are not yet assigned a project. For python: 1. Given a product data frame, the new record gets appended in table with the new timestamp for the product ID. Find out the latest data frame for that particular product with pandas.

SQL question: 1 table with player_id, log in date, and 2 other fields and was asked to calculate first day retention rate. First day retention rate is defined as the player who log in the 2nd straight day, after the first ever time they log into game.
avatar

Data Engineer

Interviewed at Amazon

3.5
May 8, 2021

SQL question: 1 table with player_id, log in date, and 2 other fields and was asked to calculate first day retention rate. First day retention rate is defined as the player who log in the 2nd straight day, after the first ever time they log into game.

puzzle : there is a island and the resident are either blue or black eyed. The residents are trapped in the island and want to leave. One day a foreigner comes and says there are few blue eyed people. He will be sending a steamer to the island every day and blue eyed people can leave. But if a black eyed person approaches the steamer, he will be killed. Constraint: No body knows their eye colour and can't even ask or say the colour to any other person. even cant see their reflection. So how many days is required for all the blue eyed person to leave the island.
avatar

Senior Software Engineer

Interviewed at MakeMyTrip

4.1
Aug 26, 2016

puzzle : there is a island and the resident are either blue or black eyed. The residents are trapped in the island and want to leave. One day a foreigner comes and says there are few blue eyed people. He will be sending a steamer to the island every day and blue eyed people can leave. But if a black eyed person approaches the steamer, he will be killed. Constraint: No body knows their eye colour and can't even ask or say the colour to any other person. even cant see their reflection. So how many days is required for all the blue eyed person to leave the island.

Viewing 1701 - 1710 interview questions

Glassdoor has 935,166 interview questions and reports from Engineer interviews. Prepare for your interview. Get hired. Love your job.