屡败屡战的大数据秋招之英文面试准备

去外企写代码是我梦想中的工作。读研期间系统的进行了算法和听力训练。最近几次的英文面试发现自己存在随机发挥、“我肯定过不了的”的逃避思想。因此决定将这件事工程化处理，以期达到流畅且清晰的表达自己的观点、完全发挥自己的能力的效果。认真准备每一次英文面试，不做把面试当练习口语的怨种。珍惜机会，尊重面试官尊重自己的时间。

分三大块进行准备：Behavior Questions/ Algorithm Coding / Tech Stack

Basic Questins

Self-Introduction
Why do you want to join us
Let's talk about one successful project - what role you played in and what was the challenge？
In University, the government was promoting waste sorting and recycling. We decided to design a garbage collection application for local property manager. I was in charge of the division of labor and the development of Android Application.
The development process was slow down. One the one hand, Everyone has different levels of development knowledge and merging the code manually was very painful. I decided to adopted pair programming that means each group has a experienced one and a newbie. It helped promote the whole level of the team quickly. On the other hand. merge the code manually is painful, we decided to use git to manage the project.
When the application was Online, different mobile phone models have different display effects，some are unsatisfactory. We choose to extend the time of testing and design function test and model test to make the application suitable for all mainstream models.
Did you have conflict with others, how did you solve it?
Let's talk about the most difficult chanllenge you faced. how did you solve it. Did you talk with others.
Why do you want to join JPMorgan chase. Why do you think that you fit for this position?

Big Data & Backend

Kafka 101 learning the terminology in Kafka

https://www.youtube.com/playlist?list=PLa7VYi0yPIH0KbnJQcMv5N9iW8HkZHztH

Algorithms

https://www.youtube.com/c/BackToBackSWE

Sorting algorithms
Single-Source Shortest Path

Tech Stack

Let's talk about your project, from the the background, whole process and the division of labor.
Talk about your understanding about Self-Driving Cars. Talk about the Level4 Robotaxi project. What's your role in the project. What's the current status of the project?
Let's talk about the hierarchical offline data warehouseproject?

ODS Operational Data Store layer: Receive and Store the Original data. this layer is like a backup in case of failover.
DWD Data warehouse Detail:Choose the Business Line. Construct the fact table according to the minimum granularity of this Business line.
DIM Dimention:There are different business lines. All Business has unified dimension. In my application, the dimension is User, Region, Time, commodity
DWS Data Warehouse Summary :Construct data model based on the dimension. take the Region dimention as example, i calculate the purchase summary , the refund summary of each area.
ADS Application Data Service:This layer is used to generate reports charts. It often corporate with tools like Superset.