Pelican.ai Software Engineer Interview Questions and Answers

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

Given a text need to understand and solve

Some Java based and system design api was allowed to made

Q1. Introduction of myself
Add your answer
Q2. Salary discussion was done
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

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

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

Coding Round one. A string question

A String Question - Intermediate

2 dsa questions and mcqs

Q1. Questions on oops dsa
Add your answer

Q1. Discuss the project you are most proud of
Ans. 
Developed a mobile app for tracking personal fitness goals
• Used React Native to create a cross-platform app

• Implemented features such as goal setting, progress tracking, and workout logging

• Integrated with wearable devices like Fitbit for automatic data syncing
Answered by AI
Add your answer
Q2. What are ways to speed up SQL queries? List them in increasing order of complexity?
Ans. 
Ways to speed up SQL queries in increasing order of complexity
• Use indexes on columns frequently used in WHERE clauses

• Optimize queries by avoiding unnecessary joins and subqueries

• Use stored procedures to reduce network traffic and improve performance

• Consider denormalizing tables for frequently accessed data

• Use query optimization techniques like query caching and query hints
Answered by AI
Add your answer
Q3. Is Redis single-threaded or multi-threaded?
Ans. 
Redis is single-threaded.
• Redis is single-threaded, meaning it can only execute one command at a time.

• This design choice allows Redis to be extremely fast and efficient for certain use cases.

• However, it also means that Redis may not be the best choice for highly concurrent workloads.
Answered by AI
Add your answer
Q4. What sort of data types can be used as keys in Python?
Ans. 
Data types that can be used as keys in Python include strings, integers, floats, tuples, and custom objects.
• Strings are commonly used as keys in Python dictionaries.

• Integers and floats can also be used as keys.

• Tuples can be used as keys if they only contain immutable elements.

• Custom objects can be used as keys if they are hashable.

• Examples: {'name': 'John'}, {1: 'apple'}, {(1, 2): 'tuple'}
Answered by AI
Add your answer
Q5. What types of indexing exist in SQL?
Ans. 
Types of indexing in SQL include clustered, non-clustered, unique, and composite indexes.
• Clustered index physically reorders the table based on the index key

• Non-clustered index creates a separate structure for the index

• Unique index ensures that all values in the index column are unique

• Composite index uses multiple columns for indexing
Answered by AI
Add your answer