Sql joins
Etl Engineer Interview Questions
780 etl engineer 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
What value would i add to the organization.
Basics SQL questions and simple SQL code
Most questions are directed at the technical experience needed for the position.
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.
Management questions are good but Technical questions are not relevant for technology
Tell me about urself? What was the complex situation you faced in your job? and technical questions
Describe why indexing matters in DWH
What is the difference between connected and unconnected lookup?
Viewing 681 - 690 interview questions
See Interview Questions for Similar Jobs
Big Data ArchitectData Warehouse ArchitectSenior Data Warehouse ArchitectSenior Data ArchitectTibco ArchitectBusiness Intelligence ArchitectOracle Data Warehouse DeveloperData EngineeringLead Data ArchitectData Mining EngineerSap BpcSenior Data EngineerData Warehouse Etl TestingSenior Data Warehouse DeveloperPower Bi ConsultantLead Data EngineerPrincipal Data EngineerSenior Data Consultant