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.
Given a string, write a function “recurring char” to find the strings first recurring character. Return “None” if there is no recurring character. Note: Treat upper and lower case letters as distinct characters. You may assume the input string includes no spaces. Example: input = "interviewquery" output = "i" input = "interv" output = "None"
telephonic with technical and SQL coding ) 1 hr Difference b/w SQL and HDFS How do you read, map and reduce and text file in spark ETL How do you create tables in Hive Group by and union with Customer tables Size of data in Hadoop cluster Data warehousing Primarily focused for 45 min on Hive, Spark, Hadoop, HDFS, data warehousing and ETL And, no status on the interview yet, but even though I answered all the questions but, I failed in one coding question of 2 so, I don’t have any hopes for next rounds. It may be useful for you all. Here is the question I got on Amazon Interview Input: SALES_MONTH | PRODUCT_ID |SALE_AMOUNT JAN - 2020 |P1 | 100 FEB - 2020 |P2 | 200 JAN - 2020 |P3 | 500 MARCH - 2020 |P4 | 10 OUTPUT SALES_MONTH | P1_TOTAL |P2_TOTAL JAN - 2020 |100 | 0 FEB - 2020 |0 | 200 MARCH - 2020 |10 | 0
Give an example of a field or industry that would benefit from utilizing its data.
Typical BQ Tell me about when you took on something significant outside of your ae of responsibility Tell me when you work thru tight deadlines Tell me a time when your had conflict with your peer
First question was on palindromic strings of 0s and 1s that I spent too much time on, The second question was "simple" sliding window question on memory allocation. It's funny that I have been in long meetings to discuss this kind of logic, but somehow there was an expectation that I would code this on the spot. Yeah, I failed the tech hazing here. The system design questions were really well-made. I honestly had a lot of fun answering those. Lots of things about availability, architecture, and databases.
I have signed NDA so I can't disclose those but glassdoor has lot of such already mentioned by others.
It wasn't the sort of interview you could characterise by listing questions. Each interview probed a different facet of the job (e.g. database knowledge, customer skills, coding, etc.). They were all disconnected: I had the impression I was interviewing for 8 different jobs.
Tell me about a time where you dealt with a customer obsession
Three SQL queries one was to JOIN two tables to pull required results. Second was about Group & Order by. Third was Window query all very simple and basic. One Python related to write a function to sort an array so it produce only odd numbers.
Describe a situation that your colleague failed the job and what did you do?
Viewing 2171 - 2180 interview questions