Skip to contentSkip to footer

Informatica Analist Interview Questions

Salaries
Interviews

418 informatica analist interview questions shared by candidates

SQL: Triggers Function syntax Procedure execution Joins how do you optimize slow running query delete and drop Common Table expressions Normalization They will give scenarios and ask you to write the queries. Power Bi: difference of Filter/ slicer page level filters Import mode and direct query Relationships some example scenerio questions: if i take the live data can we refresh the report everyday? if i have 5 lakhs record and 10k records which one you will use import mode or direct mode? Time intelligence functions
avatar

SQL Developer/Data Analyst

Interviewed at Capgemini

4.1★
Oct 13, 2025

SQL: Triggers Function syntax Procedure execution Joins how do you optimize slow running query delete and drop Common Table expressions Normalization They will give scenarios and ask you to write the queries. Power Bi: difference of Filter/ slicer page level filters Import mode and direct query Relationships some example scenerio questions: if i take the live data can we refresh the report everyday? if i have 5 lakhs record and 10k records which one you will use import mode or direct mode? Time intelligence functions

Viewing 361 - 370 interview questions

Glassdoor has 418 interview questions and reports from Informatica analist interviews. Prepare for your interview. Get hired. Love your job.