Esper Software Engineer Interview Questions and Answers

Q1. Edit distance problem
Ans. 
The edit distance problem involves finding the minimum number of operations required to transform one string into another.
• The edit distance problem can be solved using dynamic programming.

• Common operations include insertion, deletion, and substitution of characters.

• Example: Given strings 'kitten' and 'sitting', the edit distance is 3 (substitute 'k' with 's', insert 'g', substitute 'n' with 'g').
Answered by AI
Add your answer
Q2. Light switch puzzle
Add your answer

2 coding , 2 SQL with some quants

Q1. Remove redundant parentheses in a expression
Ans. 
Remove redundant parentheses in a expression
• Identify the innermost parentheses

• Evaluate the expression inside the innermost parentheses

• Replace the innermost parentheses with the evaluated expression

• Repeat until no more redundant parentheses exist
Answered by AI
Add your answer

Q1. Why do you want to join Chargebee?
Add your answer

A coding test on hackerrank with some basic graph problems

Q1. The interviewer asked about my projects
Add your answer

40 Aptitude Questions, one English test, 2 Easy Programming questions

Coding Round one. A string question

A String Question - Intermediate

2 coding questions were asked followed by an English test

Q1. I was asked to code for denomination of currency in JavaScript
Add your answer
Q2. JavaScript related questions like difference between double and triple equals to
Add your answer

Q1. This round was with senior member who asked me questions related to SQL queries. I don't exactly remember the question but it was nested query
Add your answer
Q2. I was asked questions related to the DBMS project and modifications that could be done in order to improve the model and performance
Add your answer

Q1. What's your motivation to join this team?
Ans. 
I am motivated to join this team because of the challenging work and the opportunity to learn and grow.
• I am excited about the projects this team is working on and the potential impact they can have.

• I am impressed by the team's expertise and collaborative approach.

• I am looking for a supportive and innovative work environment where I can contribute my skills and knowledge.

• I am eager to learn from my colleagues and develo...read more
Answered by AI
Add your answer
Q2. What are the projects/initiatives you have worked-on in your current role?
Ans. 
I have worked on multiple projects including developing a new e-commerce platform and implementing a machine learning algorithm for fraud detection.
• Developed a new e-commerce platform using React and Node.js

• Implemented a machine learning algorithm for fraud detection using Python and TensorFlow

• Collaborated with cross-functional teams to ensure project success

• Improved website performance by optimizing code and reducing
Answered by AI
Add your answer

Q1. Design VS code(any IDE)
Ans. 
Designing an IDE like VS code requires a deep understanding of software development and user experience.
• Identify the target audience and their needs

• Choose the programming languages and frameworks to support

• Create a user-friendly interface with customizable features

• Implement debugging and testing tools

• Ensure compatibility with different operating systems

• Continuously update and improve the IDE based on user feedback
Answered by AI
Add your answer
Q2. Discuss the architechture, limitations and abilities you would want in your app
Ans. 
The app architecture should be scalable, with a user-friendly interface and secure data storage.
• The app should have a modular architecture to allow for easy scalability and maintenance.

• The user interface should be intuitive and easy to navigate.

• The app should have robust security measures in place to protect user data.

• The app should be able to handle large amounts of data and traffic.

• The app should be compatible with m...read more
Answered by AI
Add your answer
Q3. The objective is not to code, but rather to discuss how would you implement certain features
Add your answer

Q1. No coding involved but deep JavaScript, CSS, Browser, APIs related questions were asked
Add your answer
Q2. Need to explain very minute details, explain working and uses
Add your answer
Q3. What is a CDN? How does the browser work?
Ans. 
CDN stands for Content Delivery Network. Browser works by sending requests to servers and receiving responses.
• CDN is a network of servers that deliver content to users based on their geographic location.

• CDN reduces latency and improves website performance.

• Browser sends HTTP requests to servers and receives responses containing HTML, CSS, JS, and other assets.

• Browser renders the received content and displays it to the u
Answered by AI
Add your answer
Q4. CSS positioning
Add your answer
Q5. Flexbox, Grid, Browser internals
Add your answer
Q6. NO DSA question ❌
Add your answer

You get 60 minutes to code an application in your choice of programming stack. Out of which 45 minutes are set aside for implementation and 15 minutes for problem discussion and conclusion.

Make sure that you think out loud while implementing the solution and not just silently coding.

Q1. Conclude the whole process, discuss salary expectations, perks, benefits, and other policy discussions
Add your answer

- 30 MCQ questions mostly related to HTML, JS & C#
- 2 easy-moderate coding questions

- Aptitude test on CoCubes (12 mins)
- English Test (speaking + writing + reading + listening) on Pearson platform

Q1. Print the following pattern: (was asked to complete test execution within 10 mins) ****4 ***444 **44444 *4444444 444444444
Add your answer
Q2. Find the length of longest substring composed of same digit, within a string of digits: (was asked to complete within 10 mins) E.g. 01241XXXXX901111 Output: 4 Explanation: "1111" is the longest substring
Ans. 
Find the length of longest substring composed of same digit within a string of digits.
• Iterate through the string and keep track of the current digit and its count

• Update the maximum count whenever a new digit is encountered

• Return the maximum count
Answered by AI
View 3 more answers
Q3. An SQL SPROC that is supposed to return tabular data is running slowly, what are the different ways you could debug it?
Ans. 1. Check for unnecessary columns in SELECT statement 2. Check if there's any cursor present in the SPROC 3. Check if columns have been properly indexed (specifically the columns being used in ORDER BY) 4. Check if data is being paged 5. etc.
Answered Anonymously
View 1 more answer
Q4. An API is running slow. Upon investigation it was found that SPROC running behind it is perfectly optimized. How can you debug this behavior of API? (You can neglect the resolve time & connect time of the ...read more
Ans. 
To debug the slow behavior of the API, analyze network latency, check for database issues, monitor server performance, and review code for potential bottlenecks.
• Analyze network latency to identify any issues with data transmission.

• Check for database issues such as slow queries or insufficient indexing.

• Monitor server performance to ensure it has enough resources and is not overloaded.

• Review the code for potential bottle...read more
Answered by AI
View 2 more answers

Q1. Check if two strings are anagrams of each other. Follow up question: solve it in O(N) time. (Time limit to solve question: 10 mins)
View 1 more answer
Q2. Given Tables: 1. Authors (AuthorId PK, Name) 2. Books (BookId PK, AuthorId FK, Name) 3. Orders (OrderId PK, BookID FK, AuthorId FK, StoreName) Write SQL query to print following information for each autho...read more
Add your answer
Q3. Questions about an open source distributive caching project that I implemented. Wanted to know what flaws do I see in the project and how do I plan to resolve them. Few follow up questions regarding cachin...read more
Add your answer

Q1. Given an array of integers (both positive and negative) find the maximum and second maximum number without using sort and using only single loop.
Ans. 
Find maximum and second maximum number in an array without using sort and single loop.
• Initialize max and secondMax variables to the smallest possible integer value

• Iterate through the array and update max and secondMax accordingly

• Return max and secondMax as the result
Answered by AI
View 1 more answer
Q2. Given Table: Weather (CityName, Date, Temperature) Write an SQL query which prints the following: "CityName, Today's Temperature, Yesterday's Temprature" (if yesterday's temperature doesn't exist, then p...read more
Add your answer
Q3. Given Table: ExamResults (StudentName, SubjectName, Marks) Write an SQL query to print the following: 1. "Student Name, Percentage" (Marks are out of 100) 2. List of all students having percentage great...read more
Add your answer