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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- SUMIFS, COUNTIFS and SUMPRODUCT. SUMIFS adds a column under several conditions given as pairs of range and criterion, with the sum range first.
- 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.
- Modelling habits: circularity, scenarios and checks. Interest on average debt creates a circular reference, handled with iterative calculation and a circuit breaker.
- 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.
- 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.
- NULL: three-valued logic. Any comparison with NULL is unknown, so WHERE status = NULL returns nothing and IS NULL is the only test.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- Interchange caps, acquirer margins and take rates. EU rules cap consumer interchange at 0.2% for debit and 0.3% for credit cards.
- 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.
- PSD2, e-money and instant payments. PSD2 requires strong customer authentication with at least 2 independent factors from knowledge, possession and inherence.
- Fintech models: BNPL, neobanks, embedded finance and float. A buy-now-pay-later provider earns mostly merchant fees, minus credit losses and funding.
- 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.
- 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.
- 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₂)).
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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.
- 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 .