Xceedance Senior Analyst II Interview Questions and Answers

Coding Test on HackerRank - 2 coding Questions, 1 hour Duration

Q1. Python Programming Constructs, Lists , Dictionaries
Add your answer
Q2. Knowledge of mathematical and statistical concepts were evaluated
Add your answer
Q3. Questions on evaluation metrics for Classification and Regression
Add your answer

Q1. Why Evalueserve, Salary expectations
Add your answer

Prepare a presentation on BWM market

Q1. Detailed analysis on the presentation prepared
Add your answer
Q2. Questions on methodology
Add your answer

Q1. Tableau Questions 1. Difference between dimensions and measures. 2. What is RLS? 3. What are the functions you can assign in RLS? 4. Explain what is drill down approach. 5. What is LOD? 6. What is a calcul...read more
Add your answer
Q2. SQL Questions 1. In employee table find the 2nd highest salary. 2. Find the highest average salary in department 3. Given two tables(sales & product) find total sales per category 4. Two questions to find ...read more
Add your answer

Q1. Prior Experience
Add your answer
Q2. Capital Market, Hedge Fund
Add your answer
Q3. Derivatives, Scenario-based question
Add your answer

Q1. Prior Experience
Add your answer
Q2. How do you handle escalations?
Ans. 
I handle escalations by addressing the issue promptly, involving necessary stakeholders, and providing regular updates.
• Address the issue promptly to prevent further escalation

• Involve necessary stakeholders to gather input and support

• Provide regular updates to all parties involved to ensure transparency and progress

• Implement solutions to prevent similar escalations in the future
Answered by AI
Add your answer
Q3. What was the toughest escalation I have ever managed
Add your answer
Q4. Excel - Index, Match, Lookups - XLookup, VLookup, HLookup
Add your answer
Q5. Job Description
Add your answer

Q1. Long term vs short-term securities
Ans. 
Long-term securities are investments held for an extended period, while short-term securities are held for a shorter duration.
• Long-term securities typically have maturity dates of over one year, such as bonds or stocks.

• Short-term securities have maturity dates of one year or less, like Treasury bills or certificates of deposit.

• Long-term securities offer higher potential returns but also higher risk, while short-term se...read more
Answered by AI
Add your answer
Q2. Data analysis, vizualization
Add your answer
Q3. Yield to Maturity, the relationship between yield and interest
Ans. 
Yield to Maturity is the total return anticipated on a bond if it is held until it matures.
• Yield to Maturity is the annual rate of return an investor can expect to earn if the bond is held until it matures.

• It takes into account the bond's current market price, par value, coupon interest rate, and time to maturity.

• Yield to Maturity helps investors compare different bonds and make informed investment decisions.

• For exampl...read more
Answered by AI
Add your answer
Q4. About my project
Add your answer
Q5. Job Description
Add your answer

Q1. Basic question like to make the atmosphere cool about your self & others
Add your answer
Q2. Explanation from your resume & others relating to domain
Add your answer

Q1. What exactly you do when requirements gets clashed between stake holder & business analyst
Ans. 
When requirements clash between stakeholder & business analyst, I facilitate open communication, prioritize needs, seek compromise, and involve higher management if necessary.
• Facilitate open communication between stakeholder and business analyst to understand concerns

• Prioritize needs based on impact and importance to the project

• Seek compromise by finding common ground and exploring alternative solutions

• Involve higher m...read more
Answered by AI
Add your answer
Q2. Expain user stories & use case for the banking app where the user wants to login into the app with password
Ans. 
User stories and use case for logging into a banking app with a password
• User story: As a user, I want to securely login to my banking app using my password

• Use case: User enters username and password, app verifies credentials and grants access

• Example: User enters username 'john.doe' and password 'password123', app authenticates and logs in
Answered by AI
Add your answer

Q1. Tableau interview questioins
Add your answer
Q2. SQl based quetions
Add your answer

Q1. Sql regarding question was there
Add your answer

Q1. Java code on streams

Ans. 

Java streams provide a way to process collections of objects in a functional style.

• Streams allow for concise and readable code when working with collections.

• Common stream operations include map, filter, and reduce.

• Example: List names = Arrays.asList("Alice", "Bob", "Charlie"); names.stream().filter(name -> name.startsWith("A")).forEach(System.out::println);

Add your answer