Operations and fintech interview questions: the 46 topics they test

Technical questions in an operations and fintech interview come back to these 46 topics, from 7 guides of the Academy. Each one is the rule to know in one sentence, linked to its guide: the why, a worked example and a timed quiz are there.

Trade lifecycle and operations

Follow a trade from execution to settlement like an operations analyst: T+1, delivery versus payment, CCPs and margin, fails and penalties, static data and reconciliations, corporate actions.

  1. The lifecycle and the move to T+1. A trade is executed, confirmed, cleared, often through a CCP, then settled, and positions and P&L move on the trade date.
  2. Delivery versus payment, CLS, repos and netting. Under delivery versus payment, securities move only if the cash moves, which removes principal risk; netting collapses many trades into one payment.
  3. CCPs, margin and collateral. A central counterparty steps between buyer and seller through novation and collects initial margin, daily variation margin and a default fund.
  4. Trade fails: penalties, buy-ins, partial settlement and recalls. In the EU, the participant causing a settlement fail pays daily CSDR cash penalties until it settles.
  5. Static data, controls and reconciliations. Stale standing settlement instructions are a leading cause of fails, so one golden source keeps every system on the same static data.
  6. Accrued interest, corporate actions and P&L explain. A bond buyer pays the clean price plus accrued interest, and the record date fixes who receives a dividend.
  7. How one fail becomes many. In a chain of trades in one security, one shortfall makes every later delivery fail; netting through a CCP leaves only the original fail.

Excel for finance

Build and check models like an analyst: anchored references, robust lookups, SUMIFS, NPV and IRR without the classic off-by-one, and the modelling habits that survive a review at 2 a.m.

  1. References, rounding, dates and text numbers. A $ freezes the column or row that follows it when a formula is copied, and F4 cycles A1, $A$1, A$1, $A1 in Excel for Windows.
  2. Lookups that do not break. A VLOOKUP in a model needs FALSE or 0 as its last argument, or it returns approximate matches that are wrong on unsorted data.
  3. SUMIFS, COUNTIFS and SUMPRODUCT. SUMIFS adds a column under several conditions given as pairs of range and criterion, with the sum range first.
  4. NPV, IRR, CAGR and loan payments. Excel's NPV() treats its first value as arriving at the end of period 1, so a cash flow today is added outside it.
  5. Modelling habits: circularity, scenarios and checks. Interest on average debt creates a circular reference, handled with iterative calculation and a circuit breaker.
  6. Breaking the circular reference with algebra. When all cash after interest repays debt, interest on average debt is rate × (2 × opening debt − cash before interest) ÷ (2 − rate).

SQL and data analysis

Write queries that return the right rows: count joins before running them, handle NULL without losing data, filter groups with HAVING, rank with window functions and keep queries fast and safe.

  1. Joins and how many rows they return. An INNER JOIN returns one row per matching pair, and a LEFT JOIN adds one row with NULL columns for each unmatched left row.
  2. NULL: three-valued logic. Any comparison with NULL is unknown, so WHERE status = NULL returns nothing and IS NULL is the only test.
  3. GROUP BY, HAVING and the order of evaluation. A query runs logically FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY, so WHERE filters rows before grouping and HAVING filters groups.
  4. Window functions: running totals, ranks and changes. A window function adds a value to each row without collapsing them: SUM(pnl) OVER (ORDER BY day) is a running total.
  5. Indexes, transactions and silent traps. An index speeds reads but slows writes, and a composite index on (desk, trade_date) serves desk or desk and date but not date alone.
  6. When the planner ignores your index. An index pays only for selective filters: each matching row costs about one random page read, while a full scan reads every page in sequence.

Fund administration

Strike and protect a fund's NAV like an administrator: accruals and income, pricing and errors, forward pricing and swing pricing, gates, transfer agents and depositaries, fees and share classes.

  1. Striking the NAV: accruals, income, prices and errors. NAV per share is (assets − liabilities) ÷ shares, and positions are reconciled with the custodian before the NAV is struck.
  2. Dealing: forward pricing, cut-offs, swing pricing and gates. Under forward pricing an order deals at the next NAV after the cut-off, so a late order waits and late trading is illegal.
  3. Transfer agents, depositaries and securities lending. A transfer agent keeps the investor register, processes subscriptions and redemptions and runs eligibility and anti-money laundering checks before issuing units.
  4. Fees: high-water marks, equalisation, ongoing charges and caps. A performance fee is due only on gains above the high-water mark, and equalisation makes each investor pay fees on their own gains.
  5. Share classes, cash drag and look-through. A currency-hedged share class removes currency risk for its holders with forwards whose costs and gains stay in that class.
  6. Swing pricing: who pays for the trading. When a fund trades to meet large flows, the costs fall on every holder unless the price moves.

Payments and fintech

Understand how payments make money and where they break: the card chain, interchange caps and take rates, chargebacks and approval rates, PSD2 and instant payments, and fintech unit economics.

  1. The card chain: issuers, acquirers, networks and fraud. The issuer is the cardholder's bank and the acquirer the merchant's, linked by a network such as Visa or Mastercard.
  2. Interchange caps, acquirer margins and take rates. EU rules cap consumer interchange at 0.2% for debit and 0.3% for credit cards.
  3. Merchants: chargebacks, approval rates, facilitators and KYB. In a chargeback the merchant bears the loss unless it proves the sale, and high chargeback ratios bring network fines.
  4. PSD2, e-money and instant payments. PSD2 requires strong customer authentication with at least 2 independent factors from knowledge, possession and inherence.
  5. Fintech models: BNPL, neobanks, embedded finance and float. A buy-now-pay-later provider earns mostly merchant fees, minus credit losses and funding.
  6. Fraud caught against good customers declined. A fraud model should decline a payment when the expected fraud loss exceeds the margin expected if the payment is good.

Product analytics and A/B tests

Run experiments a sceptical reviewer would accept: size them, read p-values and intervals honestly, spot broken tests, multiply funnels, and keep seasonality and luck out of conclusions.

  1. Sample size, power and variance reduction. At 5% significance and 80% power, each variant needs about 16 × p(1 − p) ÷ δ² users, δ being the absolute lift.
  2. z-statistics, intervals, peeking and many metrics. The z-statistic of 2 conversion rates is their difference ÷ the pooled standard error √(p(1 − p) × (1/n₁ + 1/n₂)).
  3. Designing tests that can be trusted. Before reading a test, check that the split matches the plan, since a sample ratio mismatch means users are lost.
  4. Funnels, revenue per visitor and proxy metrics. Funnel conversion is the product of its step rates, so a step's relative gain lifts the total by the same share.
  5. Product metrics: stickiness, retention, lifetime value, outliers. Stickiness is daily ÷ monthly active users, retention is measured on the starting cohort, and lifetime value is about monthly margin ÷ monthly churn.
  6. Correlation, seasonality, survivors and regression to the mean. A feature used by retained users may only mark engaged users, so an experiment is needed to show it causes retention.
  7. CUPED: shorter tests from pre-test data. CUPED subtracts from each user's metric the part predicted by their own pre-test behaviour, removing a share ρ² of the variance.

Crypto and digital assets

Trade crypto like a markets desk: perpetual funding and the basis, how blockchains and stablecoins hold up, DeFi pools and their risks, custody, and the EU's MiCA rules.

  1. Perpetual futures, funding and leverage. A perpetual future has no expiry and is kept close to spot by funding paid between longs and shorts, usually every 8 hours.
  2. Basis trades and cross-venue arbitrage. When a dated bitcoin future trades above spot, buying spot and selling the future earns the basis, annualised by the time to expiry.
  3. How blockchains work: consensus, supply and fees. Proof of work secures a blockchain with computing power and proof of stake with locked tokens, and on-chain transactions are pseudonymous, not anonymous.
  4. Stablecoins and their peg. A fiat-backed stablecoin holds its peg because holders trust they can redeem it at par, so arbitrageurs buy it below par and redeem it.
  5. DeFi: pools, lending, oracles and staking. An automated market maker (AMM) keeps the product of its 2 reserves constant, x × y = k, so each trade moves its price.
  6. Custody, exchanges and proof of reserves. Whoever controls the keys controls the assets, so institutions use qualified custodians that keep most coins offline in cold wallets.
  7. Token supply and EU regulation. A token's fully diluted valuation counts every token that will ever exist at today's price, while its market capitalisation counts those in circulation.
  8. Collecting funding: a hedged trade that is not riskless. Holding spot and shorting the perpetual collects the funding without price risk, so its yield is the funding rate annualised, 3 payments a day.

Say them out loud

The technical round of the video interview practice asks 5 questions on your desk, 90 seconds each, and reviews every answer. Each guide ends with a timed quiz.

Every topic comes from the Academy guides of this desk. Updated .