Data wrangling test for hiring
See how candidates prepare and check data before it is used for analysis.
- 10 рдорд┐рдирд┐рдЯреЗ
- 15 рдкреНрд░рд╢реНрди
- рдордзреНрдпрдо
- рдмрд╣реБрдкрд░реНрдпрд╛рдпреА
- рдЗрдВрдЧреНрд░рдЬреА рдордзреАрд▓ рдкреНрд░рд╢реНрди
- рдлреЛрди рдЖрдгрд┐ рдбреЗрд╕реНрдХрдЯреЙрдк
рдереЛрдбрдХреНрдпрд╛рдд рдЙрддреНрддрд░
The Data Wrangling test measures how candidates pull fields out of files and text, fix messy values, reshape and join tables, and check the result, working from small tables and short Python with pandas or standard SQL. It suits intermediate data analysts, data scientists, data engineers, reporting developers and machine learning engineers who prepare their own data.
рд╣реЗ рдХрд╛рдп рдореЛрдЬрддреЗ
Parsing, cleaning, reshaping, joining and checking data for analysis, read from small tables and short code.
Extraction and parsing
Candidates work out how to pull fields from files and text.
Data cleaning
Candidates identify steps that fix messy data values.
Reshaping and combining
Candidates reason about reshaping tables and combining them through joins.
Data quality checks
Candidates check whether prepared data is ready for someone to rely on.
рдкреНрд░рд╢реНрдирд╛рдВрдЪреЗ рдкреНрд░рдХрд╛рд░
рдмрд╣реБрдкрд░реНрдпрд╛рдпреА
рдЙрдореЗрджрд╡рд╛рд░: рдереЛрдбрдХреНрдпрд╛рдд рджрд┐рд▓реЗрд▓реА рдкрд░рд┐рд╕реНрдерд┐рддреА, рддрдХреНрддрд╛ рдХрд┐рдВрд╡рд╛ рд╡рд┐рдзрд╛рди рд╡рд╛рдЪреВрди рдпреЛрдЧреНрдп рдЙрддреНрддрд░ рдХрд┐рдВрд╡рд╛ рд╕рд░реНрд╡ рдпреЛрдЧреНрдп рдЙрддреНрддрд░реЗ рдирд┐рд╡рдбрддреЗ.
рддреБрдореНрд╣рд╛рд▓рд╛ рджрд┐рд╕рддреЗ: рдЙрдореЗрджрд╡рд╛рд░рд╛рд▓рд╛ рд╡рд┐рд╖рдпрд╛рдЪреЗ рдЬреНрдЮрд╛рди рдХреЗрд╡рд│ рдУрд│рдЦрдгреНрдпрд╛рдкреБрд░рддреЗрдЪ рдирд╛рд╣реА, рддрд░ рддреЗ рд▓рд╛рдЧреВ рдХрд░рддрд╛ рдпреЗрдИрд▓ рдЗрддрдХреЗ рдЖрд╣реЗ рдХреА рдирд╛рд╣реА.
10 рдорд┐рдирд┐рдЯрд╛рдВрдд 15 рдкреНрд░рд╢реНрди, рдПрдХрд╛ рд╡реЗрд│реА рдПрдХ рдкреНрд░рд╢реНрди рджрд┐рд▓рд╛ рдЬрд╛рддреЛ.
рд╣реА рдЪрд╛рдЪрдгреА рд▓рд╛рдЧреВ рд╣реЛрдгрд╛рд▒реНрдпрд╛ рднреВрдорд┐рдХрд╛
Data analysts, data scientists, data engineers, analytics and reporting developers, data warehouse staff, and machine learning engineers who prepare their own data.
What this test can show
Judgment on messy records
See how candidates fix values in business records such as orders, sensor readings and shipments.
Reasoning from code and tables
Questions ask what a short step in Python with pandas or standard SQL produces, or which step would fix a problem.
Checks before anyone relies on it
Data quality questions show whether a candidate checks a cleaned or combined table before others build analysis on it, rather than trusting the step that produced it.
рдкреНрд░рддреНрдпреЗрдХ рдЙрдореЗрджрд╡рд╛рд░рд╛рд╕рд╛рдареА рддреБрдореНрд╣рд╛рд▓рд╛ рдХрд╛рдп рдорд┐рд│рддреЗ
- рд╕рдВрдкреВрд░реНрдг рдЪрд╛рдЪрдгреАрджрд░рдореНрдпрд╛рди рдЪрд╛рдЪрдгреАрдЪрд╛ рдЯреЕрдм рдЙрдШрдбрд╛ рдареЗрд╡рд▓рд╛
- рдкреЗрд╕реНрдЯ рдХреЗрд▓реЗрд▓реА рдЙрддреНрддрд░реЗ рдирд╛рд╣реАрдд
- рд╕реНрдерд┐рд░ рдЧрддреАрдиреЗ рдЙрддреНрддрд░реЗ рджрд┐рд▓реА
рд╕реНрдХреЛрдЕрд░, рдкреНрд░реЛрдлрд╛рдЗрд▓ рдЖрдгрд┐ Integrity Score рдордзреАрд▓ рд╕рдВрдХреЗрдд рд╣реЗ рдореБрд▓рд╛рдЦрддреАрд╕реЛрдмрдд рддреБрдореНрд╣реА рддрдкрд╛рд╕рдгреНрдпрд╛рд╕рд╛рдареАрдЪреЗ рдкреБрд░рд╛рд╡реЗ рдЖрд╣реЗрдд; рддреЗ рдХрдзреАрд╣реА рд╕реНрд╡рдпрдВрдЪрд▓рд┐рдд рдирд┐рд░реНрдгрдпрд╛рдЪрд╛ рдЖрдзрд╛рд░ рдирд╕рддрд╛рдд.
рд╣реА рдЯреЗрд╕реНрдЯ рд╡рд┐рдирд╛рдореВрд▓реНрдп рд╡рд╛рдкрд░рд╛
Test integrity signals
Each candidate receives a different set of questions from large question pools. Questions appear in a different order for each attempt, and answer options are shuffled. The browser receives one question at a time, and answer keys stay on HireValidтАЩs servers. Timing runs on the server, so reloading restores the same question with only the time left. Question text cannot be copied or selected. HireValid records signals such as time away from the test tab, pastes into answers, and answers faster than a question can be read. These are summarized in an Integrity Score with an evidence timeline for you to review; the score does not decide on its own. With candidate consent, you can add webcam photos at random moments. See how we build our tests.
AI рдЪреНрдпрд╛ рдорджрддреАрдиреЗ рд╣реЛрдгрд╛рд░реА рдлрд╕рд╡рдгреВрдХ рдЖрдореНрд╣реА рдХрд╢реА рд░реЛрдЦрддреЛ ┬╖ рд╡рд┐рд╢реНрд╡рд╕рдиреАрдпрддреЗрдЪреЗ рд╕рдВрдХреЗрдд
Use the score as evidence
Review the score alongside a work sample that asks candidates to prepare and check data relevant to the role. A structured interview can explore their choices. Treat the test as one source of evidence, not a verdict. For related context, compare it with the Data Extraction, Transformation, and Loading (ETL), Data Science, or Pandas test.
Structured interview questions
Tell me about a time you had to prepare messy data for analysis. How did you decide what to fix?
Listen for a clear account of the data issue, the cleaning choices, and how the candidate checked the result.
How would you investigate a table that needs to be combined with another before analysis?
Listen for how they would inspect the tables, decide how to join them, and check the combined result.
Describe a data quality problem you found before others used the data. What did you do next?
Listen for the check they used, how they traced the issue, and how they handled the affected data.
рд╕реНрдХреЛрдЕрд░рд┐рдВрдЧ рдЖрдгрд┐ рдмреЗрдВрдЪрдорд╛рд░реНрдХ рд╕рдордЬреВрди рдШреНрдпрд╛
рдирд┐рд╖реНрдкрдХреНрд╖рддрд╛ рдЖрдгрд┐ рдЖрд╡рд╢реНрдпрдХ рд╕реБрд╡рд┐рдзрд╛
Questions use neutral business records such as orders, sensor readings, sign-ups and shipments. Names come from many backgrounds, and there are no money symbols, idioms or local knowledge. Dates are written in year-month-day form unless a question is about date formats. The code is short and uses widely taught features of Python with pandas and standard SQL. It avoids behavior that differs between library versions or database products, so the test measures wrangling judgment rather than one tool's quirks. Scratch paper is allowed for every candidate, and no question needs a calculator.
рд╕реЛрдпреАрд╕рд╛рдареА рддреБрдореНрд╣реА рдХреЛрдгрддреНрдпрд╛рд╣реА рдЙрдореЗрджрд╡рд╛рд░рд╛рд▓рд╛ рдЕрддрд┐рд░рд┐рдХреНрдд рд╡реЗрд│ рджреЗрдК рд╢рдХрддрд╛. рдирд┐рдХрд╛рд▓ рд╣реЗ рдПрдЦрд╛рджреНрдпрд╛ рд╡реНрдпрдХреНрддреАрдиреЗ рддрдкрд╛рд╕рдгреНрдпрд╛рд╕рд╛рдареАрдЪреЗ рдкреБрд░рд╛рд╡реЗ рдЖрд╣реЗрдд, рд╕реНрд╡рдпрдВрдЪрд▓рд┐рдд рдирд┐рд░реНрдгрдпрд╛рдЪрд╛ рдЖрдзрд╛рд░ рдирд╛рд╣реАрдд.
Provisional: reliability is reported once 200 candidates have completed it.
рдЪрд╛рдЪрдгреАрдЪреЗ рддрдкрд╢реАрд▓
A short, timed test of getting data ready for analysis. Candidates pull fields out of files and text, fix messy values, reshape and combine tables, and check the result before anyone relies on it. Questions show small tables and short snippets of Python with the pandas library or standard SQL, and ask what a step produces or which step fixes a problem.
- рдкреНрд░рд╢реНрди рдЗрдВрдЧреНрд░рдЬреАрдордзреНрдпреЗ рдЖрд╣реЗрдд.
- рдкрд░рд╡рд╛рдирдЧреА рдЕрд╕рд▓реЗрд▓реА рд╕рд╛рдзрдиреЗ: рдЦрд░рдбрдгреНрдпрд╛рд╕рд╛рдареАрдЪрд╛ рдХрд╛рдЧрдж.
- рдкреНрд░рддреНрдпреЗрдХ рдкреНрд░рд╢реНрдирд╛рдЪреЗ рдЙрддреНрддрд░ рдХреНрд░рдорд╛рдиреЗ рдПрдХрджрд╛рдЪ рджреЗрддрд╛ рдпреЗрддреЗ. рдорд╛рдЧреАрд▓ рдкреНрд░рд╢реНрдирд╛рдХрдбреЗ рдкрд░рдд рдЬрд╛рддрд╛ рдпреЗрдд рдирд╛рд╣реА.
- рд╡реЗрд│реЗрдЪреНрдпрд╛ рдорд░реНрдпрд╛рджреЗрддреАрд▓ рдЯреЗрд╕реНрдЯрдкреВрд░реНрд╡реА 4 рд╕рд░рд╛рд╡ рдкреНрд░рд╢реНрди, 3 рдорд┐рдирд┐рдЯреЗ.
Python, pandas рд╣реА рддреНрдпрд╛рдВрдЪреНрдпрд╛ рдорд╛рд▓рдХрд╛рдВрдЪреА рдЯреНрд░реЗрдбрдорд╛рд░реНрдХ рдЖрд╣реЗрдд. HireValid рддреНрдпрд╛рдВрдЪреНрдпрд╛рд╢реА рд╕рдВрд▓рдЧреНрди рдирд╛рд╣реА рдХрд┐рдВрд╡рд╛ рддреНрдпрд╛рдВрдЪреЗ рд╕рдорд░реНрдерди рдкреНрд░рд╛рдкреНрдд рдирд╛рд╣реА.
рд╡рд╛рд░рдВрд╡рд╛рд░ рд╡рд┐рдЪрд╛рд░рд▓реЗ рдЬрд╛рдгрд╛рд░реЗ рдкреНрд░рд╢реНрди
Who should take the Data Wrangling test?+
It is intended for intermediate data analysts, data scientists, data engineers, analytics and reporting developers, data warehouse staff, and machine learning engineers who prepare their own data. It fits people who clean and reshape data themselves, not only those who analyze it.
How does the Data Wrangling test handle fairness?+
Questions use neutral business records such as orders, sensor readings, sign-ups and shipments. Names come from many backgrounds, there are no money symbols, idioms or local knowledge, and dates use year-month-day form unless a question is about date formats. The code uses widely taught features of Python with pandas and standard SQL, and avoids behavior that differs between library versions or database products, so it measures wrangling judgment rather than one toolтАЩs quirks.
Can candidates use scratch paper on the Data Wrangling test?+
Yes. Scratch paper is allowed for every candidate, and no question needs a calculator. Candidates can also try a practice set of 4 questions that takes 3 minutes before the 10-minute test.
Can candidates go back or take the Data Wrangling test on a phone?+
The test runs on a phone or a desktop. Each of the 15 questions is answered once, in order, with no going back, so a candidate decides what a pandas or SQL step produces before moving on. Some questions have one correct answer and others ask candidates to select every option that applies.
рд╕рдВрдмрдВрдзрд┐рдд рдЪрд╛рдЪрдгреНрдпрд╛
рдбреЗрдЯрд╛ рдХрд╛рдврдгреЗ, рд░реВрдкрд╛рдВрддрд░рд┐рдд рдХрд░рдгреЗ рдЖрдгрд┐ рд▓реЛрдб рдХрд░рдгреЗ (ETL)
10 рдорд┐рдирд┐рдЯреЗ, рднреВрдорд┐рдХреЗрдиреБрд╕рд╛рд░ рдЖрд╡рд╢реНрдпрдХ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛рдбреЗрдЯрд╛ рд╕рд╛рдпрдиреНрд╕
10 рдорд┐рдирд┐рдЯреЗ, рднреВрдорд┐рдХреЗрдиреБрд╕рд╛рд░ рдЖрд╡рд╢реНрдпрдХ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛рдбреЗрдЯрд╛-рдЖрдзрд╛рд░рд┐рдд рдирд┐рд░реНрдгрдп рдШреЗрдгреЗ
10 рдорд┐рдирд┐рдЯреЗ, рднреВрдорд┐рдХреЗрдиреБрд╕рд╛рд░ рдЖрд╡рд╢реНрдпрдХ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛рдбреЗрдЯрд╛ рд╕реНрдЯреЛрд░реАрдЯреЗрд▓рд┐рдВрдЧ
10 рдорд┐рдирд┐рдЯреЗ, рднреВрдорд┐рдХреЗрдиреБрд╕рд╛рд░ рдЖрд╡рд╢реНрдпрдХ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛рдЕрдиреНрд╡реЗрд╖рдгрд╛рддреНрдордХ рдбреЗрдЯрд╛ рд╡рд┐рд╢реНрд▓реЗрд╖рдг
10 рдорд┐рдирд┐рдЯреЗ, рднреВрдорд┐рдХреЗрдиреБрд╕рд╛рд░ рдЖрд╡рд╢реНрдпрдХ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛рдбреЗрдЯрд╛рд╕рд╣ рдХрд╛рдо рдХрд░рдгреЗ
10 рдорд┐рдирд┐рдЯреЗ, рднреВрдорд┐рдХреЗрдиреБрд╕рд╛рд░ рдЖрд╡рд╢реНрдпрдХ рдХреМрд╢рд▓реНрдпреЗ
рдПрдХреНрд╕рдкреНрд▓реЛрд░ рдХрд░рд╛рддреБрдордЪреНрдпрд╛ рдкреБрдвреАрд▓ рднрд░рддреАрд╕рд╛рдареА рдбреЗрдЯрд╛ рд╡реНрд░рдБрдЧрд▓рд┐рдВрдЧ рдЯреЗрд╕реНрдЯ рд╡рд╛рдкрд░рд╛
Free рд╕рд╣рд┐рдд рдкреНрд░рддреНрдпреЗрдХ рдкреНрд▓реЕрдирдордзреНрдпреЗ рд╕рдВрдкреВрд░реНрдг рдЯреЗрд╕реНрдЯ рд▓рд╛рдпрдмреНрд░рд░реА рдЙрдкрд▓рдмреНрдз рдЖрд╣реЗ.