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
130 Interview questions
Valuation ratios are used to evaluate the financial health of a company by comparing its stock price to relevant financial metrics.
Price-to-earnings ratio (P/E ratio)
Price-to-sales ratio (P/S ratio)
Price-to-book ratio (P/B ratio)
Enterprise value-to-EBITDA ratio (EV/EBITDA ratio)
Dividend yield ratio
Market capitalisation is the total value of a company's outstanding shares.
Market capitalisation is calculated by multiplying the current market price of a company's stock by the total number of outstanding shares.
It is used to determine the size of a company and its relative importance in the market.
Companies with higher market capitalisation are generally considered to be more stable and less risky investments.
F...
CAPM stands for Capital Asset Pricing Model.
CAPM is a financial model used to determine the expected return on an investment based on its risk.
It takes into account the risk-free rate, market risk premium, and beta of the investment.
The formula for CAPM is: expected return = risk-free rate + beta x (market risk premium).
CAPM is widely used in finance and investment management.
It helps investors make informed decis...
Shares are units of ownership in a company. Different types of shares include common shares, preferred shares, and dual-class shares.
Common shares give shareholders voting rights and a share in the company's profits.
Preferred shares give shareholders priority in receiving dividends and assets in case of bankruptcy.
Dual-class shares give certain shareholders more voting power than others.
Other types of shares inclu...
Accounting concepts and conventions are the basic principles and guidelines followed in the preparation of financial statements.
Accounting concepts are the fundamental ideas and assumptions that underlie the preparation of financial statements.
Accounting conventions are the practices and procedures that are generally accepted in the accounting profession.
Examples of accounting concepts include the going concern co...
Capital is money used to start or grow a business. Primary market is where new securities are issued. Secondary market is where existing securities are traded.
Capital is the money used to start or grow a business.
Primary market is where new securities are issued for the first time, such as initial public offerings (IPOs).
Secondary market is where existing securities are traded, such as stocks and bonds.
Investors b...
Call and put options are financial contracts that give the buyer the right, but not the obligation, to buy or sell an underlying asset at a predetermined price within a specified time period.
Call option: gives the buyer the right to buy an underlying asset at a predetermined price within a specified time period.
Put option: gives the buyer the right to sell an underlying asset at a predetermined price within a spec...
Yes, an individual can set up a mutual fund company.
The individual needs to fulfill the eligibility criteria set by SEBI.
They need to have a minimum net worth of Rs. 50 lakhs.
They need to have a team of professionals with relevant experience.
Examples of individuals who have set up mutual fund companies include Radhakishan Damani (D-Mart founder) and Rakesh Jhunjhunwala (investor).
Three important statements in annual report are income statement, balance sheet, and cash flow statement.
Income statement shows the company's revenue and expenses over a period of time.
Balance sheet shows the company's assets, liabilities, and equity at a specific point in time.
Cash flow statement shows the company's inflow and outflow of cash over a period of time.
These statements provide important financial info...
IF function in Excel is used to test a condition and return one value if the condition is true and another value if the condition is false.
IF function is a logical function in Excel
It takes three arguments: logical_test, value_if_true, and value_if_false
Logical_test is the condition that needs to be tested
Value_if_true is the value that is returned if the condition is true
Value_if_false is the value that is return...
Arcesium Interview Experiences
85 interviews found
Anonymous
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
411
salaries
|  ₹14.6 L/yr - ₹25.6 L/yr |
|
Analyst
325
salaries
| ₹10.5 L/yr - ₹19 L/yr |
|
Senior Software Engineer
253
salaries
| ₹25 L/yr - ₹43 L/yr |
|
Manager
157
salaries
| ₹22 L/yr - ₹37.8 L/yr |
|
Software Engineer
156
salaries
| ₹18.5 L/yr - ₹33.8 L/yr |
ITC Infotech
CMS IT Services
KocharTech
3i Infotech
- Home >
- Interviews >
- Arcesium Interview Questions
