Informatica Business Analyst Interview Questions
The questions to prepare for a Informatica Business Analyst interview. Questions from real interview reports rank first. Updated weekly.
Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.
InformaticaExplain OLTP vs OLAP designs, including schema shape, workload patterns, and when each is appropriate in a data platform.
InformaticaExplain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.
InformaticaTests understanding of SQL join semantics and practical data modeling choices.
InformaticaFind the second highest salary in each department without using aggregate functions.
Credit Genie
Devoteam
Cisco Restaurant + BarJoin customers and transactions, filter to the previous quarter, aggregate spend, and return the top three customers by total spend.
Apptio
Quantiphi
DiscoverTests how you gather requirements under ambiguity by using stakeholder management, structured communication, and problem clarification.
InformaticaTests stakeholder requirement gathering under ambiguity, with emphasis on communication, alignment, and turning conflicting input into clear requirements.
InformaticaTests prioritization under pressure across stakeholders, with emphasis on trade-off judgment, influence, and clear communication.
InformaticaTests requirements discovery and ability to structure stakeholder questions.
InformaticaSign up to see every question
Create a free account to unlock this list and practice real interview questions.