Engineers Interview Questions

842,557 engineers interview questions shared by candidates

Excel Sheet Problem: Given a String in method return the column number. Or in other words, convert Excel column number in integer. Input: "A" Output: 1 Input: "AA" Output: 27 Explaination: Column A is very first column in Excel, so return 1.
avatar

Software Engineer

Interviewed at PlayStation

4.2
May 6, 2017

Excel Sheet Problem: Given a String in method return the column number. Or in other words, convert Excel column number in integer. Input: "A" Output: 1 Input: "AA" Output: 27 Explaination: Column A is very first column in Excel, so return 1.

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.

Viewing 1551 - 1560 interview questions

Glassdoor has 842,557 interview questions and reports from Engineers interviews. Prepare for your interview. Get hired. Love your job.