Dataford
Dataford
Top 29
Prep plan
Updated weekly · Last refresh Oct 26

Informatica Data Analyst Interview Questions

The questions to prepare for a Informatica Data Analyst interview. Questions from real interview reports rank first. Updated daily.

29questions
~4htotal time
Track your progressSign up free to work through all 29 questions and resume where you left off.
Start practicing free →
1
SQL & Data ManipulationStart here. 7 questions + 1 drill · ~72 min
Top Customers by Last-Quarter SpendMedium
Practice

Join customers and transactions, filter to the previous quarter, aggregate spend, and return the top three customers by total spend.

Date FunctionsJoinsAggregationsInformatica
Explain Full Outer vs Left JoinMedium

Explain how FULL OUTER JOIN and LEFT JOIN differ when reconciling customer records across systems.

JoinsData WranglingCase WhenInformatica
Window Ranking in Ticket QueuesMedium

Explain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.

Window FunctionsRankingrow_numberInformatica
SQL Join for Web and LeadsMedium
Practice
Practice drill

Join Informatica marketing-site traffic to CRM leads and summarize sessions, pageviews, and lead outcomes per visitor.

JoinsAggregationsInformatica
More SQL & Data Manipulation questions with a free account
2
Pipelines5 questions · ~44 min
ETL vs ELT Trade-offsEasy

Compare ETL and ELT, and explain when ELT is the better pipeline pattern.

ETLELTData ModelingInformatica
Pipeline Error Handling BehaviorMedium

Evaluates your understanding of failure modes and error record handling in ETL or integration pipelines.

error handlingETLInformatica
More Pipelines questions with a free account

Sign up to see every question

Create a free account to unlock this list and practice real interview questions.

Get my prep plan
3
Behavioral & Leadership14 questions · ~124 min
More Behavioral & Leadership questions with a free account
4
More topics3 questions · ~26 min
Investigate User Engagement DeclineMedium

Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.

RetentionDiagnosisEngagement MetricsInformatica
Back-Test Predictive AccuracyHard

Tests ability to evaluate model performance using rigorous back-testing methodology.

model validationTime SeriesInformatica
Probability for Sequential EventsHard

Tests probability reasoning for sequential dependent events.

Expected ValueConditional ProbabilityInformatica
The finish line: interview-readyComplete all 29 questions plus 1 hands-on drill to finish this plan.