Skip to contentSkip to footer

Lead Solution Architect Interview Questions

Salaries
Interviews

2,854 lead solution architect interview questions shared by candidates

SQL Coding (45 minutes): The goal of this interview is to determine whether you can build, manipulate, and perform efficient data retrieval of databases using SQL. Please be prepared to solve questions involving SQL constructs, Data Transformation and Optimization Concepts. LANGUAGES When using SQL, you can expect to be assessed on some subset of the following: Ability to complete data processing, manipulation, and analysis tasks using SQL Ability to use joins, subqueries; knowledge of aggregate and analytical functions Working knowledge of the differences between joins (left, inner, outer, etc.) Ability to work with case statements, union and union all Work with concepts including Distinct, Random Sampling, De-Duplication, Optimization Apply the results of your analysis to make product decisions or suggestions Basic data visualization commands
avatar

Solution Architect

Interviewed at Meta

3.6★
Jan 12, 2021

SQL Coding (45 minutes): The goal of this interview is to determine whether you can build, manipulate, and perform efficient data retrieval of databases using SQL. Please be prepared to solve questions involving SQL constructs, Data Transformation and Optimization Concepts. LANGUAGES When using SQL, you can expect to be assessed on some subset of the following: Ability to complete data processing, manipulation, and analysis tasks using SQL Ability to use joins, subqueries; knowledge of aggregate and analytical functions Working knowledge of the differences between joins (left, inner, outer, etc.) Ability to work with case statements, union and union all Work with concepts including Distinct, Random Sampling, De-Duplication, Optimization Apply the results of your analysis to make product decisions or suggestions Basic data visualization commands

There was an NDA so can't say anything specific. Still, perhaps the take-home assignment was the most challenging bit, 5 different data sets that you need to tackle with different data engineering and machine learning skills, and this all has to be done on the databricks platform community edition, you have one week, and you need to score above 80% to pass. Other interviews were pretty much standard question-based, but overall the team was really friendly, great and talented people.
avatar

Solutions Architect

Interviewed at Databricks

4★
Oct 16, 2020

There was an NDA so can't say anything specific. Still, perhaps the take-home assignment was the most challenging bit, 5 different data sets that you need to tackle with different data engineering and machine learning skills, and this all has to be done on the databricks platform community edition, you have one week, and you need to score above 80% to pass. Other interviews were pretty much standard question-based, but overall the team was really friendly, great and talented people.

Viewing 1271 - 1280 interview questions

See Interview Questions for Similar Jobs

Hybris Developer

Glassdoor has 2,854 interview questions and reports from Lead solution architect interviews. Prepare for your interview. Get hired. Love your job.