HCLTech ETL Tester Interview Questions and Answers for Freshers

Interview preparation tips for other job seekers - Be confident during interviews

Interview preparation tips for other job seekers - Questions from resume and walk-ins have more chance

Round: Test
Experience: Selected for round 2

Round: Group Discussion
Experience: Selected for round 2
Duration: 15 minutes

Skills: Communication
College Name: SJRCW

Round: Test
Experience: Each section consisted of 15 questions.If you have a thorough practise on aptitude,the LR and the basic apti part would be not of much problem.The coding part mainly consisted of data structure basic.
Tips: The only tip which can be given is a thorough practise for all the sessions.The practise should be done taking the time into account.
Duration: 1 hour
Total Questions: 60

Round: Technical Interview
Experience: Fortunately for me,they asked me my AIEEE and IITJEE scores rather than only concentrating on my CGPA which was an advantage for me.Training related questions,questions on basic science(fission,fusion etc) were asked.Also my coding knowledge was being tested by asking basic data structure questions.
Tips: Always carry a smile whether its going wrong or right.Be apologetic on your mistakes and tell them you can improve yourself.The confidence you carry is the thing they are searching for in any interview.

College Name: NIT Durgapur

Round: Test
Experience: English skill based test, it was more like a basic clearance test. There were two different rounds one of them was to listen/read and then fill up questions (approx. 45min) other one was the Telephonic test (computer generated test, approx. 15min).
Tips: Aptitude is a must, so practise
Duration: 60 minutes

Round: Group Discussion
Experience: Here the way you interact in a group and essence of your points. Personally I felt that they didn’t concentrate much on speaking skills as such.
Tips: Practise to talk in groups, current affairs  and even random topics
Duration: 15 minutes

Round: HR Interview
Experience: I was tested on basic understanding of Big Data and tested on enthusiasm
Tips: Puzzles (for most startups) and HR & resume based for others mostly.prepare things very much related to the company.

Skill Tips: Starting earlier helps . Aptitude requires some time and it is better to start atleast during summer vacation. Last two months before placements can be spent for other preparations.
College Name: IIT MADRAS

Round: Test
Experience: I performed well in the written test, and there was a speaking and listening test too.  I felt quant was most important for the tests, fast mathematics, then technical questions. Technical questions generally asked by core companies. Some programming based companies also ask such technical questions.



Puzzles can help you in answering quant questions also. The tests were mostly MCQ. Some tests were there which had subjective question papers. None of the core companies had subjective type, but coding companies had such questions. 





They were write a program to do *task* type questions. The programming language to write the code in, was our choice. The language options were C, C++, Python, Java. Python was rarely asked, though.
Duration: 3 hours minutes

Round: Group Discussion
Experience: Don't quite actually remember those topics. But, skills they wanted to test was to see how well they were able to express their ideas, but without outwardly disrupting others while talking.

Round: HR Interview
Experience: The interview was at least 40 minutes, with 5 minutes of HR interview for my current work profile. 

The HR usually starts with “Tell me about yourself”. Then they go through the resume, and ask about the project (DDP, in my case) and internship. This was done by the HR team, just to see how the candidate is putting forth his ideas and contributions clearly.
Tips: Since I cleared the tests, I was allowed to appear for the interviews, but after that, the CGPA played a major role in the final selection. Hence people with low CGPA had to perform exceptionally well to compensate for the low CGPA. However, I don’t know of the internal mechanism of shortlisting, so I was of the opinion that CGPA did not result in elimination of candidates, (except for the candidates who were eliminated due to the cutoff CGPA). But it played a role in the final selection.

For managerial positions, PoRs like coordships, coreships etc can be used to pitch your leadership qualities. They can start a chain of conversation that involves the work you did, on how you managed to execute the task efficiently, which ends up working in your favour.

Round: Puzzle Interview
Experience: Two puzzles were given in the interview. I did well in both, hence got selected. Another puzzle was to measure 45 minutes of time elapsed by using two candles, both of which take 1 hour to burn out completely.

General Tips: I was weak in thermodynamics, so he covered that course revision, for core placements. I prepared from the material sent by Shruti. That was all I prepared. The Coursera for R language was not that useful for me as I was looking for a managerial position.In case of resume shortlists, students who had done management, operations research or economics courses were preferred.
Otherwise, one has to justify your selection through good pitching. Finance companies are sort of open minded; they are looking for people who would do the job. Anyways, they will be providing training, so the knowledge in finance gained through independent means is not quite significant. It will, however, give an edge in the tests, as finance and quant based questions will be asked. They won’t go deep info finance.
I also suggest to freshies and second years to complete the core credited intern in the second year itself so that they can take up an intern of their choice, be it either research intern or core intern in their 3rd year summer. It offers much greater flexibility to the students. It will be useful, especially for non-core placements. I started preparing for the interviews late. I did not put pen to paper, to write down his answer for the ice-breaking questions like “Introduce yourself”. It would be better to write those answers down and get them polished, rather than trying to remember it and/or make it up spontaneously.
Skill Tips: For handling pressure, I suggest that after the interviews are over, just eat and get a good night’s sleep. Preparing/analyzing about the performance in the interview would only make you more anxious, affects sleep, and this would affect your performance in the interviews the next day. The additional one hour of preparation is not going to make a big difference.
Skills: Speaking Ability, Ability to express your ideas, Capable of managing things efficiently
College Name: IIT MADRAS

Round: Resume Shortlist
Experience: A balanced resume is preferred. It helped me in the further stages of the selection process, as everything was quite based on how was my resume.

Round: Test
Experience: It was actually and English skill based test, more like a basic clearance test. Two different rounds were there:(i)Listen/read and then fill up questions (approx. 45min) (ii) Telephonic test (computer generated test, approx. 15min).

I also appeared for other companies like Auctus and Reliance. Auctus had direct interview SL and Reliance had Aptitude and Technical (Mech) approx. 30 minutes each.
Tips: Aptitude is a must, so practice.
Duration: 1 hour minute

Round: Group Discussion
Experience: They actually tested the skills of the way you interact in a group and essence of your points. Felt that they didn’t concentrate much on speaking skills as such.
Tips: Practice to talk in groups, current affairs  and even random topics.
Duration: 10-15 minutes minutes

Round: Technical Interview
Experience: Basic understanding of Big Data and tested on enthusiasm. 
For others: 

Reliance – Corrosion & welding based questions; it was mainly a technical round
Auctus – Only HR was taken
Housing – Puzzles and HR (same round)
Deloitte – Basic consult based questions on whatever was given in JD.


For core:Reliance – Corrosion engineering, welding courses and a bit of 1st year metallurgy. BTP was related to Corrosion and discussion about BTP happened.
Tips: Puzzles (for most startups) and HR & resume based for others mostly.

General Tips: Aptitude and puzzle preparation is a must. For interviews prepare things very much related to the company. (For startups knowledge related to their field might be a plus point)If people are looking for Non-Core: better that they do some good and useful non-core intern atleast once, taking part in competitions will also help.



2ndyears can learn ‘R’ or any other technical stuffs which can be useful for non-core (mainly, Fin or analytics)Case studies are good to prepare for one month atleast.
Skill Tips: Starting earlier helps and I started around October. Aptitude requires some time and it is better to start atleast during summer vacation. Last two months before placements can be spent for other preparations.
Skills: English based skills, How to interact with people, Aptitude
College Name: IIT MADRAS
Motivation: Mostly based on the enthusiasm towards the field of work and the basic understanding of it.

Round: Test
Experience: Speed Maths was easy, it was such that
silly mistakes were quite probable. It lasted for an hour. English was for 1.5
hrs. It was based on TOFEL(speaking, writing, listening)

General Tips: Criteria for getting shortlisted for
Capgemini’s stages of selection was performing well in puzzles and maths.

They did not stress on PORs or internships,
neither did they take the minor into account.No case study topics asked were asked.1st years- Concentrate on CG, put fight for
Day 1, Day 2 companies

2nd years- Concentrate on CG,try learning
coding(coursera) and algorithmic and financial analytics.

Try to obtain an internship in the company
you want to get placed in. It may not be a very good intern, but should be a
meaningful one.

3rd years-Focus on CG, obtain a good
internship.



Practice maths in the last 4
months.(probability mainly)



If you want a finance company, then read newspaper regularly, try to
obtain certifications like CFA, NCFM, etc.
College Name: IIT MADRAS