I am not sure if I can say this is a question but that is what they asked : we have a flat file with all transaction coming from third party, that data need to be pushed into our database and then give a result for reporting purpose with an open source ETL tool. how would you do that? ( they are not specific about what ETL tool, no details on flat file and etc.)
Data Engineer Interview Questions
Data Engineer Interview Questions
Data engineers are IT professionals who are needed in almost every industry. Data engineers monitor data trends to determine best next steps for companies. A critical part of a data engineer job is to process raw data into usable data by creating data pipelines and building data systems.
Top Data Engineer Interview Questions & How To Answer
Question #1: Can you describe in detail your level of expertise with programming languages?
Question #2: Explain data engineering in your own words.
Question #3: Can you describe your experience working with Apache Hadoop and cloud data management environments?
20,132 data engineer interview questions shared by candidates
Spark out of memory handling
What is the difference between Java and Python?
Did you work with NOSQL databases before?
*For the coding questions in previous rounds, they may ask to write algorithm on paper and also may ask to implement on coderpad in our favorite language. *Round 8 (HR round, phone, 20 mins ): - He explained about the company, role and asked about my interests. Salary negotiation. Availability to join.
SQL
They asked if I had ever worked at a data center before. I laughed and told them I've literally worked at the data center that I'm applying to work for them at for them as a contractor. They had no idea and don't seem to communicate in between offices
How would you monitor dbt in a production capacity?
what is meant by driving table?
Describe a time you had to recover from a DR event
Viewing 371 - 380 interview questions