Difference between an int & a float? Bitmap vs. Hashing?
Junior Software Engineer Interview Questions
7,341 junior software engineer interview questions shared by candidates
SQL - given 2 tables, employees and departments, write an SQL statement that shows the employees with the max salary from each department (some departments can have multiple employees with max salary)
Where else have you applied?
Salary expectations, passions/hobbies, past professional experiences
What is synchronous condenser? What is DC series motor?
find the common parent node for any children int the binary tree
1) product management interview 2) technology interview was good 3)hr interview with a senior engineer
Where do you see yourself in 10 years?
IBM is implementing a streaming analytics service for an online retailer to provide data on the best time to sell specific products. To accomplish this goal, the service needs a very fast way to calculate a number of basic formulas for a series of dates, quantity and product id. Assumptions: In production, the list of data could be in the hundreds of thousands of dates with quantities and product ids. The service will be called frequently as the user explores different data models. The data may not be normalized. There could be multiple lines with the same date and product id. In these cases you should sum all the quantity on input and work on that. Product ids are case sensitive. Input: Each line will contain a comma separated list of text date (yyyy-mm-dd), quantity, product id. For example: 2017-06-02,5,Apples 2017-06-02,2,pears 2017-06-03,3,pineapples Output: For each date create a line of this format: date, total items sold for date, average quantity of all items (to 2 decimal places), count of unique parts sold. For example:
It consists of 5 rounds including HR round. First round is online aptitude test which consists of 20 questions(10 aptitude + 10 pseudocode) 30mins. Second round consists of 8 questions (4 programming + 4 SQL query) 90mins. Then there will be 2 technical rounds. First technical round will be for 30mins and questions will be on SQL basics , based on our project , any programming language questions which we are strong in and we will be asked to write a small code based on a problem and one simple sql query.
Viewing 5571 - 5580 interview questions