Top 23
Prep plan
Updated weekly · Last refresh Sep 10

Informatica Data Engineer Interview Questions

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

23questions
~4htotal time
Track your progressSign up free to work through all 23 questions and resume where you left off.
Start practicing free →
1
CodingStart here. 6 questions · ~68 min
Detect Cycle in Linked ListEasy
Practice

Use Floyd’s two-pointer algorithm to determine whether a singly linked list contains a cycle.

Hash TablesLinked ListsTwo PointersInformatica
Maximum Subarray Using KadaneEasy
Practice

Compute the maximum contiguous subarray sum in O(n) time using Kadane's Algorithm.

Basic AlgorithmsDynamic ProgrammingArraysInformatica
Balanced Parentheses String ValidationEasy
Practice

Validate a parentheses string using a stack to ensure matching bracket types and correct nesting in O(n) time.

RecursionStackMathInformatica
More Coding questions with a free account
2
SQL & Data Manipulation8 questions + 1 drill · ~101 min
Customer Transaction Running TotalsEasy
Practice

Calculate each customer's cumulative transaction amount over time using a CTE and window function.

Window FunctionsDate FunctionsRunning TotalsInformatica
Second Highest Without AggregatesHard
Practice

Find the second highest salary in each department without using aggregate functions.

SubqueriesRankingSelf-JoinsInformatica
Normalization vs Denormalization TradeoffsMedium

Explain normalization, why it improves data integrity, and when denormalization is a practical performance tradeoff.

schema designperformanceData ModelingInformatica
Second Highest Trader SalaryEasy
Practice
Practice drill

Find the second highest distinct salary from a single table using basic PostgreSQL ordering and limiting.

SubqueriesRankingSortingeClinicalWorksNNeenOpal CanadaInformatica
More SQL & Data Manipulation 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
Technical Fundamentals4 questions · ~45 min
OS Fundamentals and MemoryMedium

Tests understanding of OS memory management concepts relevant to reliable data processing systems.

memory managementOperating SystemsInformatica
Garbage Collection PerformanceMedium

Tests ability to reason about runtime behavior and performance impacts in data engineering workloads.

javaperformanceInformatica
More Technical Fundamentals questions with a free account
4
Behavioral & Leadership5 questions · ~57 min
More Behavioral & Leadership questions with a free account
The finish line: interview-readyComplete all 23 questions plus 1 hands-on drill to finish this plan.