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 for Experienced
18 Interview questions
Mandatory fields to check bond income in Bloomberg
To check bond income in Bloomberg, mandatory fields to be checked are bond identifier, coupon rate, maturity date, and price.
The bond identifier can be ISIN, CUSIP, or Bloomberg ticker.
Coupon rate is the interest rate paid by the bond issuer to the bondholder.
Maturity date is the date when the bond will be redeemed.
Price is the current market price of the bond.
Othe...
A total return swap is a financial contract in which one party agrees to make payments based on the total return of an underlying asset.
Total return swap involves exchanging the total return of an asset or index for a fixed or floating rate of interest
It allows investors to gain exposure to an asset without actually owning it
The party receiving the total return pays a fixed or floating rate of interest to the othe...
XPath is a language used to navigate XML documents and identify elements.
XPath is a query language for selecting nodes from an XML document.
It uses path expressions to navigate through elements and attributes.
XPath can be used to locate elements based on their attributes, text content, or position in the document.
It is commonly used in software testing to locate specific elements for verification or manipulation.
E...
Options strategies involve buying or selling options contracts to achieve a specific investment goal.
Some common options strategies include covered calls, protective puts, straddles, and strangles.
Each options strategy has its own risk and reward profile, and is used based on market conditions and investor objectives.
Options strategies can be used for speculation, hedging, income generation, or risk management.
Und...
Hashing is a process of converting data into a fixed-size output. Collision occurs when two different inputs produce the same output.
Hashing is used for indexing and retrieving data quickly
Hash functions should be deterministic and produce the same output for the same input
Collisions can be resolved using techniques like chaining or open addressing
Examples of hashing algorithms include MD5, SHA-1, and SHA-256
Creating a table in SQL and demonstrating functions on it
Create a table using CREATE TABLE statement
Insert data into the table using INSERT INTO statement
Retrieve data from the table using SELECT statement
Update data in the table using UPDATE statement
Delete data from the table using DELETE statement
Count Subarrays with Sum Divisible by K
Given an array ARR and an integer K, your task is to count all subarrays whose sum is divisible by the given integer K.
Input:
The first line of input contains an ...Count subarrays with sum divisible by K in an array.
Iterate through the array and keep track of prefix sum modulo K.
Use a hashmap to store the frequency of each prefix sum modulo K.
For each prefix sum, increment the count by the frequency of (prefix sum - K) modulo K in the hashmap.
Handle the case where prefix sum itself is divisible by K separately.
Return the total count of subarrays with sum divisible by K.
Minimum Operations to Equalize Array
Given an integer array ARR of length N where ARR[i] = (2*i + 1), determine the minimum number of operations required to make all the elements of ARR equal. In a single ...
The minimum number of operations required to make all elements of the given array equal is calculated by finding the median of the array elements.
Calculate the median of the array elements to determine the target value for all elements to be equal.
Find the absolute difference between each element and the target value, sum these differences to get the minimum number of operations.
For odd length arrays, the median i...
Arcesium Interview Experiences for Experienced
30 interviews found
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
Anonymous
Aptitude test with general capital market questions
(1 Question)
- Q1. How to calculate yield on bond
- Ans.
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,000, t...
(1 Question)
- Q1. What are some of your strengths
- Ans.
Some of my strengths include strong analytical skills, attention to detail, and the ability to work well under pressure.
Strong analytical skills - able to analyze data and identify trends
Attention to detail - meticulous in reviewing work for accuracy
Ability to work well under pressure - can remain calm and focused in high-stress situations
Pratik Pahwa
I applied via Job Portal and was interviewed in Sep 2024. There was 1 interview round.
It was on hackerrank platform with some MCQs and 2 coding questions each of Python and SQL
Interview Preparation Tips
Selected
I applied via Approached by Company and was interviewed in May 2024. There were 3 interview rounds.
General aptititude including finance questions , mathematics
(1 Question)
- Q1. General finance and accounting related questions
(1 Question)
- Q1. Same as round 2
Interview Preparation Tips
Selected
I appeared for an interview in Nov 2024, where I was asked the following questions.
- Q1. Core technical skills in the current profile
- Q2. Communication skills
- Q1. Types of swaps
- Q2. Structure of hedge funds
- Q3. What is Bond duration?
- Ans.
Bond duration measures a bond's sensitivity to interest rate changes, reflecting the time it takes to receive cash flows.
Duration is expressed in years and indicates the weighted average time to receive bond cash flows.
A bond with a duration of 5 years will have its price change by approximately 5% for a 1% change in interest rates.
There are different types of duration: Macaulay duration, modified duration, and effecti...
Mayank Upadhyaya
I applied via LinkedIn and was interviewed in Dec 2023. There were 3 interview rounds.
Httpclient implementation for getting response feed from an GitHub api , parse response and print
(1 Question)
- Q1. Topological sorting given n jobs find order of deployment of jobs least dependent first
(1 Question)
- Q1. Hld design on job scheduler, understanding how to create an job scheduler service in distributed system
Skills evaluated in this interview
Test was easy, basic gk and finance knowledge was asked too
(1 Question)
- Q1. Basic accounting, eco and derivatives question
Interview Preparation Tips
Hard 2 questions in 45 mins
Selected
I appeared for an interview before Jun 2024, where I was asked the following questions.
- Q1. What are your reasons for wanting to join this organization?
- Ans.
I am drawn to this organization for its commitment to innovation, growth opportunities, and a collaborative work culture.
The organization's reputation for excellence in financial operations aligns with my career goals.
I admire the company's focus on sustainability and ethical practices, which resonates with my values.
The opportunity to work with a diverse team excites me, as I believe collaboration fosters creativity a...
- Q2. Accounting question
Top trending discussions
Arcesium Interview FAQs
Some of the top questions asked at the Arcesium interview for experienced candidates -
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
- Analyst Interview Questions
- Senior Software Engineer Interview Questions
- Software Engineer Interview Questions
- Financial Analyst Interview Questions
- Software Developer Intern Interview Questions
- Data Analyst Interview Questions
- Graduate Engineer Trainee (Get) Interview Questions
- Manager Interview Questions
- Show more
Overall Interview Experience Rating
based on 19 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Arcesium Reviews and Ratings
based on 334 reviews
Rating in categories
Hyderabad / Secunderabad,
Gurgaon / Gurugram
+15-9 Yrs
Not Disclosed
|
Senior Analyst
396
salaries
|  ₹14.6 L/yr - ₹25 L/yr |
|
Analyst
324
salaries
| ₹7.6 L/yr - ₹20.5 L/yr |
|
Senior Software Engineer
253
salaries
| ₹15 L/yr - ₹43 L/yr |
|
Financial Analyst
161
salaries
| ₹8.5 L/yr - ₹19 L/yr |
|
Manager
161
salaries
| ₹17 L/yr - ₹47.6 L/yr |
ITC Infotech
CMS IT Services
KocharTech
3i Infotech
- Home >
- Interviews >
- Arcesium Interview Questions >
- Arcesium Interview Questions for Experienced
