In this post, we will see the questions asked in the 1st round of Impetus Technologies  company Interview for 1.5+ year of experience guy in big data field.

Let’s see the questions:

1. Tell me about yourself and what is your responsibility in the team?
2. Explain architecture of Hadoop?
3. How many types of table in Hive?
4. What are the benefits of different types of tables in Hive?
5. When we use which hive tables, give me some scenerios?
6. Write down the hive command for reading the data from the particular partition of table?
7. Write down the hive command for deleting the particular partition from the table?
8. How many number of buckets allowed?
9. What is the difference between Partitioning and Bucketing?
10. Why we are using Partitioning and Bucketing?
11. Why your client wants to migrate data pipelines from on-prem system to cloud?
12. Tell me the difference between on-prem system and cloud?
13. What are the advantages and dis-advantages of hive?
14. What are the advantages and dis-advantages of Google Big Query?
15. What is the difference between Drop, Delete and Truncate in Sql?
16. Write Sql Query for getting 2^nd highest salary from the employee table?
17. Write Sql Query for getting all the employee name from the employee table which has salary > 50,000 ?
18. Write Sql Query for getting all the employee details whom first name is start with ‘A’?
19. Write Sql Query for updating all the employee salary by 1000rs?
20. Write Sql Query for updating all the employee salary by 5000 rs if employee location is Delhi and work experience is greater than 5 yr?
21. What is the difference b/w Row number, Rank and Dense Rank functions in Sql?
22. Tell me scenario in which case we need to use Row number, Rank and Dense Rank functions?
23. What are the commands you know in Unix?
24. Write the unix/linux command for deleting last line from the file.
25. Write the unix /linux command for fetching 5^th column from the file?
26. What type of records you are processing on day to day work?
27. Tell me about any challenges which you faced in your projects/ Any challenging task you did in your team?

This interview was held around for 1 hour through Microsoft Teams Video Call and taken by Module Lead Software Engineer.

Check out the given link for knowing about this company: Home (impetus.com)

Check out the given link for knowing about this company rating on Glassdoor: Impetus Technologies Reviews | Glassdoor

Check out the given link for this company profile on Linkedin: Impetus: Overview | LinkedIn

Thank you for reading this post.