Phone call with recruiter with 5 SQL, 5 Python questions
Data Engineer Interview Questions
18,773 data engineer interview questions shared by candidates
Python: 1. count occurrence of a word , 2. Uncommon words from two sentences 3. Replace None with previous value SQL: questions on Sales, Promotion, Product tables. Calculation of percentage of total sales on start and end dates with overall sales, etc.
Sql, python and data modeling
Select a couple columns from a single table where one column equals a keyword.
Given a table of users and whom they sent friend requests to, what is the average number of friend requests sent in the last week?
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.
Viewing 1411 - 1420 interview questions
See Interview Questions for Similar Jobs
Modeling EngineerAnalytics EngineerPerl DeveloperDatawarehouse DeveloperEtl DeveloperData ModelerDatastage DeveloperEtl TesterData AnalystOracle Data IntegratorMachine Learning ScientistData ScientistData MinerBusiness Objects DeveloperDatabase AdministratorData Warehouse DeveloperData Warehouse ManagerData Warehouse ArchitectBusiness Intelligence Specialist