Filter interviews by
I was interviewed in Oct 2021.
Round duration - 60 minutes
Round difficulty - Easy
It was my first round - they asked basics of OOPS,DBMS and operating systems. Be prepared with System Design also.
ACID properties are a set of properties that guarantee reliability and consistency in database transactions.
ACID stands for Atomicity, Consistency, Isolation, and Durability.
Atomicity ensures that a transaction is treated as a single unit of work, either all of its operations are executed or none.
Consistency ensures that a transaction brings the database from one valid state to another.
Isolation ensures that concurrent...
A transaction is a logical unit of work that consists of multiple database operations that must be executed as a single, indivisible unit.
A transaction ensures data consistency and integrity.
It follows the ACID properties: Atomicity, Consistency, Isolation, and Durability.
Transactions are used to maintain data integrity in databases.
Examples of transactions include transferring funds between bank accounts or updating i
SQL databases are relational databases that use structured query language, while NoSQL databases are non-relational databases that use various data models.
SQL databases are based on a fixed schema, while NoSQL databases are schema-less.
SQL databases are better suited for complex queries and structured data, while NoSQL databases are better for unstructured and semi-structured data.
SQL databases ensure ACID (Atomicity, ...
A semaphore is a synchronization object that controls access to a shared resource through the use of a counter.
Semaphores are used to manage concurrent access to shared resources in multi-threaded or multi-process environments.
They can be used to limit the number of threads or processes that can access a resource simultaneously.
Semaphores can have two types: counting semaphores and binary semaphores.
Counting semaphores...
Multitasking in Java can be achieved using threads.
Create multiple threads to execute tasks concurrently.
Use the Thread class or the Runnable interface to define the tasks.
Use synchronization mechanisms like locks or semaphores to coordinate access to shared resources.
Java provides built-in support for multitasking with the Thread class and the Executor framework.
Example: creating two threads to perform different tasks
Design a schema for a restaurant app like Zomato.
Create tables for restaurants, users, reviews, and orders
Include columns for restaurant details like name, address, cuisine type
Include columns for user details like name, email, and password
Link reviews to restaurants and users
Link orders to restaurants and users
Consider additional tables for menu items, categories, and ratings
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 4 : Prepare OS and DBMS properly.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Referral and was interviewed in Jul 2022. There were 2 interview rounds.
Coding test on online platform LC tagged
I applied via Company Website and was interviewed in Nov 2021. There were 4 interview rounds.
Topics include Quantitative aptitude, Accountancy, Economics, and General knowledge
Bonus issue is free shares given to existing shareholders while stock split is dividing existing shares into multiple shares.
Bonus issue increases the number of shares outstanding while stock split does not
Bonus issue is usually done to reward shareholders while stock split is done to make shares more affordable
Bonus issue does not affect the market capitalization while stock split does
Example of bonus issue: Infosys g...
The duration of a bond is the time until it reaches maturity. It is used to determine the bond's sensitivity to interest rate changes.
Duration is measured in years and can range from a few months to several decades
Longer duration bonds are more sensitive to interest rate changes than shorter duration bonds
Duration is an important factor to consider when investing in bonds
For example, a 10-year bond with a duration of 8...
I applied via Referral and was interviewed before Jun 2023. There was 1 interview round.
2 Greedy Algo problems
Arcesium interview questions for popular designations
I was interviewed in Aug 2021.
Round duration - 45 minutes
Round difficulty - Medium
2 coding questions were given to solve in 45 minutes.
You are given a binary tree of integers. Your task is to determine the left view of the binary tree. The left view consists of nodes that are visible when the tree...
The task is to determine the left view of a binary tree, which consists of nodes visible when viewed from the left side.
Traverse the binary tree in a level order manner and keep track of the leftmost node at each level.
Use a queue to perform level order traversal of the binary tree.
Maintain a count of nodes at each level to identify the leftmost node.
Return the leftmost nodes at each level as the left view of the binar
You are given a non-empty grid that consists of only 0s and 1s. Your task is to determine the number of islands in this grid.
An island is defined as a group of 1s (re...
The task is to determine the number of islands in a grid consisting of 0s and 1s.
Iterate through the grid and perform depth-first search (DFS) to find connected 1s.
Mark visited 1s as 0 to avoid counting them again.
Increment the island count each time a new island is found.
Consider all 8 adjacent cells (horizontally, vertically, diagonally) while performing DFS.
Handle edge cases like out of bounds and already visited ce
Round duration - 60 minutes
Round difficulty - Medium
This was a 60 min technical interview round. The interviewer asked me to code 2 programming questions.
Tip : Practice more to clear DSA problems. Medium level questions will be enough to clear the rounds.
Given a Directed Acyclic Graph (DAG) consisting of V
vertices and E
edges, your task is to find any topological sorting of this DAG. You need to return an array of size ...
Implement a function to find any topological sorting of a Directed Acyclic Graph (DAG).
Use Depth First Search (DFS) to traverse the graph and add vertices to the result in reverse order of finishing times.
Maintain a visited array to keep track of visited vertices to avoid revisiting them.
Start DFS from any unvisited vertex and recursively explore its neighbors.
Once all neighbors are visited, add the current vertex to t...
You are provided with a Singly Linked List containing integers. Your task is to determine the N-th node from the end of the list.
If the list is...
Find the N-th node from the end of a Singly Linked List containing integers.
Traverse the list to find the length L of the list.
Calculate the position of the N-th node from the beginning as L - N + 1.
Traverse the list again to reach the calculated position and return the node's value.
Handle edge cases like N being equal to 1 or equal to the length of the list.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
Get interview-ready with Top Arcesium Interview Questions
I applied via Company Website and was interviewed in Jan 2022. There were 2 interview rounds.
Equity Swap, Black Scholes, Option Pricing, CAPM are all financial concepts related to risk management and investment analysis.
Equity Swap is a financial contract between two parties to exchange cash flows based on the performance of an underlying asset.
Black Scholes is a mathematical model used to calculate the theoretical value of European-style options.
Option Pricing is the process of determining the fair value of a...
I applied via Recruitment Consulltant and was interviewed before Feb 2023. There was 1 interview round.
The minimum weight to reach the bottom right corner in a matrix starting from the top left by moving only down and right.
Use dynamic programming to calculate the minimum weight at each cell by considering the weights of the cells above and to the left.
At each cell, the minimum weight to reach that cell is the minimum of the weight of the cell itself plus the minimum weight of the cells above and to the left.
Example: Fo...
I applied via Instahyre and was interviewed in Oct 2021. There was 1 interview round.
Design a schema for a restaurant app like Zomato.
Create tables for restaurants, menus, reviews, and users.
Include columns for restaurant name, location, cuisine, and ratings.
Add columns for menu items, prices, and descriptions.
Include user information such as name, email, and password.
Create relationships between tables using foreign keys.
Implement search and filter functionality for restaurants and menus.
Allow users t...
A transaction is a unit of work that is performed on a database.
A transaction is a sequence of database operations that are treated as a single unit of work.
It ensures that all the operations are completed successfully or none of them are performed.
Transactions are used to maintain data consistency and integrity in a database.
Examples of transactions include transferring money between bank accounts or updating inventor
SQL is a relational database while NoSQL is a non-relational database.
SQL databases use structured query language while NoSQL databases use unstructured query language.
SQL databases are vertically scalable while NoSQL databases are horizontally scalable.
SQL databases are good for complex queries while NoSQL databases are good for large amounts of unstructured data.
Examples of SQL databases include MySQL, Oracle, and Po...
Multitasking in Java can be achieved through multithreading.
Create a new thread using the Thread class or Runnable interface
Use the start() method to start the thread
Synchronize shared resources to avoid race conditions
Use wait() and notify() methods for inter-thread communication
Example: creating a thread to perform a long-running task while the main thread continues executing other tasks
Semaphores are a synchronization tool used to control access to a shared resource.
Semaphores can be used to prevent race conditions in multi-threaded programs.
They can be used to limit the number of concurrent accesses to a resource.
Semaphores can be binary (0 or 1) or counting (0 to n).
Examples of semaphore functions include wait(), signal(), and init().
I was interviewed in Jul 2021.
Round duration - 45 minutes
Round difficulty - Medium
It was an online coding round where we were supposed to solve 2 coding questions in 45 minutes.
Given the schedule of N meetings with their start time Start[i]
and end time End[i]
, you need to determine which meetings can be organized in a single meeting room such ...
Given N meetings with start and end times, determine the maximum number of meetings that can be organized in a single room without overlap.
Sort the meetings based on their end times.
Iterate through the sorted meetings and select the first meeting that does not overlap with the previous one.
Repeat the process until all meetings are considered.
Return the selected meetings in the order they are organized.
You are given 'N' ropes, each of varying lengths. The task is to connect all ropes into one single rope. The cost of connecting two ropes is the sum of their lengths. Yo...
Given 'N' ropes of varying lengths, find the minimum cost to connect all ropes into one single rope.
Sort the lengths of ropes in ascending order.
Keep connecting the two shortest ropes at each step.
Update the total cost by adding the lengths of the connected ropes.
Repeat until all ropes are connected.
Return the total cost as the minimum cost to connect all ropes.
Round duration - 60 minutes
Round difficulty - Medium
The interview was conducted online. The interviewer asked me 2 programming questions and questions on OOPS concepts.
Given a binary tree, determine and return its bottom view when viewed from left to right. Assume that each child of a node is positioned at a 45-degree angle from its parent.
N...
Given a binary tree, return the bottom view of the tree when viewed from left to right.
Traverse the tree level by level and keep track of the horizontal distance of each node from the root.
For each horizontal distance, store the node with the maximum depth in a map.
After traversing the entire tree, return the values of the map in sorted order of their horizontal distance.
Given a binary tree of integers, your task is to implement serialization and deserialization methods. You can choose any algorithm for serialization...
Implement serialization and deserialization methods for a binary tree of integers.
Use level order traversal for serialization and deserialization.
Use -1 to represent null nodes in the binary tree.
Ensure the serialized string can be correctly decoded back to form the original binary tree.
Virtual destructors in C++ are used to ensure that the correct destructor is called when deleting an object through a base class pointer.
Virtual destructors are declared with the 'virtual' keyword in the base class to allow proper cleanup of derived class objects.
When deleting an object through a base class pointer, having a virtual destructor ensures that the destructor of the derived class is called.
Without a virtual...
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them
Tip 4 : One should have strong DSA skills and knowledge of Basic OOPS. Its not necessary to learn OS and DBMS if it's not taught in your college yet.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Company Website and was interviewed in Nov 2021. There were 3 interview rounds.
Top trending discussions
The duration of Arcesium interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 54 interviews
Interview experience
based on 299 reviews
Rating in categories
Senior Analyst
318
salaries
| ₹0 L/yr - ₹0 L/yr |
Analyst
314
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
223
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
186
salaries
| ₹0 L/yr - ₹0 L/yr |
Financial Analyst
153
salaries
| ₹0 L/yr - ₹0 L/yr |
Edelweiss
JPMorgan Chase & Co.
Goldman Sachs
Morgan Stanley