
Ace your #datascience interview with our interview questions, coaching and courses. Join today and start learning!
San Francisco, CA
Joined August 2021
- Tweets584
- Following755
- Followers401
- Likes365
See the most common ETL interview questions in the latest from Interview Query:
interviewquery.com/p/etl-int…
You might get a question like:
- How would you collect/aggregate unstructured video data?
You can propose a three-step solution to the question above: Primary collection/indexing, user-gen content tagging, and binary-level collection.
4
2
At the advanced level, the questions tend to get into:
- More complex data types
- Require strong technical communication skills.
- Go deeper into architecture/design
1
Intermediate to hard questions are generally:
- High-level scenario-based questions: What might be the best solution for X problem?
- Advanced case studies: Design and architect a solution that would fit this business scenario.
1
Basic questions tend to be high-level, discussion-based questions like:
- What ETL tools are you most familiar with?
- What are OLAP cubes?
1
However, the ETL questions that are asked differ by role.
✔️ Analysts can expect basic technical questions related to ETL.
✔️ Developers and engineers can expect advanced ETL case studies.
1
ETL interview questions aren’t just limited to developers. They’re common in #datascience interviews for roles like:
👉 Data Engineer
👉 Business Intelligence
👉 Python Dev
👉 SQL admin
Prepare for an #bizops interview with the latest from Interview Query, Operational Analytics Interview Questions:
interviewquery.com/p/operati…
In addition to case studies, you can also expect:
- Behavioral questions, e.g. “Explain a project you worked on that resulted in operational improvements.”
- Basic tech questions, “Calculate employee turnover rate.”
1
2
The type of #casestudy question you might expect would be:
- How would you determine which products to feature during a Black Friday sale?
Note: Generally, you’ll be provided with a dataset you can use for analysis and solve the question.
1
Here’s what you can expect in case study interviews:
- 30-45 minute discussion
- Questions are vague (use follow-ups to clarify)
- Propose a hypothesis
- Use data to prove/disprove the hypothesis
1
That’s why in interviews, analytics case studies and BizOps case studies get asked.
These questions 👇
1) Ability to use data to solve the problem
2) Problem-solving approach
3) Technical communication ability
1
Operational analytics is used in #BizOps to:
- Make better hiring decisions
- Develop better products
- Improve customer experiences
- Reduce operational waste
- Speed up supply chains
1
3
See the latest Interview Query breakdown of DE salaries in 2022:
youtube.com/watch?v=34fJsuEY…
1
However, many factors affect salaries these include the following:
👉 Company: FAANG, Finance & Healthcare pay the most
👉 Location: SF, Seattle, and NYC have higher average wages compared to other locations
👉 Seniority: Sr, DEs earn $127K in base
1
When you factor in total compensation, engineers earn $191,000 per year.
That includes stock options, bonuses, etc. Just wow! 🤑
1
In 2022, data engineers average $104,000 in base salary.
That’s one of the highest base salaries in tech. Even more than business intelligence roles, analysts & research scientists!
1
There’s a talent shortage in #DataEngineering, and that’s a recipe for RISING SALARIES.
We’ve got the latest stats below! 💰👇
1
1
Test your knowledge with Interview Query’s latest deep-learning interview questions list:
interviewquery.com/p/deep-le…
