General Technical Tool Proficiency Questions
Familiarity and practical experience with technical productivity and analysis tools such as SQL, Python or R, data visualization platforms like Tableau and Power BI, Excel, and statistical or analytical software. Candidates should be able to describe depth of expertise, typical use cases, examples of real world applications, automation or scripting practices, and how they select tools for different problems. This topic includes discussing reproducible workflows, data preparation and cleaning, visualization best practices, and integration of tools into cross functional projects.
HardSystem Design
0 practiced
Design a monitoring system for production ML models that detects data drift, concept drift, and performance degradation. Specify metrics to collect (e.g., PSI, KS statistic, AUC, latency), alerting thresholds, sampling strategies for labeled feedback, dashboards, and automated remediation actions such as rollback or retraining triggers.
MediumTechnical
0 practiced
In PySpark, joining a 1B-row events table with a small lookup table causes heavy shuffles. Explain strategies to speed up the join such as broadcasting the small table, repartitioning, salting for skewed keys, bucketing, and using join hints. Provide a short code example showing how to broadcast a small DataFrame.
HardSystem Design
0 practiced
Design a secure data science sandbox environment where analysts can run queries and notebooks against sensitive datasets without exporting raw PII. Include access controls, ephemeral notebook runtimes, restricted network egress, query result masking/anonymization, audit logging, and a process for requesting elevated temporary access.
HardTechnical
0 practiced
Model accuracy dropped by 12% over two weeks. Describe a triage plan to determine whether this is due to data drift, label drift, concept drift, feature engineering regressions, or an operational issue. List hypotheses to test, quick statistical checks and visualizations, logs and artifacts to examine, and immediate mitigation steps to reduce business impact.
EasyTechnical
0 practiced
You're delivering dashboards in Tableau or Power BI. Explain how you'd set up user access and row-level security so managers see only their region's data. Describe how this impacts data source configuration, extracts vs live connections, and dashboard performance.
Unlock Full Question Bank
Get access to hundreds of General Technical Tool Proficiency interview questions and detailed answers.
Sign in to ContinueJoin thousands of developers preparing for their dream job.