
FDM Group's Business Analyst interview, based on three detailed candidate reports, pairs a phone or video screening call with a technical round covering SQL, Excel, and sometimes VBA, plus STAR-style behavioral questions; one candidate also completed an Arctic Shores puzzle assessment. One report counted three rounds total, and another said the full process took about three weeks.
$75K
Avg. Base Comp
$90K
Avg. Total Comp
3 rounds
Typical Rounds
1-3 weeks
Process Length
FDM Group recruits Business Analysts into its consulting training program, and this guide draws on three detailed candidate accounts. The overall shape is an opening screen or assessment, followed by technical and behavioral questioning, though the exact sequence differs by candidate.
One candidate's process began with a preliminary phone call about background and motivation, followed by a separate video interview focused on a self-introduction and why they wanted to join FDM. Another candidate's opening stage was a similar phone screening centered on relevant experience, described as more of a conversation than an interrogation. A third candidate, interviewing for FDM's Change & Transformation track, instead started with an Arctic Shores online assessment featuring puzzle-style tasks such as Balance, Sequence, and Order under time pressure, a format that candidate specifically recommended researching in advance.
Technical questions stayed mostly foundational rather than veering into advanced algorithms. Candidates were asked about SQL basics like primary keys, Excel functions such as VLOOKUP, INDEX-MATCH, and PivotTables, and in one case VBA terminology the candidate had to define and self-assess honestly. The Change & Transformation candidate additionally fielded PowerBI and Tableau questions along with a duplicate-character coding problem that felt more algorithm-focused than expected.
Behavioral questions ran through two of the three reports, built around STAR-style storytelling: handling a difficult teammate, showing initiative, adapting to change, and recovering from mistakes. Interviewers reportedly pressed for detail rather than accepting short answers.
The process closed differently for each candidate. One report described a final stage with two separate Zoom interviews revisiting technical topics and motivation, and that candidate explicitly counted three rounds total. Another candidate said the entire process, start to finish, took about three weeks. Each account reflects one candidate's path, and the three don't fully agree on structure, so expect some variation from report to report.
Synthesized from 12 candidate reports by our editorial team.
Had an interview recently?
Share your experience. Unlock the full guide.
Real interview reports from people who went through the Fdm Group process.
Share your own interview experience to unlock all reports, or subscribe for full access.
Sourced from candidate reports and verified by our team.
Topics based on recent interview experiences.
Featured question at Fdm Group
Swap the values of `a` and `b` in the dictionary without declaring any other variable
| Question | |
|---|---|
| Why Do You Want to Work With Us | |
| Your Strengths and Weaknesses | |
| Design Poker Schema | |
| 2nd Highest Salary | |
| Rolling Bank Transactions | |
| Top Three Salaries | |
| Retailer Data Warehouse | |
| Bagging vs Boosting | |
| Top 5 Turnover Risk | |
| Google Maps Improvement | |
| Largest Salary by Department | |
| Resumable Fact Table Load | |
| Count Transactions | |
| Hurdles In Data Projects | |
| Target Indices | |
| Assumptions of Linear Regression | |
| Digitizing Student Test Scores | |
| Identify Managers | |
| Flight Routes | |
| Classification and Regression | |
| Slow SQL Query | |
| Data Pipelines and Aggregation | |
| User Event Data Pipeline | |
| Demand Metrics | |
| Addressing Data Quality Issues | |
| Smart Home Security Launch | |
| Different Parcel Effectiveness | |
| String Palindromes | |
| Popular Products |
Synthesized from candidate reports. Individual experiences may vary.
Two candidates' processes opened with a low-pressure screening call. One described a preliminary phone call covering background and why they wanted to join FDM, followed by a separate video interview that focused on a self-introduction and motivation for choosing the company. Another candidate's opening stage was a casual phone screening where a recruiter asked about relevant experience, describing it as more of a conversation than an interrogation. Both candidates said the tone was supportive and used mainly to confirm fit before moving into technical and behavioral rounds.
One candidate interviewing for FDM's Change & Transformation track completed an Arctic Shores assessment before any live interview. It included multiple task types, among them Balance, Order, Sequence, Energy, Direction, Team, Ticket, Preparation, Expression, and Password, each with its own rules and time limits. The Balance task, for example, asked the candidate to figure out how many objects were needed to balance a scale with given shapes, testing spatial reasoning and pattern recognition under pressure. This candidate recommended watching tutorial walkthroughs of these puzzle types beforehand, since the format differs from typical aptitude tests.
Across the three reports, technical questions stayed foundational rather than algorithm-heavy. One candidate fielded questions on SQL primary keys and practical scenarios for Excel functions like VLOOKUP, INDEX-MATCH, and PivotTables, alongside a short aptitude test of basic coding and logical reasoning. Another candidate was asked to define technical terminology and assess their own VBA proficiency, noting this required honest self-assessment rather than overstatement. A third candidate's technical round covered SQL, Excel, PowerBI, and Tableau, plus a coding question about finding duplicate characters in a string, with a warning that admitting a total knowledge gap on a listed tool could end the conversation.
Two of the three reports described detailed behavioral questioning built around the STAR method. One candidate was asked about handling a difficult colleague, taking initiative, responding to an unfamiliar task from a manager, and recovering from mistakes. Another candidate, interviewing for the Change & Transformation track, answered questions about the biggest change they'd adapted to, an original idea they'd generated, and a long-term goal they'd achieved, noting that interviewers wanted one-to-three-minute STAR answers and pushed for follow-up detail rather than accepting a quick summary.
One candidate's process closed with a final stage conducted on Zoom that included two separate interviews, both revisiting technical ground covered earlier and adding questions about motivation for joining FDM. This candidate explicitly counted three rounds total across the entire process, phone screening, technical interview, and this two-part final stage, and noted the team was transparent about timelines throughout, though ultimately no offer was extended in that case.