I applied online. The process took 1 day. I interviewed at eClerx (Pune) in May 2021
Interview
1. Online Assessment or Aptitude Test
This is usually the first step and may include:
Logical Reasoning & Quantitative Aptitude
Data Interpretation
Excel MCQs (shortcuts, formulas,pivot tables)
2. Technical Interview (Round 1)
This is more role-specific and can include:
Writing SQL queries to extract, filter, join data.
Explaining Excel formulas and creating dashboards or pivot reports.
Questions on Data Cleaning, Data Validation, and Reporting
Techniques.
Interview questions [1]
Question 1
What is the difference between VLOOKUP, HLOOKUP, INDEX-MATCH, and XLOOKUP?
How do you use Pivot Tables for data summarization?
What are some Excel functions used for cleaning data
How do you remove duplicates in Excel?
The interview process consisted of a telephonic round followed by a written test. The telephonic interview focused on basic communication skills, analytical thinking, and understanding of data concepts. The written test included logical reasoning, basic data interpretation, and problem-solving questions. Overall, the process was smooth and well-structured.
Interview questions [1]
Question 1
Explain a data analysis problem you solved using Excel or Python.
Eclerx have 3 rounds
1 Aptitude text on verbal ability, Logical reasoning
2. Group Discussion where they give the topic we have to prepare for 2mins
3. Final interview technical and scenario based. Be confident and very good communication
Interview questions [1]
Question 1
They asked me about the Power BI
They asked me about SQL
Some excel questions
I applied online. The process took 1 week. I interviewed at eClerx (Airoli) in Dec 2024
Interview
HR Round
Aptitude Round
* English
* Logical Reasoning
* Mathematical Reasoning
* English Typing test
Technical Round
* Final year project
* A task to solve
* Questions based on resume
