As most of the common interview questions such as why I applied for the job etc were asked in the phone interview, the questions in the face to face interview included open-end questions where I had to give 3 examples of challenging scenarios and how I did overcome them.
Do you have experience in handling tickets?
Some easy to high level
Describe a situation where you had to deal with a difficult client.
How would you handle a difficult customer situation
Where do you still yourself in the next few years?
Table 1: Analysis.dimProducts Column DataType ProductID INT(PK) Identity Name Varchar(100) Cost money Table 2: Analysis.dimCustomers Column DataType CustomerID Int (PK) IDENTITY FirstName Varchar(100) LastName Varchar(100) Table 3: Analysis.dimSales Column DataType SalesID INT (PK) IDENTITY ProductID INT (FK) CustomerID INT (FK) Quantity INT Questions 1. Write a query that would return the cost associated with a product of the name of “Shampoo” 2. Write a query that would return the first and last name (with one column as the return set instead of two) of all customers 3. Write a query that would return all sales associated with a customer with the first name of “Bob” and the last name of “Smith” 4. Write a query that would return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”. 5. Alter the query in question #4 to return the total number of products purchased by a customer with the first name of “Bob” and the last name of “Smith”, but still returning a value of zero if that name had no sales 6. Write a query that would return the amount of money made in revenue total based on the sales made of products. The result should be just one column. 7. Insert a new customer with the name of “Phil” and the last name of “Frank” 8. Delete a product with the name of “Shampoo” (make sure to incorporate all tables that would need to be validated before you do this delete) 9. Using joins, update the amount of the product “Shampoo” ordered by a customer with the name “Bob Smith” to 5 (assume there’s only one SaleID that represents this customer)
What is your customer service philosophy?
Tell us about a time that you managed a project from the beginning to the end. Be as specific as possible; tell us everything about your role in this project.
I was asked How do I manage the work pressure.
Viewing 441 - 450 interview questions