抱歉,您的浏览器无法访问本站

本页面需要浏览器支持(启用)JavaScript


了解详情 >

practice english interview

小舟從此逝 江海寄餘生🧘 is inputting

If you really want to do it you can! Just keep on trying your best and practice whenever you have time.

Diligence is not a race against time, but continuous, dripping water wears through the rock.

VISA - Sr. Data Engineer

Preferred Qualifications

  • Java and Big Data technologies like Hive, Hadoop, and Spark
  • Understanding and working experience with shell scripting
  • Knowledge and working experience on Git/Stash, Ant, Maven, Jenkins and Jira
  • Experience with database technologies like DB2, Oracle, SQL Server
  • Knowledge of Unix/Linux
  • Strong foundation in computer science, with strong competencies in data structures, algorithms and software design optimized for building highly distributed and parallelized systems

ByteDance - Data Engineer - Global Payments ByteDance Singapore, Singapore

Qualifications

  • Bachelor’s degree or above in Computer Science, Statistics, Mathematics or other related majors;
  • At least 3 years of experiences and above;
  • Proficient in at least one programming language such as Python, Java, Scala, Go, etc., with a strong engineering background and interest in data;
  • Prior experience with writing and debugging data pipelines using a distributed data framework (Hadoop/Spark/Flink/Storm etc.);
  • Familiar with OLAP engines (Hive/ES/Clickhouse/Druid/Kylin/Doris etc.);
  • Familiar with data warehouse architecture, data modelling methods and data governance; enthusiastic about data mining, strong business understanding and abstraction capabilities;
  • Proficient in databases, strong SQL/ETL development ability;
  • Experience in real-time data warehouse development is preferred.

Grab - Senior Data Engineer, Finance Cortex

The day-to-day activities:

Build, deploy and manage big data solutions that can adequately handle the needs of a rapidly growing data driven company
Spearhead the development of systems, architectures, and platforms that can scale to the 3 Vs of Big data (Volume, Velocity, Variety)
Streamline data access and security to enable data scientists and analysts to easily access to data whenever they need to
Build out scalable and reliable ETL pipelines and processes to ingest data from a large number and variety of data sources
Maintain and optimize the performance of our data analytics infrastructure to ensure accurate, reliable and timely delivery of key insights for decision making
Lead the movement cleaning and normalizing subsets of data of interest as preparatory step before deeper analysis by the data scientists
Run Modern high performance analytical databases and computation engines like Spark, Flink, Presto, Synapse, BigQuery, Greenplum and others

The must haves:

A degree or higher in Computer Science, Electronics or Electrical Engineering, Software Engineering, Information Technology or other related technical disciplines.
Experience in handling large data sets (multiple PBs) and working with structured, unstructured and geographical datasets
Designed high performance scalable infrastructure stacks for Big Data Analytics
Deep understanding of databases and best engineering practices - include handling and logging errors, monitoring the system, building human-fault-tolerant pipelines, understanding how to scale up, addressing continuous integration, knowledge of database administration, maintaining data cleaning and ensuring a deterministic pipeline
Real passion for data, new data technologies, and discovering new and interesting solutions to the company’s data needs
Excellent communication skills to communicate with the product development engineers to coordinate development of data pipelines, and or any new products features that can be built on top of the results of data analysis

Apple - Data Engineer, Media Products

  • Proven experience working on big data systems and distributed computing, such as Hadoop and Spark.
  • Proficiency in using query languages like SQL, Hive and SparkSQL.
  • Experience with entity-relationship modeling and understanding of normalization.
  • Experience with sessionization of clickstream and time-series data is a plus.
  • Familiar with the concepts of dimensional modeling.
  • Experience maintaining a large software system and writing a test suite.
  • Experience with Continuous Integration, Version Control such as git.
  • Experience with programming languages such as Scala, Spark or Python.
  • Experience with data visualization tools, such as GGplot, etc.
  • Deep understanding of data structures and common methods in data transformation.
  • Keep up-to-date with the newest technology trends.

Amazon - Sr. Data Engineer

  • Expert working knowledge on SQL and Python/Scala to perform data processing, building data models, conducting data analysis.
  • Exceptional visualisation skills using Tableau, Qlikview or other relevant visualisation tools. - Exhibits sound business judgment, a proven ability to influence others, strong analytical skills, and a proven track record of taking ownership, leading data-driven analyses, and influencing results
  • Strong written and verbal communication skills, with a track record of presenting to senior management - Effective self-starter who excels in a lean and fast-paced organisation

1. Spark & Spark SQL

1.1 Spark Basic

  1. Spark History / Why Spark / Spark Components (SparkCore & SparkSQL) / Ecosystem
  2. Spark Features
  3. Resilient Distributed Dataset – RDD
    → a. Ways to create Spark RDD
    → b. Spark RDDs operations (Transformation/Action)
    → c. Sparkling Features of Spark RDD (Lazy Evaluation/Fault Tolerance/Partitioning/Parallel)

1.2 SparkSQL

1.3 SparkInterview

1.4 SparkSQL 源码解读

3.1 mr vs spark (4)
3.2 rdd / dataframe / dataset
3.3 rdd operations - transformation + action
3.4 cache + persist
3.5 spark join

2. Project

Spark 优化

3. BI

  1. OLTP / OLAP On-line Analytical Processing
  2. ETL -> ODS -> DIL(DWD)/DIM -> DML(DWM) / APP(DAL)/DIM
  3. Hive -> DDL / DML / Select / Function
  4. data warehouse review 6

大数据是 database+分布式体系结构的结合

4. SQL 🐒

No. Question Answer
1. ✅SQL:查找重复数据? group by 列名 having count(列名) > n
2. ✅SQL:如何查找第N高的数据? limit 1, n
3. ✅SQL:查找不在表里的数据 t1 & t2 join, where t2.field = NULL
4. SQL:如何比较日期数据?
197. Rising Temperature
自关联 + datediff

DATEDIFF(w1.recordDate, w2.recordDate) = 1 AND w1.Temperature > w2.Temperature;
5. SQL:各科成绩平均分大于80分的人数和人数占比 sum(case when 1, 0), count(b.id)
join (select avg(score) from t group id)
6. SQL:连续出现N次的内容? 方法2: window function, lead, where
7. SQL:经典topN问题 window function: row_number() over (partition by … order by…
8. SQL:面试必备—SQL window function?
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
Input: 
Weather table:
+----+------------+-------------+
| id | recordDate | temperature |
+----+------------+-------------+
| 1 | 2015-01-01 | 10 |
| 2 | 2015-01-02 | 25 |
| 3 | 2015-01-03 | 20 |
| 4 | 2015-01-04 | 30 |
+----+------------+-------------+
Output:
+----+
| id |
+----+
| 2 |
| 4 |
+----+
Explanation:
In 2015-01-02, the temperature was higher than the previous day (10 -> 25).
In 2015-01-04, the temperature was higher than the previous day (20 -> 30).


SELECT
w1.id AS 'Id'
FROM
weather as w1
JOIN
weather as w2
ON DATEDIFF(w1.recordDate, w2.recordDate) = 1 AND w1.Temperature > w2.Temperature;

5. Leetcode

5.2 dfs + stack

  1. 字符串解码 “3[a2[c]]” == “accacc”, stack == [(3, “”), (2,“a”)]
  2. The Kth largest element in the array 【heapify(hp) , heappop(hp), heappush(hp, v) 】
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
from heapq import heapify, heappush, heappop 
# The heap in python is a small root heap: heapify(hp) , heappop(hp), heappush(hp, v)
class Solution:
def findKthLargest(self, nums: List[int], k: int) -> int:
n = len(nums)
if k == 0 or k > n:
return []

hp = nums[:k]

heapify(hp)

for i in range(k, n):
v = nums[i]
if v > hp[0]:
heappop(hp)
heappush(hp, v)

return hp[0]

5.3 dynamic programming

5.4 sliding window & hash

7. English

2022.06.07
Average questions mostly on SQL, 1 question on data structure. In depth explanation of your current and recent projects. Another interview was based on architecture solutions for certain scenarios.

  1. SQL questions like self joint
  2. python coding questions like sort algorithm

First I had a phone screen with the hiring manager involving some Spark/Kafka questions. Then a phone screen with a common Leetcode question. After passing those I had a virtual onsite with five 1 hour interviews.

First interview was with the HR person. Second interview was with the hiring manager. Third was a simple tech screen (sql). Next level was to meet the team, about 4 people at 45 min each.

They asked pretty basic questions in the initial tech screen. Questions about lag/lead and how you might handle clickstream data.
String Manipulation questions (medium leetcode)
Couple SQL questions
Lot of Design based questions
Lots of SQL queries
Why Spark is preferred over Mapreduce?

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
private static Map<String, Integer> namesToNumPurchases = new HashMap<String, Integer>() {{
put("Chris", 10);
put("Bob", 5);
put("David", 5);
put("Sue", 12);
put("Jim", 3);
}};

/*
Required output:

3: Jim
5: Bob, David
10: Chris
12: Sue
*/

Find the occurance position of string in sequence of chars.
difference between Python and Scala
SQL physical and logical schema, 2 problem solving/riddle questions
create market basket output from sql.

2022.05.29
1. tell me about yourself
My name is blair.

I have 7years work exp related data engineer . Ever since I graduated from university in 2014. I’ve put my time into programming and data engineer related dev work.

now I working in Tencent Company Singapore brunch, which is largest tech company in Asia.

I focused on financial bigdata collection, calculation, analysis and processing related dev work;

This allowed me to get a deeper understanding of data warehouse modeling and spark knowledge…

During my time there, I successfully build financial data warehouse projects that won the Company-level Business Breakthrough Award

I believe I have all the knowledge and skills needed to do well in the data engineer field.

2. tech problem

3. project problem Tell me about a challenging project you have

4. bhv problem

4.1 Why are you interested in this job?

After looking at the job description, I found that…

This is Why I’d love to have the opportunity to …

I believe I would be able to…

4.2 Why did you leave your last job?

Quite simply…

4.3 How Do You Handle Conflict in the Workplace?

Tell me about a time you disagreed with your boss.

Communication is key

Many conflicts take place due to a lack of communication and understanding. For this reason, it is usually better to voice a difference in opinion immediately and in a civilized way, rather than allowing underlying[ˌəndərˈlīiNG] resentment[rəˈzentmənt] and anger to result in conflict.

4.4 Do you work well under pressure?

One time I was supposed to deliver a project to a PM in five days. A colleague who was working with another PM had the same deadline, but he had to take a leave of absence due to personal reasons. I was forced to take up both projects at the same time, but I did not let the stress affect me. Instead, I came up with a very detailed time management plan and found new ways to boost efficiency that enabled me to deliver both projects on time. Although tired”

4.5: Why should we hire u?

There are a couple of reasons why I think I’m a good fit for this position

First of All 2. Another reason is that… 3. Finally

2022.05.27 阿滴English - tell me about your self?

I’ve always wanted to work in the finance tech company because I have a passion for it and I think it has a lot of potential.

In my senior year I also participated in an intership at DuDu Digital and stayed there for two full semesters.

This allowed me to get hands-on experience about what works and what doesn’t, putting what I learned in school into practice.

During my time there, I successfully launched there marketing projects that gave the company 50% return on investment. Of course there were other projects that didn’t go that well but I learned from those failures as well.

Overall I have to say it was an extremely rewarding internship.

Now that I’ve graduated, I fell like I’m ready to take on anything. I have studied in a relevant field and worked directly in the industry. I believe I have all the knowledge and skills needed to do well in the marketing field.

2022.05.26
I’ve always wanted to work in the finance tech company because I have a passion for it and I think it has a lot of potential.

This’s why I focused on marketing

Class Topic: Job interviews

Class Goal: To use the English Language to express ideas and opinions as well as respond to lesson activities
Corrected Sentences

One of my weakness is my second language skills which I am currently working on.

Lesson Vocabulary

Target language

• Describing a strength and giving extra information to support it: I’m very proactive. I try to fix problems before they become serious. / I’m enthusiastic about my work. I love being in sales. / My greatest strength is curiosity. I love to learn new things. / Persistence is my greatest strength. I don’t give up until I succeed. / I’m a really good communicator. I’m especially good at listening.

• Describing a weakness and giving extra information as to how you improved: I’ve had problems with public speaking, but my manager is coaching me, so I’ve improved quite a bit. / My technical knowledge was a bit weak, so I started taking computer classes at night. / My team told me that I needed to be a better listener. They’re helping me work on that, and I’ve improved a lot.

• Words related to strengths: clever, bright, sharp, ambitious, determined, understanding, sensitive, resilient, thick-skinned, confident

• Words related to weaknesses: touchy, thin-skinned, insensitive, big-headed, arrogant, cocky

2022.05.23 How to Kick Ass in an English Interview
Q1: Can you tell me about yourself?

Ever since I graduated from… I’ve put my time into…

I’ve worked for… I have two years of experience in …

My strength lies in … I managed to …[我达成了]

A little bit about me personally is… people person … team player … go-getter … outgoing … positive … active … reliable

Q2: What do you know about own company?

亲驴子kiss ass: Most impressive is the fact that…

I also really like the idea of… I think that is fantastic

Q3: Why are you interested in this job?

After looking at the job description, I found that…

This is Why I’d love to have the opportunity to …

I believe I would be able to…

Q4: Why did you leave your last job?

Quite simply…

Q5: Why should we hire u?

There are a couple of reasons why I think I’m a good fit for this position

  1. First of All 2. Another reason is that… 3. Finally

2022.05.22 Talking about Yourself in an English Interview

Most importantly, I’m gonna make a personal promise to you to work hard and not let you down.

Q1: Talking about Yourself
Q2: Why are you qualified for this position and what preparations have you made?

Clear target - from in the future speaking

Q3: Choose a few things about what you’ve done
focused, participated, allowed, launched

I believe I have all the knowledge and skills

clear target: I’ve always wanted to work in data engineer…

How To Be Confident In Interviews

Business Intelligence Data Analyst Shopee SQL Test - Contoh Soal dan Pembahasan

You need to play the role of both interviewee and interviewer

Comments