Informatica Business Analyst Interview Questions
The questions to prepare for a Informatica Business Analyst interview. Questions from real interview reports rank first. Updated daily.
Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.
InformaticaExplain how to identify, assess, and handle missing values in SQL using NULL checks, COALESCE, and validation logic.
InformaticaExplain OLTP vs OLAP designs, including schema shape, workload patterns, and when each is appropriate in a data platform.
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 manage changing client scope during a live deal, including expectation-setting, stakeholder alignment, and ownership.
InformaticaTests requirements gathering in an ambiguous setting, including stakeholder alignment, communication, and ownership of a clear final scope.
InformaticaTests ownership and learning agility when a project slips or underdelivers, including how you manage stakeholders and adapt after failure.
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.