I went through 3 rounds of assessments online, which included Aptitude MCQs, Technical MCQs and Coding, Communication. After qualifying them one by one, had the interview scheduled offline. Both TR and HR were conducted on the same day. In both of them, the managers asked questions based on projects, education, hobbies and also asked to do very basic coding in Java and SQL.
Interview questions [3]
Question 1
Write code for creating table and inserting values in SQL.
I applied online. The process took 4 weeks. I interviewed at Tech Mahindra (Bangalore Rural) in Aug 2024
Interview
The interview is all most subject and related technology based questions. The question are based on subject experience with working knowledge.The interviewer took to complete almost 4 week process finally I got offer and accepted.
Interview questions [1]
Question 1
Subject questions and Woking exercises based scenarios.
HR Resume Screening:
The HR team reviews submitted resumes to shortlist candidates based on qualifications, experience, and relevance to the job description.
Scheduling Interviews:
Shortlisted candidates are contacted to schedule interviews. This may involve coordinating times between candidates and interviewers.
Technical Interviews (2 rounds):
First Technical Interview: Focuses on data engineering concepts, tools, and problem-solving skills. Candidates may be asked to complete coding challenges or discuss their experience with data pipelines, ETL processes, and databases.
Second Technical Interview: Delves deeper into specific technologies or projects the candidate has worked on. This round may involve practical scenarios, system design questions, or case studies relevant to data engineering.
Managerial Interview:
This interview assesses leadership qualities, teamwork, and cultural fit. Candidates may be asked about their approach to project management, collaboration, and handling conflicts in a team setting.
Interview questions [1]
Question 1
Can you explain the differences between structured, semi-structured, and unstructured data?
How do you design an ETL pipeline? What considerations do you take into account?
What are the key components of a data warehouse architecture?
How do you ensure data quality and integrity in your data engineering processes?
Can you describe a project where you used big data technologies, such as Hadoop or Spark? What challenges did you face, and how did you overcome them?