Perficient Data Engineer Interview Questions
The questions to prepare for a Perficient Data Engineer interview. Questions from real interview reports rank first. Updated daily.
Flatten nested JSON objects into dot and index paths using recursive depth-first traversal.
PerficientEvaluates performance tuning skills for large-scale PySpark workloads.
PerficientOptimize a slow PostgreSQL query that aggregates completed transactions while preserving customers with no matching activity.
PerficientExplain how FULL OUTER JOIN and LEFT JOIN differ when reconciling customer records across systems.
PerficientAssesses awareness of data quality failure modes and mitigation approaches in SQL systems.
PerficientDemonstrate common Kettle transformation tasks by joining order data, aggregating totals, handling missing values, and classifying results.
PerficientTransform comma-separated employee tags, join employees to managers, and aggregate active direct reports by manager and tag.
TredenceSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Explain how you apply automated testing and CI practices to data pipelines and pipeline releases.
PerficientEvaluate when a pipeline should use stream processing versus scheduled batch based on latency, cost, complexity, and data quality needs.
PerficientApproach for handling schema changes and data quality checks in a high-volume data lake pipeline.
Perficient