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.
sql: already present in glassdoor. 1)ratio of is_fat and is_someother among total products 2)top 5 single channel companies that spent max amount on promotion. take into account of the ones that have only single entry company , channel; 1 food, water 2 food 3) percentage of sales on first day and last day python: occurrences of a letter in a string, replace none with previous value in a list, from a dictionary get the keys corresponding to nth highest value.
simple sql queries, but hard schema
Design a dashboard to highlight a certain aspect of the user behaviour
Why do you want to return to Stori?
They asked me to explain how I would design and optimize a cloud-based data pipeline on GCP, including data ingestion, transformation, storage, and performance considerations.
The questions were very easy related to my resume. How good are you with python elasticsearch and Big Data
SQL questions: 1. First question was based on the ranking and join to get the solution 2. Second follow up question used the same database and tables. The question asked for a rolling average based on last 3 days. 3. Third question was again based on a rolling sum and then count query based on that rolling sum. All of the SQLs required CTE statements Lastly the Python programming question was a basic for loop to search the position of a target number. Interviewer asked for a different approach of solving it.
Multiple SQL Questions
Describe DHCP to non-tech people
One question they asked was what do I think data engineering is. I think when applying for this role you should have a good sense of the data engineering ecosystem and opportunities and what it means to different people as well as what it means to you.
Viewing 1561 - 1570 interview questions