eClerx Junior Data Analyst Interview Questions, Process, and Tips

Q1. A practical application of VLOOKUP on a given data
Ans. 
VLOOKUP can be used to find specific information in a table by matching a key value.
• Use VLOOKUP to find a student's grade based on their student ID in a table of student data

• VLOOKUP can be used to retrieve a customer's contact information based on their customer ID

• It can also be used to look up product prices based on product codes in a pricing table
Answered by AI
Add your answer
Q2. Give me a run through your resume.
Add your answer
Q3. Are you okay with working overtime?
Add your answer
Q4. What SQL commands do you know?
Ans. 
I am familiar with basic SQL commands such as SELECT, INSERT, UPDATE, DELETE, JOIN, and GROUP BY.
• SELECT: Retrieve data from a database table

• INSERT: Add new records to a table

• UPDATE: Modify existing records in a table

• DELETE: Remove records from a table

• JOIN: Combine rows from two or more tables based on a related column

• GROUP BY: Group rows that have the same values into summary rows
Answered by AI
Add your answer
Q5. What work did you oversee in your previous work place?
Add your answer

The test had two rounds which were 1 hour and 25 minutes in duration respectively. The first round comprised objective questions on English, Reasoning, and Quantitative aptitude. The second round comprised writing a paragraph on a given topic.

Q1. Tyes of Brakes in vehicle
Ans. 
Types of brakes in vehicles include disc brakes, drum brakes, and anti-lock brakes.
• Disc brakes use calipers to squeeze brake pads against a rotor to slow down the vehicle.

• Drum brakes use brake shoes to press against the inside of a drum to stop the vehicle.

• Anti-lock brakes prevent wheels from locking up during braking, allowing the driver to maintain steering control.
Answered by AI
Add your answer
Q2. Rxplain rack and pinion mechanism
Add your answer

Q1. Basic excel question.
Add your answer

Q1. Hobbies. Interest in data anaylst
Ans. 
My hobbies include analyzing data from various sources and finding patterns. This interest led me to pursue a career in data analysis.
• I enjoy working with Excel and SQL to manipulate and analyze data

• I like to read articles and books about data analysis and statistics

• I participate in online forums and communities to learn from other data analysts

• I have completed online courses and certifications in data analysis

• I enjoy ...read more
Answered by AI
Add your answer