Skip to contentSkip to footer

Junior Etl Developer Interview Questions

Salaries
Interviews

1,245 junior etl developer interview questions shared by candidates

The takehome consisted of receiving a binary file, and having to extract the information to export into a CSV file. The information had a caesarean cipher applied to it (specifically ROT13), so what you need to do is read in the file (I did this by pulling all the strings from the file), organizing it by row (the rows are grouped into First Name, Last Name, email + Date (sometimes), and zip code + email), split the rows from the file into different columns, apply the ROT13 shift to get it back to normal, and save that dataframe into a csv. Keep in mind there is a name column missing, and there is sometimes an extra character added to the end of some lines randomly. With this, you should be able to solve it quickly
avatar

Senior Engineer (ETL)

Interviewed at Vetspire

3.2★
May 1, 2024

The takehome consisted of receiving a binary file, and having to extract the information to export into a CSV file. The information had a caesarean cipher applied to it (specifically ROT13), so what you need to do is read in the file (I did this by pulling all the strings from the file), organizing it by row (the rows are grouped into First Name, Last Name, email + Date (sometimes), and zip code + email), split the rows from the file into different columns, apply the ROT13 shift to get it back to normal, and save that dataframe into a csv. Keep in mind there is a name column missing, and there is sometimes an extra character added to the end of some lines randomly. With this, you should be able to solve it quickly

Viewing 1021 - 1030 interview questions

Glassdoor has 1,245 interview questions and reports from Junior etl developer interviews. Prepare for your interview. Get hired. Love your job.