Filter interviews by
I applied via Recruitment Consulltant and was interviewed before Sep 2022. There were 3 interview rounds.
2-3 questions SQL-based questions on one sample dataset. They test for your knowledge on
- Window functions
- Complex joins
- Use of CTE's
- Query performance and cost optimization
Migrating data from on-premise servers to cloud storage
Identified data sources and destination in cloud storage
Developed ETL pipelines to extract, transform, and load data
Ensured data integrity and security during migration process
Monitored and optimized performance of data transfer
Collaborated with cross-functional teams for successful migration
I applied via Referral and was interviewed in Jun 2024. There were 2 interview rounds.
Create a program to print last 10 lines from a file and trigger itself every minute.
Read the file and store the last 10 lines in a data structure like a queue or array
Use a timer to trigger the program every minute
Print the last 10 lines from the data structure
I applied via Referral and was interviewed in Feb 2024. There was 1 interview round.
Pitch AlphaSense to a prospect and explain why they would use the AlphaSense platform.
AlphaSense interview questions for popular designations
I applied via Company Website and was interviewed before Sep 2023. There were 2 interview rounds.
Medium Code, Design, database design, Java
I applied via Job Portal and was interviewed in Apr 2024. There were 2 interview rounds.
HackerRank Test -> 2 Programs one with java logic and one for Selenium
I applied via LinkedIn and was interviewed in Jul 2023. There were 3 interview rounds.
Search index given a query and document
Design a search engine
Define the scope and purpose of the search engine
Determine the data sources and indexing strategy
Implement a ranking algorithm to prioritize search results
Design a user-friendly interface for search queries
Consider scalability and performance optimizations
Implement features like autocomplete and spell correction
Love marriage or arrange marriage
Sums and logistics questions
I applied via LinkedIn and was interviewed in Sep 2022. There were 4 interview rounds.
I was interviewed before May 2023.
I was interviewed in Jan 2021.
Round duration - 90 minutes
Round difficulty - Medium
2 Coding problems , MCQs (CS related, ML related)
An assignment is to link adjacent nodes at the same level in a binary tree. Each node in a binary tree has at most two children (left and right) and a next po...
Connect adjacent nodes at the same level in a binary tree by setting next pointers.
Traverse the tree level by level using a queue.
For each level, connect nodes using the next pointer.
Set the next pointer of the last node in each level to NULL.
Use constant space aside from input constraints.
Example: Input - 1 2 3 4 -1 5 6 -1 7 -1 -1 -1 -1 -1 -1, Output - 1 # 2 3 # 4 5 6 # 7 #
In a singly linked list, detect if a loop exists and remove the loop if present. Modify the linked list directly to eliminate any loops before returning it.
Detect and remove loop in a singly linked list efficiently.
Use Floyd's Cycle Detection Algorithm to detect the loop in the linked list.
Once the loop is detected, use two pointers to find the start of the loop.
Break the loop by setting the next pointer of the last node in the loop to null.
Round duration - 60 minutes
Round difficulty - Medium
2 Coding problems, No compilation of code. Only pseudocode required
Given two sorted arrays A
and B
of sizes N
and M
, find the median of the merged array formed by combining arrays A
and B
. If the total number of elements, N + M
, is even, the m...
Find the median of two sorted arrays by merging them and calculating the median of the combined array.
Merge the two sorted arrays into one sorted array.
Calculate the median of the merged array based on the total number of elements.
If the total number of elements is even, take the mean of the two middle elements as the median.
Given a binary tree, develop a solution to retrieve a list of all the leaf nodes in the order they appear from left to right. If two leaf nodes are equidistant fro...
Retrieve leaf nodes from a binary tree in left to right order, prioritizing lesser depth or smaller node data if equidistant from leftmost node.
Traverse the binary tree in level order and keep track of leaf nodes.
Prioritize leaf nodes with lesser depth or smaller node data if equidistant from leftmost node.
Return the list of leaf nodes in the order they appear from left to right.
Round duration - 40 minutes
Round difficulty - Hard
OS-CN fundamentals
A peer-to-peer connection is a network connection between two or more devices without the need for a central server.
Allows devices to communicate directly with each other
Each device can act as both a client and a server
Commonly used in file sharing applications like BitTorrent
Key concepts related to virtual memory and potential follow-up questions
Key concepts: paging, segmentation, page tables, TLB, page faults, thrashing
Follow-up questions: How does virtual memory differ from physical memory? What is the role of the operating system in managing virtual memory? How does virtual memory improve system performance?
Example: Explain the concept of page tables and how they are used in virtual mem
Tip 1 : Never leave any topic from any chapter / Subject
Tip 2 : Learn to explain your thoughts well
Tip 3 : Learn from previous experiences / interviews / problems asked.
Tip 4 : Atleast 4 projects in Resume
Tip 1 : Atleast 4 projects on Resume
Tip 2 : Do not write false things. You always get caught. Be genuine.
Top trending discussions
Some of the top questions asked at the AlphaSense interview -
based on 10 interviews
Interview experience
based on 37 reviews
Rating in categories
Content Analyst
43
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
27
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
23
salaries
| ₹0 L/yr - ₹0 L/yr |
QA Engineer
16
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
7
salaries
| ₹0 L/yr - ₹0 L/yr |
Bloomberg
Thomson Reuters
FactSet
S&P Global