It’s been over a year since you left your last job. What have you been doing lately? Something like that.
Etl Developer Interview Questions
1,579 etl developer interview questions shared by candidates
Sql joins
How many layers you have invloved in ETL testing?
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
What value would i add to the organization.
All questions about ODI
Basics SQL questions and simple SQL code
Most questions are directed at the technical experience needed for the position.
Interview questions are moderate level but the task they give you before that is to build entire system is time consuming.
I cannot recall the specific questions asked. Most were with regards to behaviors in the workplace or job-related tasks. There was also a SQL skills test.
Viewing 1361 - 1370 interview questions