AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Arcesium Interview Questions and Answers
118 Interview questions
The subtotal function in Excel allows you to perform calculations on a filtered range of data.
The subtotal function can perform various calculations such as sum, average, count, etc. on a filtered range of data.
It ignores other subtotal functions within the range, preventing double counting.
You can specify which type of calculation to perform by using different function numbers.
For example, =SUBTOTAL(9, A1:A10) wi...
Custom contracts in futures and forwards are agreements between two parties that are tailored to meet specific needs or requirements.
Custom contracts allow parties to negotiate terms such as quantity, price, delivery date, and other specifications.
These contracts are not standardized like exchange-traded futures and forwards, making them flexible and customizable.
Examples of custom contracts include over-the-count...
This code swaps two numbers without using any Python libraries, utilizing basic arithmetic operations.
Use a temporary variable to hold one of the numbers during the swap.
Alternatively, use arithmetic operations (addition and subtraction) to swap without a temp variable.
Example using a temp variable: temp = a; a = b; b = temp.
Example using arithmetic: a = a + b; b = a - b; a = a - b.
SQL ranking functions help categorize data into ranks, with options for dense ranking and partitioning for grouped analysis.
RANK() assigns a unique rank to each row within a partition, with gaps for ties. Example: RANK() OVER (PARTITION BY department ORDER BY salary DESC).
DENSE_RANK() also assigns ranks but without gaps for ties. Example: DENSE_RANK() OVER (PARTITION BY department ORDER BY salary DESC).
PARTITION B...
SQL code using GROUP BY, HAVING, and COUNT to analyze data effectively.
GROUP BY aggregates data based on specified columns. Example: SELECT department, COUNT(*) FROM employees GROUP BY department;
HAVING filters aggregated data. Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10;
COUNT() function counts rows or non-null values. Example: SELECT COUNT(*) FROM sales WHERE am...
To remove a loop in a linked list, we can use Floyd's Cycle Detection Algorithm.
Use Floyd's Cycle Detection Algorithm to find the loop in the linked list.
Once the loop is detected, find the starting point of the loop using Floyd's algorithm.
Break the loop by setting the next pointer of the node before the starting point of the loop to null.
Implement a stack using two queues
Use two queues to simulate stack operations
Push operation: Enqueue the element to queue 1
Pop operation: Dequeue all elements from queue 1 to queue 2, dequeue the last element from queue 1, then swap the queues
Top operation: Return the front element of queue 1
Empty operation: Check if both queues are empty
Black Scholes Pricing of Derivatives is a mathematical model used to calculate the theoretical price of European-style options.
Developed by Fischer Black, Myron Scholes, and Robert Merton in 1973.
Factors in the current stock price, strike price, time to expiration, volatility, risk-free interest rate, and dividends.
Assumes the option can only be exercised at expiration (European-style).
Used to determine the fair m...
Yield on a bond can be calculated by dividing the annual interest payment by the current market price of the bond.
Yield on a bond is calculated by dividing the annual interest payment by the current market price of the bond.
The formula for calculating yield on a bond is: Yield = (Annual Interest Payment / Current Market Price) * 100%
For example, if a bond pays $50 in annual interest and is currently priced at $1,0...
To find a loop in a linked list, use Floyd's Cycle Detection Algorithm.
Use two pointers - slow and fast, where slow moves one step at a time and fast moves two steps at a time.
If there is a loop, the two pointers will eventually meet at some point within the loop.
To find the starting point of the loop, reset one pointer to the head and move both pointers one step at a time until they meet again.
Arcesium Interview Experiences
85 interviews found
Anonymous
I applied via Approached by Company and was interviewed in May 2024. There were 3 interview rounds.
Coding round with just one medium question. Not much complexity but, too much coding.
A two pointer question with medium level complexity like find distance to nearest 1 in an array of 1s and zeroes
(2 Questions)
- Q1. System design scenarios using sqs
- Ans.
Using SQS for system design scenarios
Implementing a message queue system for decoupling components
Scaling the system by adding more SQS queues for different functionalities
Using SQS to handle asynchronous processing of tasks
Integrating SQS with other AWS services like Lambda for serverless architecture
- Q2. System design scenarios for enough monitoring and alarming
- Ans.
Implementing system design scenarios for monitoring and alarming
Utilize monitoring tools like Prometheus, Grafana, or Nagios to collect and visualize data
Set up alerts based on predefined thresholds for key metrics
Implement a centralized logging system like ELK stack to track system behavior
Utilize distributed tracing tools like Jaeger or Zipkin to monitor request flows
Implement health checks for services to ensure the...
Interview Preparation Tips
Skills evaluated in this interview
I applied via Naukri.com and was interviewed in Sep 2024. There were 3 interview rounds.
1 python question and 1 sql question for coding and rest were the mcqs based on sql and python.
(2 Questions)
- Q1. Python code was asked for checking the anagrams
- Ans.
This code checks if two strings are anagrams by comparing sorted characters or using a frequency count.
An anagram is a word formed by rearranging the letters of another, e.g., 'listen' and 'silent'.
Method 1: Sort both strings and compare. Example: sorted('listen') == sorted('silent').
Method 2: Count character frequencies using collections.Counter. Example: Counter('listen') == Counter('silent').
Consider case sensitivit...
- Q2. Sql code asked to solve on screen share using various use cases like group by, having, count
- Ans.
SQL code using GROUP BY, HAVING, and COUNT to analyze data effectively.
GROUP BY aggregates data based on specified columns. Example: SELECT department, COUNT(*) FROM employees GROUP BY department;
HAVING filters aggregated data. Example: SELECT department, COUNT(*) FROM employees GROUP BY department HAVING COUNT(*) > 10;
COUNT() function counts rows or non-null values. Example: SELECT COUNT(*) FROM sales WHERE amount ...
(2 Questions)
- Q1. Python code was asked for swaping any number but without using python libraries
- Q2. Sql code was asked using concepts of rank dense,rank, partition by
- Ans.
SQL ranking functions help categorize data into ranks, with options for dense ranking and partitioning for grouped analysis.
RANK() assigns a unique rank to each row within a partition, with gaps for ties. Example: RANK() OVER (PARTITION BY department ORDER BY salary DESC).
DENSE_RANK() also assigns ranks but without gaps for ties. Example: DENSE_RANK() OVER (PARTITION BY department ORDER BY salary DESC).
PARTITION BY div...
Sriyansh Srivastava
I applied via Company Website and was interviewed in Sep 2024. There was 1 interview round.
(7 Questions)
- Q1. Introduction and work ex based questions ?
- Q2. Why this role what did u understand from the jd
- Q3. Binary search how would u search a name in a directory how would u optimize this
- Q4. Futures and forwards what are custom contracts
- Ans.
Custom contracts in futures and forwards are agreements between two parties that are tailored to meet specific needs or requirements.
Custom contracts allow parties to negotiate terms such as quantity, price, delivery date, and other specifications.
These contracts are not standardized like exchange-traded futures and forwards, making them flexible and customizable.
Examples of custom contracts include over-the-counter (O...
- Q5. Option greeks delta theta
- Q6. Std deviation weighted avg
- Q7. What is derivatives
Interview Preparation Tips
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Dec 2024. There was 1 interview round.
(2 Questions)
- Q1. Detailed resume based questions
- Q2. Product level improvements etc
(2 Questions)
- Q1. About different journal entries
- Q2. About different financial Instruments
(2 Questions)
- Q1. Journal entries
- Q2. Financial Instruments
(1 Question)
- Q1. What do you know About CDS?
- Ans.
A Credit Default Swap (CDS) is a financial derivative that allows an investor to 'swap' or transfer credit risk with another party.
CDS are used to hedge against the risk of default on debt instruments, such as bonds.
For example, if an investor holds a corporate bond, they can buy a CDS to protect against the risk of the company defaulting.
The buyer of a CDS pays periodic premiums to the seller, who agrees to compensate...
Principal Engineer and Solutions Architecture Interview Questions & Answers
SUMIT SHARMA
posted on 31 May 2024
I appeared for an interview in May 2024.
Hacker rank test, coding for one big question, ample time given of around 90 mins
(2 Questions)
- Q1. Basics of current project
- Q2. Design historical pricing app for equity
- Ans.
Design a historical pricing app for equity
Utilize a database to store historical pricing data for equities
Implement a user-friendly interface for users to search and view historical pricing
Include features such as chart visualization, comparison tools, and customizable date ranges
Consider incorporating real-time data updates and alerts for price changes
(2 Questions)
- Q1. Project discussion
- Q2. Design a app which will bring data from lot of external vendors in different formats
- Ans.
Design an app to bring data from external vendors in different formats
Create a data ingestion pipeline to collect data from various vendors
Implement data transformation processes to standardize formats
Utilize APIs or web scraping techniques to retrieve data from vendors
Use a database to store and manage the collected data
Implement data validation and cleansing techniques to ensure data quality
(2 Questions)
- Q1. Project discussion
- Q2. Role discussion and team fitment
Interview Preparation Tips
I did not get through, it was a bit disappointing but overall experience was good.
Skills evaluated in this interview
Was asked 30 mcq technical questions and one dsa question which as basic string based.
(2 Questions)
- Q1. Remove a loop in linked list
- Ans.
To remove a loop in a linked list, we can use Floyd's Cycle Detection Algorithm.
Use Floyd's Cycle Detection Algorithm to find the loop in the linked list.
Once the loop is detected, find the starting point of the loop using Floyd's algorithm.
Break the loop by setting the next pointer of the node before the starting point of the loop to null.
- Q2. Implement stack using queues
- Ans.
Implement a stack using two queues
Use two queues to simulate stack operations
Push operation: Enqueue the element to queue 1
Pop operation: Dequeue all elements from queue 1 to queue 2, dequeue the last element from queue 1, then swap the queues
Top operation: Return the front element of queue 1
Empty operation: Check if both queues are empty
Skills evaluated in this interview
I applied via Company Website and was interviewed in Jun 2024. There were 3 interview rounds.
3 questions, medium hard
(2 Questions)
- Q1. Greedy Algorithm, simple jumps question, easily approachable by greedy algorithm
- Q2. Binary Search, simple array based
(2 Questions)
- Q1. DBMS, Projects, SQL Queries
- Q2. 2 coding questions
I applied via Company Website and was interviewed in Jul 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Find the missing number in a permutation array
- Ans.
Find the missing number in a permutation array
Iterate through the array and calculate the sum of all numbers
Calculate the sum of all numbers from 1 to n (where n is the length of the array)
Subtract the sum of the array from the sum of all numbers to find the missing number
- Q2. Find if there is a loop in linked list
- Ans.
To find a loop in a linked list, use Floyd's Cycle Detection Algorithm.
Use two pointers - slow and fast, where slow moves one step at a time and fast moves two steps at a time.
If there is a loop, the two pointers will eventually meet at some point within the loop.
To find the starting point of the loop, reset one pointer to the head and move both pointers one step at a time until they meet again.
Leetcode medium level questions, sql query, puzzle, test writing for api
Skills evaluated in this interview
I applied via Recruitment Consulltant and was interviewed in Jul 2024. There was 1 interview round.
(2 Questions)
- Q1. Basic to Intermediate SQL Based questions
- Q2. Basic to Intermediate Python Based questions
Top trending discussions
Arcesium Interview FAQs
Some of the top questions asked at the Arcesium interview -
The duration of Arcesium interview process can vary, but typically it takes about less than 2 weeks to complete.
Tell us how to improve this page.
Arcesium Interviews By Designations
- Arcesium Analyst Interview Questions
- Arcesium Senior Software Engineer Interview Questions
- Arcesium Software Engineer Interview Questions
- Arcesium Data Analyst Interview Questions
- Arcesium Financial Analyst Interview Questions
- Arcesium Software Developer Intern Interview Questions
- Arcesium Product Manager Interview Questions
- Arcesium Junior Analyst Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 61 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Arcesium Reviews and Ratings
based on 335 reviews
Rating in categories
|
Senior Analyst
396
salaries
|  ₹10 L/yr - ₹27 L/yr |
|
Analyst
324
salaries
| ₹7.6 L/yr - ₹20.5 L/yr |
|
Senior Software Engineer
253
salaries
| ₹25 L/yr - ₹43 L/yr |
|
Financial Analyst
160
salaries
| ₹10.2 L/yr - ₹19 L/yr |
|
Software Engineer
158
salaries
| ₹12 L/yr - ₹33.7 L/yr |
ITC Infotech
CMS IT Services
KocharTech
3i Infotech
- Home >
- Interviews >
- Arcesium Interview Questions
