ARCTERN CONSULTING Compliance Executive Interview Questions and Answers

Q1. Question related to oops
Add your answer
Q2. Question related to coding
Add your answer
Q3. I was rejected after 2nd round
Add your answer

Q1. Question related to advanced topic in oops
Add your answer
Q2. Question related to coding
Add your answer

Q1. What is zero coupon bond?
Ans. 
A zero coupon bond is a bond that pays no interest and is sold at a discount to its face value.
• Zero coupon bonds are also known as discount bonds.

• Investors buy these bonds at a price lower than their face value and receive the full face value at maturity.

• The difference between the purchase price and the face value is the investor's return.

• Zero coupon bonds are often used for long-term investments, such as retirement sa...read more
Answered by AI
Add your answer
Q2. What is corporate actions and how you record those in books?
Ans. 
Corporate actions are events initiated by a company that can affect its stock price and shareholders. They are recorded in books through various accounting entries.
• Corporate actions include stock splits, dividends, mergers, acquisitions, and spin-offs.

• These actions are recorded in books through journal entries and adjustments to accounts such as retained earnings and stockholders' equity.

• For example, if a company decla...read more
Answered by AI
Add your answer

Q1. Sql is the most important , Focus on Joins ,Sub query and Sql basics
Add your answer
Q2. Joining tables with different joins
Ans. 
Joining tables with different joins in SQL
• Use INNER JOIN to return rows when there is at least one match in both tables

• Use LEFT JOIN to return all rows from the left table and the matched rows from the right table

• Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table

• Use FULL JOIN to return rows when there is a match in one of the tables
Answered by AI
Add your answer

Test of SQL, Tableau and other skills based on your resume on Skillate

Q1. SQL and other skills technical questions
Add your answer

Q1. Manager round / 2nd technical round
Add your answer

Q1. Asked about my experiences (like roles & responsibilities)
Add your answer
Q2. Do I have experience in domestic hiring/staffing or not?
Ans. 
Yes, I have experience in domestic hiring/staffing.
• I have successfully recruited and placed candidates for various IT positions within the United States.

• I am familiar with the local job market trends and requirements.

• I have worked with US-based clients to understand their hiring needs and provide suitable candidates.

• I have experience in conducting interviews, negotiating offers, and onboarding candidates locally.
Answered by AI
Add your answer

Q1. Its more about the previous roles & project
Add your answer