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
Depreciation is the decrease in value of an asset over time, while amortization is the process of spreading out the cost of an intangible asset over its useful life.
Depreciation is used for tangible assets like buildings, machinery, and vehicles.
Amortization is used for intangible assets like patents, copyrights, and trademarks.
Both are non-cash expenses that reduce the value of an asset on the balance sheet.
Depre...
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...
IRR stands for Internal Rate of Return, a financial metric used to calculate the profitability of an investment.
IRR is a discount rate that makes the net present value (NPV) of all cash flows from an investment equal to zero.
It is used to compare the profitability of different investments.
A higher IRR indicates a more profitable investment.
IRR can be calculated using Excel or financial calculators.
For example, if ...
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...
Mergers and acquisitions refer to the consolidation of companies through various financial transactions.
Mergers involve two companies joining together to form a new entity
Acquisitions involve one company purchasing another company
Mergers and acquisitions are often used as a growth strategy for companies
Examples include Disney's acquisition of Marvel, and the merger of Exxon and Mobil
NAV stands for Net Asset Value and is the value of a fund's assets minus its liabilities.
NAV is used to determine the price of a mutual fund or exchange-traded fund (ETF).
It is calculated by dividing the total value of the fund's assets by the number of outstanding shares.
NAV is updated at the end of each trading day.
Investors can use NAV to track the performance of their investments and to buy or sell shares of t...
Qualitative analysis involves subjective evaluation of non-numerical data while quantitative analysis involves objective evaluation of numerical data.
Qualitative analysis involves analyzing factors such as management quality, brand reputation, and industry trends.
Quantitative analysis involves analyzing financial statements, ratios, and other numerical data.
Both types of analysis are important in fundamental analy...
Working capital is the amount of money a company has available for its day-to-day operations.
Working capital is calculated by subtracting current liabilities from current assets.
It is important for a company to have enough working capital to pay for expenses such as salaries, rent, and inventory.
A positive working capital indicates that a company has enough assets to cover its short-term liabilities.
Examples of cu...
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.
Excel is a spreadsheet software developed by Microsoft for organizing, analyzing, and manipulating data.
Excel allows users to create tables, charts, and graphs to visualize data
It has built-in functions for calculations and data analysis
Excel can be used for budgeting, financial analysis, and project management
It supports macros and VBA programming for automation
Excel files can be shared and collaborated on throug...
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
- 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
- Executive Interview Questions
- System Engineer Interview Questions
- Show more
Overall Interview Experience Rating
based on 61 interview experiences
Difficulty level
Duration
Interview Questions from Similar Companies
Arcesium Reviews and Ratings
based on 336 reviews
Rating in categories
Hyderabad / Secunderabad
7-12 Yrs
Not Disclosed
|
Senior Analyst
385
salaries
|  ₹14.6 L/yr - ₹25.4 L/yr |
|
Analyst
327
salaries
| ₹10.2 L/yr - ₹19 L/yr |
|
Senior Software Engineer
252
salaries
| ₹25 L/yr - ₹43 L/yr |
|
Manager
162
salaries
| ₹23 L/yr - ₹38.5 L/yr |
|
Software Engineer
157
salaries
| ₹18 L/yr - ₹33 L/yr |
ITC Infotech
CMS IT Services
KocharTech
3i Infotech
- Home >
- Interviews >
- Arcesium Interview Questions
