Role: Big Data and Cloud
Eligibility:
- 10th ,12th, Diploma: 60% & above
- Engineering: 6.75 CGPA & above
Detailed Recruitment Procedure: I have applied through college placements. It consists following stages.
Round 1: Online Assessment: 46 Questions 70 min. This Question includes:
- 2 SQL query (very easy)
- 1 coding question (Check whether a given number is a prime number or not)
- 43 MCQ (based on Linux, python, cloud, big data, data structures, SQL concepts)
Round 2: Technical Interview 1 (30 min): This interview consists of lots of basic questions related to technologies.
- Introduce yourself
- Explain 1 project in detail
- Write SQL query to find the Third highest salary of the employee
- What is the base class in java
- Use of finally block in java
- Explain all OOP concepts.
- How to remove duplicates from the list
- Difference break and continue statement
- ACID Properties in DBMS,
- Explain Joins in SQL
- Difference between truncate and drop command
- Difference between having and group by clause
- what is trigger
- Git concepts
- Asked on hobbies
- Asked some fundamental questions about big data and Hadoop
- Some technical certification questions
Round 3: Technical Interview 2 (30 – 45 min)
- Introduce yourself
- Give me one example where we can use left join
- what is a singleton class in java
- explain projects in detail
- How to deploy a project in Microsoft azure cloud
- Explain normalization in SQL
- Git commands
- Questions Based to resume
- 2-3 general knowledge questions
- Some puzzles asked
Round 4: HR Interview (15-20 min): This was the last round of the recruitment procedure.
- Typical HR Questions
- Asked about certifications
- Will you be able to relocate the to other locations?
- Asked on internships
Verdict: Selected!
Tip: Build your resume very well and prepare well for all those things mentioned in your resume.
Article Tags :
Recommended Articles