How to export data in json format ? (From my coding experience)
Data Engineer Interview Questions
20,280 data engineer interview questions shared by candidates
SQL testing: this includes window function and how to evaluate there is duplicate records in this table.
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
Viewing 2181 - 2190 interview questions
See Interview Questions for Similar Jobs
Perl DeveloperModeling EngineerAnalytics EngineerData AnalystData ModelerEtl TesterDatastage DeveloperEtl DeveloperDatawarehouse DeveloperData Warehouse DeveloperData MinerDatabase AdministratorData ScientistMachine Learning ScientistData Warehouse ArchitectBusiness Intelligence SpecialistOracle Data IntegratorData Warehouse ManagerBusiness Objects Developer