C5i Data Engineer Interview Questions

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

50questions

~8htotal time

Track your progressSign up free to work through all 50 questions and resume where you left off.

SQL & Data ManipulationStart here. 26 questions · ~240 min

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

Second Highest Trader SalaryEasy

Practice

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

SubqueriesRankingSorting

C5i

SQL Running Total by DateMedium

Practice

Aggregate posted OneTrust privacy request charges by date and calculate cumulative revenue with a CTE and window function.

Window FunctionsDate FunctionsRunning Totals

C5i

More SQL & Data Manipulation questions with a free account

Pipelines15 questions · ~139 min

Approach for adding data quality checks, observability, and production monitoring to a data pipeline.

Star vs Snowflake SchemaEasy

Compare star and snowflake schemas in a warehouse pipeline, including structure and transformation trade-offs.

snowflake schemastar schemaData Modeling

C5i

Troubleshoot a Failed Deployment PipelineMedium

Approach for diagnosing a failed deployment pipeline, tracing dependencies, and deciding when to roll back safely.

ToolsDependenciesQuality

C5i

More Pipelines questions with a free account

Create a free account to unlock this list and practice real interview questions.

Behavioral & Leadership8 questions · ~74 min

Influencing Without Formal AuthorityEasy

Tests influence without authority: aligning stakeholders through data, empathy, and ownership to drive a decision and measurable outcome.

Influence Without AuthorityStakeholder ManagementCommunication

C5i

More Behavioral & Leadership questions with a free account