Interview Preparation


This interview preparation page is merely a basic guide for what might be discussed at your interview as per the role to which you are applying. Additional related points may be covered and some of the below may not be at all. Hence ensure additional study on the below as well as associated topics.


You should be able to answer questions on all topics in the Required Knowledge section. A successful applicant should look to the Bonus Knowledge section for further reading. Additionally, industry awareness is highly advised. If you are unsure about anything please send an email to londoncareers@arborfs.com or call 0203 070 9650 and we will be more than happy to help you. Good luck!
Interview Preparation

Required Knowledge

Arbor
  • Basic system features.
  • The kind of clients we offer our services to.
Suggested resources:
Arbor System Features

 

Technology Awareness
You will be asked to demonstrate a basic understanding of the following common technologies used in our industry:

Practiced SQL Ability

You will be asked to demonstrate a basic understanding of what SQL is and a few key statements and clauses.

  • Key statements: SELECT, INSERT, UPDATE, DELETE.
  • Key clauses: ORDER BY, WHERE.
  • Creating and removing tables.
  • Primary & foreign keys.
Suggested resources:
W3Schools
Database Glossary
 
Current Affairs

You will be asked to speak to us for a few minutes about a current affair topic of your own choice, preferably but not restricted to the Finance sector. This role also requires the ability to make tea.

Bonus Knowledge

Intermediate Technology Awareness
  • Encryption
  • Secure FTP
  • Windows Administration: cmd, telnet, ping, UAC, setting up user account, network setup (LAN/WAN), RDP
  • Setting up Windows 7/8/Server
  • Using Linux/Unix
Intermediate SQL Ability
  • Joins, Unions, Subquery
  • Installing Microsoft SQL Server Express 2014 (free)
  • Backing up and restoring databases
  • Setting up SQL user logins and permissions
Industry Awareness
  • Functions and objectives of a hedge fund.
  • Definitions and uses of:
    • equities
    • futures
    • options
    • contracts for difference
    • FX spots
    • FX forwards
    • bonds
Suggested resources:

Financial Products

Required Knowledge

Arbor
  • Basic system features.
  • Our clientèle.
Industry Awareness
  • Functions and objectives of a hedge fund.
  • Definitions and uses of:
    • equities
    • futures
    • options
    • contracts for difference
    • FX spots
    • FX forwards
    • bonds

Practiced SQL Ability

  • Key statements: Select, Insert Into, Update, Delete, Where, Order By.
  • Creating and removing tables.
  • Primary & foreign keys.
Suggested resources:
W3Schools
Database Glossary