01
What is statistical significance vs practical significance?
Show answer
A result can be statistically significant yet too small to matter; always report effect size and business impact together with the p-value.
Fidelity Investments Data Analytics Interview Questions & Answers
Curated interview practice questions with answers. These are practice scenarios, not a verified list of past interview questions.
About Fidelity Investments hiring for Data Analytics roles
Fidelity Investments is a large American financial services company providing brokerage, retirement plans, mutual funds and wealth management. In India it operates technology and operations centres that build and support its trading, investment and customer platforms. These centres hire software engineers, quality engineers, data engineers, analysts and operations professionals.
For Data Analytics roles, this Fidelity Investments practice set focuses most on Statistics and Case Studies (8), Power BI (6), Data Modelling & Warehousing (5), Data Cleaning (5). It has 2 easy, 31 medium, 7 hard questions, so you can start easy and work up to the harder ones.
- Company type
- Banking & finance
- Headquarters
- Boston, USA
- Main India offices
- Bengaluru, Chennai, Gurugram
Fidelity Investments Data Analytics interview process
- Online coding assessment
- Technical round 1 (DSA + language)
- Technical round 2 (design or domain)
- Managerial and HR round
Typical pattern based on public candidate experiences. Rounds vary by role, team and year.
Solved for Fidelity InvestmentsStart practicing
3 QUESTIONS FREESign up to unlock the full question bank and track your progress.Unlock every question and answer, then continue practising company-wise and package-wise.
3 questions free Unlock the rest in seconds
02
A stakeholder says the Power BI report shows different revenue than their Excel file. How do you troubleshoot?
Show answer
I would first agree on definitions: gross or net, including tax or returns, order date or invoice date. Then compare one small slice, such as one month and one region, in both. I check filters on the report and page, relationships that drop unmatched rows, refresh time versus the Excel extract time, and duplicate rows. Once the gap is explained, I document the definition in the report so the question does not repeat.
03
Write SQL to generate a simple date dimension for 2026.
Show answer
-- PostgreSQL syntax
CREATE TABLE dim_date AS
SELECT
TO_CHAR(d, 'YYYYMMDD')::INT AS date_key,
d::DATE AS full_date,
EXTRACT(YEAR FROM d) AS year,
EXTRACT(QUARTER FROM d) AS quarter,
EXTRACT(MONTH FROM d) AS month_no,
TO_CHAR(d, 'Mon') AS month_name,
TO_CHAR(d, 'Dy') AS weekday,
EXTRACT(ISODOW FROM d) IN (6, 7) AS is_weekend
FROM GENERATE_SERIES(DATE '2026-01-01', DATE '2026-12-31', INTERVAL '1 day') AS d;
04
A stakeholder asks for a pie chart of 12 product categories. When is a pie chart acceptable, and what would you suggest?
Show answer
A pie chart works only for showing parts of a whole with very few categories, two to four, where one share clearly dominates, such as 70 percent of orders are prepaid. Avoid it when there are many slices, when values are close, or when comparing across periods, because people judge angles poorly. A sorted bar chart is almost always easier to read and compare. Never use 3D pies.
05
What types of dashboard actions does Tableau offer?
Show answer
Filter actions filter other sheets when a user selects or hovers on a mark, such as clicking a region to filter a product table. Highlight actions emphasise related marks without removing others. URL actions open a web page with field values in the link. Go to Sheet navigates to another dashboard. Parameter and set actions update a parameter or set based on selection, enabling advanced interactions like dynamic drill-downs and comparisons.
06
Email open rates suddenly jumped from 22% to 45% without any campaign change. Should you celebrate?
Show answer
No. Privacy features in some mail apps pre-load email images, which fires the open tracking pixel even if the person never reads the email, so open rates get inflated. Check opens by email client to confirm. Move reporting towards clicks, click-to-send rate, conversions and unsubscribes, which reflect real behaviour, and avoid using opens alone to pick winning subject lines or to define engaged subscribers.
07
Where should data cleaning happen: Excel, SQL, Python or Power Query?
Show answer
Clean as close to the source as is practical and in a repeatable tool. Fixes everyone needs belong upstream in the database or warehouse via SQL so all reports share them. Power Query suits report-specific shaping and Excel users. Python is best for complex logic like fuzzy matching or regex at scale. Manual Excel edits are fine for one-off exploration but should not be part of recurring reports because they cannot be reproduced.
08
Tell me about a time you worked with a marketing team to improve a campaign using data.
Show answer
Situation: a lead generation campaign had a high cost per lead and sales said leads were poor. Task: find what to change. Action: I joined ad data with CRM outcomes and found two audience segments produced most leads but almost no closed deals, while one smaller segment converted well. Result: we moved budget to that segment and changed the form questions; cost per qualified lead fell about 30% in six weeks.
09
What is a junk dimension?
Show answer
A junk dimension combines several low-cardinality flags and indicators, such as payment type, is_gift, is_express and order channel, into one small dimension table. Each row is a unique combination of those values, and the fact table stores a single key to it. This keeps the fact table narrow and avoids many tiny dimensions or loose flag columns. It works best when the combinations are limited, typically a few hundred rows.
10
How do you handle a dataset with 30% missing values in a key column?
Show answer
Understand why it is missing, consider imputation or a missing flag, test sensitivity, and talk to data owners about fixing collection if it is systematic.
11
Tell me about a time your analysis was challenged in a meeting.
Show answer
Situation: while presenting regional sales, a manager said my numbers were wrong because his team's tracker showed more. Task: handle it without derailing the meeting. Action: I acknowledged the concern, explained my source and definition briefly, and offered to reconcile after the meeting. That afternoon we found his tracker counted orders before cancellations. Result: we agreed on net orders as the standard, and he later asked me to rebuild his tracker.
12
What is the grain of a fact table and why should you decide it first?
Show answer
The grain is the exact meaning of one row in a fact table, such as one order line, one daily store total or one monthly account balance. You decide it first because it controls which dimensions can join, which measures are valid and how totals behave. Mixing grains in one table, for example order lines and order-level shipping charges, causes double counting. Always state the grain in one sentence before adding columns.
13
Write Python code to extract UTM source, medium and campaign from a column of landing page URLs.
Show answer
import pandas as pd
from urllib.parse import urlparse, parse_qs
def get_utms(url):
params = parse_qs(urlparse(str(url)).query)
return pd.Series({
'source': params.get('utm_source', ['(direct)'])[0].lower(),
'medium': params.get('utm_medium', ['(none)'])[0].lower(),
'campaign': params.get('utm_campaign', ['(not set)'])[0].lower(),
})
df[['source', 'medium', 'campaign']] = df['landing_url'].apply(get_utms)
14
Estimate how many cups of tea are sold in a city of 1 crore people in a day.
Show answer
State assumptions clearly. Of 1 crore people, assume 70 percent drink tea, so 70 lakh. Say half of their cups are bought outside, at an average of one bought cup per drinker every day for that half, giving about 35 lakh purchased cups, with more at offices and stations. So roughly 30 to 40 lakh cups. Interviewers judge the structure, segmentation and sanity check more than the exact number.
15
What is a date table in Power BI and why should you mark it as one?
Show answer
A date table has one row per day with no gaps, covering the full range of your data, plus columns like year, month, quarter and week. Marking it as a date table tells Power BI to use it for time intelligence functions such as TOTALYTD and SAMEPERIODLASTYEAR. Without it, those functions can give wrong results and auto date tables bloat the model. Relate it to every fact table's date column.
16
When do you use a chi-square test?
Show answer
A chi-square test of independence checks whether two categorical variables are related, using a contingency table of counts. Example: is preferred payment method related to city tier? It compares observed counts with the counts expected if there were no relationship. Use it with counts, not percentages, and make sure expected counts are not too small, roughly at least 5 per cell. A significant result shows association, not causation.
17
Explain INDEX and MATCH together.
Show answer
MATCH finds the position of a value in a range and INDEX returns the item at that position, giving a flexible lookup that works left or right and survives column insertions.
18
What are Type I and Type II errors?
Show answer
A Type I error is a false positive: concluding there is an effect when there is none, for example launching a feature that does not actually lift sales. Its probability is alpha, often 0.05. A Type II error is a false negative: missing a real effect, with probability beta. Power is 1 minus beta. Larger samples reduce Type II errors, and the business cost of each mistake should guide which one you guard against more.
19
What is an action title and why should you use one?
Show answer
An action title states the insight of a chart or slide as a sentence instead of a label. Instead of Monthly Sales by Region, write South region drove 70 percent of the decline since July. Busy executives may read only the titles, so each one should carry the message and, ideally, the so-what. The chart below then proves the title. Read only your titles in order: they should tell the whole story.
20
How do you decide the sample size for a survey?
Show answer
It depends on margin of error, confidence level and expected variability; larger samples give smaller errors with diminishing returns.
21
How do you let users choose Top N customers with a parameter in Tableau?
Show answer
Create an integer parameter Top N with a range of 5 to 50 and show its control. Drag Customer to the Filters shelf, choose the Top tab, select By field, and set it to top Top N by SUM(Sales). Alternatively create a set based on the parameter so you can show Top N versus Others in one chart. If the Top N must respect a category filter, add that category filter to context.
22
Users say a Power BI report still shows yesterday morning's data, although a refresh is scheduled every few hours. What do you check?
Show answer
Open the semantic model's refresh history in the Service to see whether refreshes failed, for example due to expired credentials, an offline gateway or a timeout. Check whether the report is connected to a different copy of the model, whether the source itself was updated, and whether incremental refresh only covers some partitions. Also confirm the schedule time zone. Finally, add a 'data as of' timestamp on the report.
23
Write SQL to get each order's customer city as it was on the order date, using an SCD Type 2 customer dimension.
Show answer
-- dim_customer has valid_from, valid_to (NULL for current row)
SELECT o.order_id,
o.order_date,
c.customer_id,
c.city
FROM fact_orders o
JOIN dim_customer c
ON c.customer_id = o.customer_id
AND o.order_date >= c.valid_from
AND o.order_date < COALESCE(c.valid_to, DATE '9999-12-31');
24
Write Python code to bootstrap a 95% confidence interval for the difference in revenue per user between two groups.
Show answer
import numpy as np
rng = np.random.default_rng(42)
control = df.loc[df.variant == 'A', 'revenue'].to_numpy()
treat = df.loc[df.variant == 'B', 'revenue'].to_numpy()
diffs = []
for _ in range(5000):
c = rng.choice(control, size=len(control), replace=True)
t = rng.choice(treat, size=len(treat), replace=True)
diffs.append(t.mean() - c.mean())
low, high = np.percentile(diffs, [2.5, 97.5])
print(f'95% CI for difference: {low:.2f} to {high:.2f}')
25
What are variables (VAR) in DAX and why are they useful?
Show answer
VAR stores the result of an expression inside a measure, and RETURN gives the final output. Variables make measures readable, avoid evaluating the same expression twice, and are evaluated in the filter context where they are defined, which helps avoid subtle bugs inside CALCULATE. They also make debugging easy, because you can temporarily RETURN a variable to check its value before returning the final result.
26
What does CASE WHEN do?
Show answer
It adds conditional logic inside queries, for example bucketing ages or flagging values, returning different results per condition.
27
Your pandas script shows SettingWithCopyWarning and a new column does not update. What is happening and how do you fix it?
Show answer
It warns that you may be modifying a temporary copy of a slice, so the change might not reach the original DataFrame, for example df[df.sales > 0]['flag'] = 1. Avoid it by using a single loc call, df.loc[df.sales > 0, 'flag'] = 1, or by calling .copy() when you intentionally create a new subset. Newer pandas versions with copy-on-write make behaviour more predictable, but clear loc assignments remain best practice.
28
An A/B test shows a 2% lift with p = 0.04, but it only ran for 3 days. Would you ship it?
Show answer
Not yet. Three days misses weekly patterns, and early results are often inflated by novelty effects or by stopping once the p-value looked good. I would check whether the planned sample size was reached, whether the split was balanced, and how guardrail metrics behaved. I would recommend running to the pre-planned duration, at least one or two full weeks, and then deciding, considering the cost of being wrong.
29
Orders arrive in the warehouse with customer IDs that do not exist yet in the customer dimension. What do you do?
Show answer
These are late-arriving dimensions. Do not drop the orders, or revenue will be understated. Common practice is to insert a placeholder customer row with the natural key and 'Unknown' attributes, link the order to it, and update that row when full details arrive. Alternatively map to a single Unknown member with key -1. Also monitor how many such rows appear daily, because a spike usually means a broken feed.
30
Average delivery time improved by 4 minutes, but customer complaints about late deliveries went up. How do you investigate?
Show answer
An average can improve while the tail gets worse. I would look at the distribution: median, 90th and 95th percentiles and the share of orders beyond the promised time. Then break it down by city, time slot and restaurant to see where late orders cluster. Also check whether promised times changed, whether complaint tracking changed and whether a few very fast orders pulled the mean down.
31
Explain time intelligence functions.
Show answer
DAX functions like TOTALYTD, SAMEPERIODLASTYEAR and DATEADD compare periods; they need a proper continuous date table marked as a date table.
32
Write pandas code to fill missing values in a column with the median of each group.
Show answer
# Fill missing delivery_days with the median for that city
df['delivery_days'] = (
df['delivery_days']
.fillna(df.groupby('city')['delivery_days'].transform('median'))
)
# Rows in a city with no values at all stay NaN; fall back to overall median
df['delivery_days'] = df['delivery_days'].fillna(df['delivery_days'].median())
33
Many reporting queries in your team use SELECT DISTINCT to remove duplicate rows. What is the risk?
Show answer
SELECT DISTINCT often hides a real problem, such as a join on the wrong key or a one-to-many join that multiplies rows. The output looks clean, but sums computed before the DISTINCT, or legitimate repeated rows, can be wrong, and DISTINCT adds a costly sort on large tables. Instead, find why duplicates appear, fix the join or aggregate the child table first, and add a uniqueness test on the key.
34
Write SQL to calculate daily active users and the DAU/MAU stickiness ratio.
Show answer
WITH dau AS (
SELECT CAST(event_ts AS DATE) AS day,
COUNT(DISTINCT user_id) AS dau
FROM events
GROUP BY CAST(event_ts AS DATE)
)
SELECT d.day,
d.dau,
(SELECT COUNT(DISTINCT e.user_id)
FROM events e
WHERE CAST(e.event_ts AS DATE) BETWEEN d.day - INTERVAL '29 days' AND d.day) AS mau,
ROUND(100.0 * d.dau / (SELECT COUNT(DISTINCT e.user_id)
FROM events e
WHERE CAST(e.event_ts AS DATE) BETWEEN d.day - INTERVAL '29 days' AND d.day), 1) AS stickiness_pct
FROM dau d
ORDER BY d.day;
35
How do you merge two DataFrames on different column names?
Show answer
pd.merge(df1, df2, left_on='cust_id', right_on='id', how='left') joins on differently named keys.
36
Sales dropped 20% last month. How will you analyse it?
Show answer
Confirm data accuracy first → break down by region, product, channel and customer segment → compare with seasonality and last year → check pricing, stock-outs, marketing changes and funnel conversion → present the root causes with clear charts.
37
What does the CALCULATE function do?
Show answer
It evaluates an expression after modifying the filter context, for example CALCULATE(SUM(Sales[Amount]), Region[Name] = "North").
38
You loaded a month of sales into the warehouse. How do you check the load is complete and correct?
Show answer
Reconcile against the source: compare row counts, total amount, and counts by day and by store between source and target. Check for duplicate keys, nulls in mandatory columns, and dates outside the expected month. Compare with the previous month to spot big unexplained jumps. Spot-check a few individual transactions end to end. Automate these checks so each future load produces a small pass or fail report.
39
Write SQL to flag rows that fail basic validation rules in a customer table.
Show answer
SELECT customer_id,
CASE WHEN email IS NULL OR email NOT LIKE '%_@_%._%' THEN 1 ELSE 0 END AS bad_email,
CASE WHEN LENGTH(pincode) <> 6 THEN 1 ELSE 0 END AS bad_pincode,
CASE WHEN signup_date > CURRENT_DATE THEN 1 ELSE 0 END AS future_signup,
CASE WHEN age NOT BETWEEN 18 AND 100 THEN 1 ELSE 0 END AS bad_age
FROM customers;
-- sum each flag to report the error rate per rule
40
Analytics shows 1,820 purchases last month but the order database shows 2,150. Which is right, and how do you explain the gap?
Show answer
The order database is the source of truth for counts and revenue. Analytics usually undercounts because of ad blockers, declined cookie consent, users closing the page before the confirmation tag fires, and payment redirects that break sessions. It can also overcount from duplicate tags on page refresh. Quantify the gap per month; if it is stable around 15%, use analytics for channel mix and trends and the database for totals.
Tips to crack the Fidelity Investments Data Analytics interview
- Revise Java or Python, SQL and core CS subjects, and practise medium-level DSA problems for technical rounds.
- Learn basic investment concepts like stocks, mutual funds and retirement accounts to understand the business domain.
- Prepare behavioural answers on teamwork and learning, using clear STAR-format stories from projects or internships.
- Keep a one-minute story ready for every project on your CV: problem, your part, tools, result.
- Practise the hard questions on this page aloud; Fidelity Investments interviewers usually ask follow-ups on your first answer.
Frequently asked questions
How many rounds are there in the Fidelity Investments Data Analytics interview?
Candidates usually go through 4 stages: Online coding assessment; Technical round 1 (DSA + language); Technical round 2 (design or domain); Managerial and HR round. The exact rounds change with the role, team, location and your experience, so confirm the process with the recruiter.
Which topics should I prepare for the Fidelity Investments Data Analytics interview?
This practice set leans on Statistics and Case Studies (8), Power BI (6), Data Modelling & Warehousing (5), Data Cleaning (5). Revise those first, then practise explaining one or two of your own projects end to end, because most Fidelity Investments interviewers ask you to walk through real work.
Are these the exact questions asked at Fidelity Investments?
No. These are curated practice questions that match the skills and difficulty usually tested in banking & finance interviews like Fidelity Investments's. They are not a leaked or verified list of past questions.
Where does Fidelity Investments hire Data Analytics professionals in India?
Fidelity Investments has large teams in Bengaluru, Chennai, Gurugram. Openings and locations change often, so check the Fidelity Investments careers page and filter by city and experience.
Data Analytics questions for similar companies
Banking & finance
Kotak Mahindra Bank
Data Analytics interview questions
Mumbai, Bengaluru
View questionsBanking & finance
Standard Chartered
Data Analytics interview questions
Chennai, Bengaluru, Mumbai
View questionsBanking & finance
American Express
Data Analytics interview questions
Gurugram, Bengaluru
View questionsBanking & finance
HSBC
Data Analytics interview questions
Hyderabad, Pune, Bengaluru
View questionsBanking & finance
State Bank of India
Data Analytics interview questions
Mumbai, Navi Mumbai
View questionsBanking & finance
Wells Fargo
Data Analytics interview questions
Hyderabad, Bengaluru, Chennai
View questionsMore ways to practise
Company-wise Data Analytics questionsPackage-wise Data Analytics questionsExperience-wise Data Analytics questionsRole-wise Data Analytics questionsCity-wise Data Analytics questionsMost asked Data Analytics questionsScenario-based questionsPractical / hands-on questionsHR & behavioural questionsData Analytics mock interviewOnline assessment questionsTechnical round questionsManagerial round questionsData Analytics topic sheets