Skip to content

Latest commit

 

History

History

Folders and files

NameName
Last commit message
Last commit date

parent directory

..
 
 

Interview Process for Data Engineer - 2021 (Personal Experience):

1. First Round - Introductory Round:

  • Introduction to yourself,About the company.
  • Project experience, Tech stacks you are comfortable with, basic programming questions.
  • Relevance of your background to the role.
  • Interview process detailing and other questions if you may have or interviewer has.

2. Online Coding Test on Codility:

  • 1 question on SQL and 1 question on programming.

  • Programming question - Say a string composed of only letters a and b, numbers of ways to split it into 3 substrings such that all 3 substrings have same number of character 'a's.

  • SQL question: Please find the question below -

    image

3. Coding Round (Programming test - Data transformations using Apache Spark Live):

  • Given 2 data questions - Transform data using Apache spark transformations live, Execute them and present the results - environment for execution of spark programs is provided.

4. Design Round:

  • Document is provided which describes the problem statement and bottlenecks in existing architecture and what the requirement is - Design a scalable Machine learning system that automates the e2e ML workflows and helps analysts and stakeholders in their seamless outputs consumption - Architectural choices, Technology stack that you choose need to be explained clearly and reason behind that choice - would be an addition if the alternative approaches are also explained.

5. Problem Solving Round:

  • This round is not a technical interview but tests on the problem solving skills of yours - A real world situation with some helpers are given, come up with the steps to mitigate the problem and measures taken to solve that problem.

6. Awesomeness interview:

  • Discussions and questions about working with a team and challenges that are faced - questions on how you handled that in past.

7. Behavioral Interview:

  • Working under a stressful situation.
  • How is the conflict with a co-worker resolved?
  • How do you keep yourself updated and enthusiastic about latest tech trends? and other questions.