Informatica Data Analyst Interview Questions
The questions to prepare for a Informatica Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Join customers and transactions, filter to the previous quarter, aggregate spend, and return the top three customers by total spend.
InformaticaExplain how FULL OUTER JOIN and LEFT JOIN differ when reconciling customer records across systems.
InformaticaExplain SQL window functions and when to use ROW_NUMBER() versus DENSE_RANK() for ranked ticket analysis.
InformaticaCalculate each customer's cumulative transaction amount over time using a CTE and window function.
Banco Santander
Anz
Bank Of Tokyo-Mitsubishi UFJFind repeated non-null customer emails in Nagarro onboarding data using GROUP BY and HAVING.
Informatica
Chetu
BJC HealthCareCompare ETL and ELT, and explain when ELT is the better pipeline pattern.
InformaticaEvaluates your understanding of failure modes and error record handling in ETL or integration pipelines.
InformaticaSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Investigate a 15% engagement decline by decomposing the metric, isolating root causes, and proposing actions.
InformaticaTests ability to evaluate model performance using rigorous back-testing methodology.
InformaticaTests probability reasoning for sequential dependent events.
Informatica