preface

If you have real talent, it will impress the interviewer!

What if it’s blind writing? I’m about to get my ass kicked!

Recently I was in a job interview, and now I regret writing “proficient” on my resume…

Here’s a list of my skills on my resume:

  • Familiar with the theoretical basis of software testing, familiar with the process and method of software testing, have the ability of test case requirement analysis and design
  • At least 2 years automation test experience;
  • Familiar with Python language and python automatic test process;
  • Familiar with selenium, APpium, UNITTest, PyTest, etc
  • Master web, interface, APP automatic testing technology;
  • Proficient in Linux operation, MySQL database;

As soon as the interviewer finished reading my resume, she gave me a weird smile. (I didn’t think so.)

HR asked three questions in succession:

“I see on your resume that you are proficient in Linux and MySQL

Ask: How does multithreading avoid the call stack mess?”

“SQL is better to use Join, or multiple Select?”

“More than 10 million data, built index or slow, how to do?”

“How can you say you are proficient when you have never used them?”

There are not a few people who are asked silly on the spot like this and then “successfully” lose the interview. The reason is that they are not familiar with the business, which leads to the interviewer being revealed immediately. Although they read some interview articles in advance, they could not apply them properly in practice. In the end, they were interviewed by seven or eight companies, but still failed to receive any offer. Some people even knew they were cool when they saw the expression of the Hr during the interview.

To help you out, I’ve sorted out the lessons I learned when I changed jobs, including interview preparation, interview techniques, and how to answer questions I encountered in the interview process.

Preparation for an interview

1, resume several matters needing attention because of the length reason, the detailed writing method of resume will not speak here. Just a few things to be aware of. (Share resume template at the end)

Don’t dig a hole for yourself

You are responsible for the resume you write. Because when you go to an interview, the interviewer will usually take your resume and ask for details. Technical details, work experience, project status, etc. You must be prepared for the hidden topics behind each word you write.

2. Learn about the company

Before the interview, we should go to the company’s website or other channels to understand the company’s corporate background, business model, main products and so on in advance, so that the interview can be targeted.

You’d better have someone Review your resume

Because a resume is like a program written by yourself, it’s hard to find any bugs on your own, and asking others to review it from the perspective of the interviewer may lead to some unexpected problems. Look for teachers, classmates, friends, don’t be afraid of trouble.

4. Main websites and channels for job hunting

  • Zhaopin.com / 51Job.com (Traditional)
  • Retractor (relatively new)
  • Liepin.com (Senior Talent)
  • V2ex (Cool Job)
  • BOSS Zhipin (Talk to BOSS directly)
  • Relevant communities

5, think of a 3-minute self-introduction case:

Hello, my name is XXX. Today I am here to interview for the position of software test engineer in your company. Next, I would like to introduce myself. (Know and understand the recruitment requirements and skill requirements of the enterprise in advance, respond to them in advance, and the description of skill points should be targeted)

1) I can operate the Linux system and use related commands, and have built a test environment in the project.

2) I used MySQL database and used SQL statements to query data. Sometimes, I queried data in the database when it was necessary to compare submitted data with query data.

3) I am familiar with Python development language, which can be used for Selenium test scripting. The project required the implementation of automatic test scripts for some fixed functions, using unitTest framework, inserting assertions into scripts, introducing external data files, and exporting test reports.

4) Check and compare sensitive data transmitted in the system according to the requirements of the project. Postman is used to make data requests of the interface and check the response results of the server. Fiddler is used to capture data packets and analyze whether sensitive data is encrypted.

5) Cooperated with development and operation to conduct some performance tests of the system in the project. Use JMeter/Loadrunner to perform performance tests on complex and highly concurrent operations of the system.

6) In the project, I was fully involved in requirement review, test plan setting, test case writing, test execution and Bug submission. We used Zen Dao /JIRA to manage and track use cases and defects.

7) For Selenium, Requests, and APPium test development frameworks to be set up in the test, the environment will set up its own.

One of the projects I have done recently is XXXXX management system, in which I was responsible for the testing of XXXX module. His main function was XXXX. He designed and wrote XXX use cases and found XXX bugs.

The above is my self-introduction. Interviewer, is there anything I need to add, or do you want to know more details?

[Click on the picture to share interview tips and materials]Copy the code

The written test in the interview

Written tests vary from company to company, and test development requirements vary, but core technologies include operating systems, TCP/IP protocols, automated testing, Python basics, and logic or intelligence questions in some companies. The definition and process of software testing are more.

The conversation with the interviewer after the written test

  • Don’t be honest and say I don’t know much about it or I don’t know how to steer clear of it or ask the interviewer
  • Show appreciation for what the interviewer has said and what he has said well, and the interviewer will feel happy to communicate with you. You will also appreciate that you are a good listener and know how to absorb good suggestions and opinions from others.
  • When expressing your subjective opinion, you should be assertive

Do a review after the interview

Review is very important, without review action is often ineffective, because there is no summary and precipitation. We should form the habit of frequent rechecking. For the interview review, we can do as follows:

1. Review all your questions and answers in the interview

  • Record HR interview questions and technical interview questions and answers respectively
  • Could you have given a better answer to the interviewer’s question?

2. Write a summary of the interview

It’s best to write a summary of the interview and keep it in your notes. For example, to form such a “job hunting notebook”, share interviews on NIuke.com and CSDN, and record all the gains in this process. This experience is the best resource for future interviews.

3. Learn the rules and prepare again

In the whole review, we should pay special attention to how to maximize the expression of strong logic to prove that they are highly suitable for the position. The STAR method mentioned earlier is a good one.

STAR stands for four steps in answering these questions

Situation (S) – What is the Situation of things

Task (T) – What specific Task do you need to complete

Action (A) – What Action did you take

Results (R) — What is the final result

Keep your answers to 2-3 minutes per question. In these short examples, you should focus on Action and Result, which are the most important things the interviewer cares about. So in terms of time allocation, you need to be very succinct about situations and tasks, and give the general context.

Test development job interview real questions

Source interviews with netease, Meituan, 360, Toutiao, Tencent, Bytedance and other companies, sorted out from Niuke.com, Nuggets, Sifu.

Test the basic test points

1. Bug mandatory fields

2. Describe the lifecycle of the BUG.

3. What do you think is the key to doing a good job with test cases?

4. What phases should constitute a complete set of tests?

5. What does the software acceptance test include?

6, the system test strategy?

7. Write test reports

Describe the lifecycle of software testing activities.

9. Brief the “80-20 principle” in software testing.

10. Composition of a defect test report

11. What are stress tests? What factors should stress tests take into account?

12. What is the purpose of software testing?

13. Common methods of black box test case design

Unit test, integration test, system test, acceptance test, regression test which step is the most important?

15. Describe the advantages and disadvantages of manual testing versus automated testing

16. How to implement automated testing

17. What are stress tests? What factors should stress tests take into account?

Talk about your understanding of CI/CD

19. What do you think software test engineers need to do in a team? What’s the value?

Common test points for automated testing

1. What automation testing frameworks have you learned, to what extent do you know how to use them?

2. Do you encapsulate test automation frameworks?

3. What do you think is the biggest drawback of automated testing?

4. What is compatibility testing? What does compatibility testing focus on?

5. Now I have a program that runs very slowly on Windows. How can I tell whether there is a problem with the program or the software and hardware system?

6. What design patterns are used to automate code?

7. What are the testing strategies?

Describe the complete process of test case design.

What was the execution strategy for automated testing in the last project?

10. What framework did you use for automated testing at your last company?

11. How to automate the test of functions containing verification codes?

12. How to optimize and speed up Selenium script execution?

13. How to deal with the alert pop-up window?

14. What elements positioning methods are you familiar with?

15. Does Seleinum have a library to read Excel files

16. Give me some examples of exceptions you have encountered during Selenium automated testing

17. Have you ever found an element inside a Frame? How do you handle element positioning within frames?

18. How do I highlight the current element during script execution?

What scripting techniques do you know for test automation?

20. How is the PO model made?

Common test points for performance testing

1. What are the application areas of performance testing?

2. What software tests (name at least three) are included in performance testing?

3, deliver a performance test project, please describe your performance test process

4. How to understand stress testing, load testing and performance testing?

5. How does JMeter design performance test scenarios?

6. What does JMeter aggregate report include?

7. Explain the names and meanings of five performance indicators.

What performance problems did you encounter during the performance test?

9, How to use jMeter timer?

10. What is performance testing?

11. What is context switching? Which scenarios have context switches?

12. How to generate test report from command line? How to analyze JTL files?

13. Linux command in performance test

14. When can I start performance testing?

15. Briefly describe the steps of performance testing.

16. Is it necessary to parameterize performance tests? Why create parameters?

17, Describe the software performance concerns of different roles (users, product developers, system administrators)

Common test points for interface tests

1. What kinds of protocol interfaces are most popular in the market?

2. What are the characteristics of HTTP protocol? Can you tell us about these characteristics?

3. How to implement interface association in Postman?

4. If the requested interface needs to be logged in before it can be requested, how to perform interface test?

5. How to test dubbo interface?

6. What aspects are interface test assertions designed from?

7. How to design test cases for interface test?

8, interface test execution need to compare the database?

9. How to clean up garbage data generated by the interface

10. How are interfaces that rely on third-party data tested?

11. What are the advantages of API testing?

12. How to troubleshoot the interface failure?

13. Please briefly explain the differences between cookies, sessions and tokens

Computer network common test points

1, TCP, UDP belong to which layer, difference, application

2, do you know which software uses TCP protocol and which software uses UDP protocol

3, TCP three handshake four wave process and state, three handshake? What happens twice? Four waves? What happens three times? Where does TIME_WAIT appear

4, HTTP status code to understand HTTPS? Talk about the principle, HTTP request, ARP request

5. The difference between HTTP and HTTPS HTTPS encryption

6, Get, POST difference

7, cookie, session differences, application scenarios

8. OSI seven-layer model

Arp attacks

10. How do I change my MAC address

11. What do you do when you start the operating system

What are the message queue interface parameters

13. What is the reason why the page is not displayed correctly

14. What files are in the hypertext sent by the browser

15, browser request, browser input a link to show to the page, after what

Linux commands

1. View processes or process status to check which processes occupy port 8080

2. Check whether a port is occupied and kill the occupied process

3, Linux under the view process will ps,netstate,lsof,top said a bunch of.

4. Count the number of string occurrences

5, find

6. Create a file

7. Review files

8. Modify the file

9, insert,

10. Jump to a line

11, replace,

12, JMM

13, JC

Linux is familiar with what commands.

15, Linux instruction (for loop output 1-100)

16, give a lot of strings of information including IP URL info, info contains error and other status codes, use Linux command to calculate the error probability corresponding to each URL (true will not even remember the problem is not clear about the closed)

17. How to view processes under WindowNS

MySQL database

SQL > select * from having

2, database foreign key

3. Create indexes and classify indexes

4, index function, index when invalid

5. Indexes and stored procedures

6. Add, delete, check and change the database

7, Drop and Delete

What is the difference between relational and non-relational MYSQL

MYSQL > select * from ‘where’ where ‘join’

MYSQL > create index (); MYSQL > create index ()

11, Give a student table, including student ID, class, student grade.

12. Find a class with more than 90 students

Write a SQL

1. Select the 10 oldest people from a list of users (limit+order by)

2. Students with a total score of 85 or above in three courses

3. Select the highest score in Chinese from the database

Python

1. Some advanced features of Python, do you know design patterns?

2. Python data structures: The difference between tuples and lists

Mutable versus immutable in Python

4, there is a set of serial numbers, each serial number is an integer variable, if a serial number error, the following serial number may be wrong, please find the location of the first error serial number

5, parenthesis matching problem (ask the difference between stack and queue)

Test examples

If you want to learn more about test examples, please check out the details

HR often asks interview questions

If you want to know more about HR trap questions, please check the details

The resume template

If you want resume template, you can private ❤️ author or join the learning exchange skirt: front 107 middle 9636 finally 098 through direct download without routine, no decompression password

The last

As for this “painful” experience, it may be that the interviewer sees the mastery on the resume and asks for advice. However, the author does not think this is necessarily a bad thing. If you really know a lot, the back-and-forth with the interviewer is a good time to show it. What did the Internet think?

Thumbs up + collection hand left lingering fragrance, I wish the friends who watched the high salary Offer to receive non-stop