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
114 Interview questions
Cash expenses are payments made in cash, while non-cash expenses are expenses that do not involve cash payments.
Cash expenses are payments made in physical currency
Non-cash expenses are expenses that do not involve physical currency
Examples of cash expenses include rent paid in cash, cash purchases of supplies, etc.
Examples of non-cash expenses include depreciation, amortization, etc.
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...
Money market refers to a segment of the financial market where short-term borrowing and lending of funds take place.
Money market deals with short-term financial instruments such as treasury bills, commercial papers, certificates of deposit, etc.
It is a low-risk market with high liquidity and is used by governments, corporations, and financial institutions to manage their short-term cash needs.
Money market funds ar...
A pivot table is a data summarization tool used in spreadsheet programs like Excel.
It allows users to quickly summarize and analyze large amounts of data.
Users can easily rearrange the table to view data from different perspectives.
Pivot tables can perform calculations such as sums, averages, and counts.
They are commonly used in financial analysis and business reporting.
Example: A pivot table can be used to summar...
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...
A financial contract between two parties based on an underlying asset or security.
Derivatives are used to hedge against risk or speculate on future market movements.
Examples include options, futures, swaps, and forwards.
Derivatives can be traded on exchanges or over-the-counter.
They are complex financial instruments that require expertise to understand and use effectively.
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...
IPO process involves several steps from selecting underwriters to listing on stock exchange.
Selecting underwriters
Preparing registration statement
Roadshow and investor presentations
Pricing the IPO
Listing on stock exchange
Post-IPO activities such as reporting and compliance
Wealth and asset management involves managing and growing an individual's or organization's financial assets.
Wealth management focuses on managing high net worth individuals' assets and investments.
Asset management involves managing a portfolio of assets, such as stocks, bonds, and real estate, to maximize returns.
Both wealth and asset management involve developing investment strategies, monitoring performance, an...
DCF stands for Discounted Cash Flow, a valuation method used to estimate the value of an investment based on its future cash flows.
DCF takes into account the time value of money, meaning that a dollar received in the future is worth less than a dollar received today.
It involves projecting future cash flows of an investment and discounting them back to their present value using a discount rate.
The resulting present...
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 337 reviews
Rating in categories
|
Senior Analyst
405
salaries
|  ₹14.5 L/yr - ₹25.7 L/yr |
|
Analyst
331
salaries
| ₹10.2 L/yr - ₹18 L/yr |
|
Senior Software Engineer
253
salaries
| ₹25 L/yr - ₹43 L/yr |
|
Manager
175
salaries
| ₹23 L/yr - ₹38.5 L/yr |
|
Financial Analyst
161
salaries
| ₹11 L/yr - ₹17.8 L/yr |
ITC Infotech
CMS IT Services
KocharTech
3i Infotech
- Home >
- Interviews >
- Arcesium Interview Questions
