Miles Software Solution Interview Questions and Answers

The first round was a coding test, which was outsourced to an external vendor. I was asked 2 basic DSA questions, and there was discussions around the time and space complexity, and scope of optimizing the solutions. Post that there were a few questions around Spring Boot features and basic system design. The interviewer was professional throughout the interview, and the interview process felt more like a discussion, as compared to the standard interview process.

There was another round of coding - this time conducted by the organization itself. It consisted of a medium level DSA question on stacks. I wrote the code on my personal IDE and executed it there itself. The interviewer discussed about the possible edge cases and how I would deal with them. Post solving the question I was asked about my previous projects.

• Q1. Discuss in detail about a scenario where a challenging production issue was handled.
  Add Answer
• Q2. What are your responsibilities as a senior / team lead in the current organization?
  Add Answer
• Q3. How did you handle conflicts with junior engineers and reporting managers?
  Add Answer

This was the final round where the discussion was largely around system design and HLD. It started off with questions are system design patterns and concepts. Then I was asked to design a booking design, with discussions around concurrency control and transaction management.

• Q1. Froud company beware
  Add Answer
• Q2. After cleared all round they kept you on hold and after offer letter they revoke offer letter any time
  Add Answer

• Q1. Introduction to about your self
  Add Answer
• Q2. Experience and product knowledge
  Add Answer

SQL Joins and Window functions in SQL
Asked about Stored Procedures and implementations
Tableau LOD's
Tableau Parameters

• Q1. Hadoop architecture
  Add Answer
• Q2. Spark architecture
  Add Answer
• Q3. Difference between stage and task
  View Answers (1)
• Q4. Sql questions to solve
  Add Answer
• Q5. Scoop
  Add Answer
• Q6. Action and transformation in pysaprk
  View Answers (1)
• Q7. Difference between rdd and dataframe
  View Answers (1)

Asked to write a bank application - which includes adding,removing,transferring of money

How to increase personal insurance revenue to 5x?

• Q1. Leetcode medium question using heap
  Add Answer
• Q2. MySQL Queries using joins, group by, aggregate functions
  Add Answer

• Q1. Leetcode medium question of string
  Add Answer
• Q2. Database design for the notification service
  View Answers (1)