CITIC Group Data Analyst Interview Questions
The questions to prepare for a CITIC Group Data Analyst interview. Questions from real interview reports rank first. Updated daily.
Design a recurring batch orchestration system for daily trading workflows with dependency management, idempotent reruns, and pre-market SLAs.
CITIC GroupDiscuss automating a manual reporting workflow with code, focusing on batch ETL, orchestration, and data quality.
CITIC GroupPractical approach for maintaining data quality across ML ETL pipelines, orchestration, and repeatable data processing.
CITIC GroupExplain how to clean messy financial data in PostgreSQL using filtering, standardization, NULL handling, and validation logic.
CITIC GroupWrite a SQL query to find the top 3 performing assets in each sector over the last quarter. Use the provided sector, asset, and performance data. Treat an...
CITIC GroupCompare weekly store performance with targets and rank stores by combined sales, labor, and waste variance.
Mcdonald'S Global Office In IndiaAggregate monthly sales by product category and use LAG to calculate month-over-month changes.
Total Wine & More
Inc.
Benjamin MooreSign up to see every question
Create a free account to unlock this list and practice real interview questions.
Compute the expected waiting time to see two consecutive heads when flipping a fair coin.
CITIC GroupTests probability reasoning and ability to compute exact or conditional outcomes.
CITIC GroupTests ability to connect analysis outcomes to investment and asset management decisions.
CITIC Group