Skip to contentSkip to footer

Engineer Interview Questions

Salaries
Interviews

934,946 engineer interview questions shared by candidates

Problem Statement : 18 Ralway Stations from Tamil Nadu are given. A passenger need ticket. Upto the 5 stations journey, fare is 10 Rs. After the 5 stations, for every 5 stations, 5 Rs extra will be charged. For the full stretch journey i.e. From 1st to the last station, fare is 20 Rs. Input 1 : StationFrom - Guindy, StationTo - Kadambakkam Output 1 : Print ticket. i.e. StationFrom : Guindy, StationTo : Kadambakkam, Total Stops : 3, Total Fare : 10 Input 2 : StationFrom - Guindy , StationTo - Chennai Fort Output 2 : Print ticket. i.e. StationFrom : Guindy, StationTo : Chennai Fort, Total Stops : 8, Total Fare :15 Code should follow design principles, patterns. Test Driven Development would be preferable, not mandatory though.
avatar

Software Developer

Interviewed at Thoughtworks

4★
Aug 28, 2015

Problem Statement : 18 Ralway Stations from Tamil Nadu are given. A passenger need ticket. Upto the 5 stations journey, fare is 10 Rs. After the 5 stations, for every 5 stations, 5 Rs extra will be charged. For the full stretch journey i.e. From 1st to the last station, fare is 20 Rs. Input 1 : StationFrom - Guindy, StationTo - Kadambakkam Output 1 : Print ticket. i.e. StationFrom : Guindy, StationTo : Kadambakkam, Total Stops : 3, Total Fare : 10 Input 2 : StationFrom - Guindy , StationTo - Chennai Fort Output 2 : Print ticket. i.e. StationFrom : Guindy, StationTo : Chennai Fort, Total Stops : 8, Total Fare :15 Code should follow design principles, patterns. Test Driven Development would be preferable, not mandatory though.

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 1671 - 1680 interview questions

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