The most challenging question was: If you have 10 TBs of unstructured customer data , and you need to find some clever ways to extract valuable information of it, What do you do? Explain to me in the most technical level that you think.
Data Engineer Interview Questions
18,744 data engineer interview questions shared by candidates
3 rounds 1. Problem Solving and DSA(List & Linked List) 2. Algo and DS(Trees & DP) 3. SQL & Data Modeling
Which are the different types of joins
find a prime number, binary search on a range ,maps based questions ,sql queries medium level, two tables given and find inner join ,cross join, outer join
Talk about a time when you innovated and simplified a project.
Do you have experience in ML?
SQL, Data Modeling
SQL heavy questions in 1st round
I did not make it through the assessment. I was stuck in solving the test cases. Use your time wisely and divide time for each problem. The question was on finding the shortest distance in a site. Leetcode question
SQL. We have a table below : Team ------ India England Srilanka Can you write a SQL code, by which we can generate all possible combinations between the above input teams? We have the below dataset : Employee_salary Sanpshotdate | Employee | Doj | Current Salary -------------------------------------------------------- 01-Jan-2022 | 1 | 01-Jan-2021 | 1000 01-Jan-2023 | 1 | 01-Jan-2021 | 2000 01-Jan-2024 | 1 | 01-Jan-2021 | 2300 01-Jan-2025 | 1 | 01-Jan-2021 | 3000 a) Print for each employee what was current and immediate previous salary b) Identify the employees based on the highest increase of salary from the first salary, who have joined more than 2 years ago c) Identify the employees where salary increase between the last two years are more compared to the average salary increase in the last two years
Viewing 1011 - 1020 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