Premium Employer

i

This company page is being actively managed by Clover Infotech Team. If you also belong to the team, you can get access from here

Clover Infotech Verified Tick

Compare button icon Compare button icon Compare
3.6

based on 1.1k Reviews

Filter interviews by

Clover Infotech Data Analyst Interview Questions and Answers

Updated 12 Jun 2024

Clover Infotech Data Analyst Interview Experiences

1 interview found

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. What are SQL joins?
  • Ans. 

    SQL joins are used to combine rows from two or more tables based on a related column between them.

    • SQL joins are used to retrieve data from multiple tables based on a related column between them

    • Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

    • Example: SELECT * FROM table1 INNER JOIN table2 ON table1.column = table2.column

  • Answered by AI
  • Q2. What is normalisation?
  • Ans. 

    Normalisation is the process of organizing data in a database to reduce redundancy and improve data integrity.

    • Normalisation involves breaking down data into smaller, more manageable tables

    • It helps in reducing data redundancy and inconsistencies

    • It ensures data integrity and improves database performance

    • Example: Splitting a customer table into separate tables for customer details and orders

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Explain dashboards created by u
  • Ans. 

    I have created interactive dashboards using Tableau to visualize and analyze data for various projects.

    • Utilized Tableau to connect to data sources and create interactive visualizations

    • Designed dashboards with filters, drill-down capabilities, and dynamic elements

    • Included key performance indicators (KPIs) and trend analysis in the dashboards

    • Used color coding and data labels to enhance data interpretation

    • Shared dashboard

  • Answered by AI
  • Q2. Role in ur current organization
Interview experience
2
Poor
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Coding test for all the student attending the first round, give your best practice every day all the best in your interview

Round 2 - One-on-one 

(2 Questions)

  • Q1. What are your interest
  • Ans. 

    My interests include data analysis, problem-solving, and continuous learning.

    • Data analysis

    • Problem-solving

    • Continuous learning

  • Answered by AI
  • Q2. Java related question

Interview Preparation Tips

Interview preparation tips for other job seekers - Give your best
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. How to rotate a Matrix?
  • Ans. 

    To rotate a matrix, transpose it and then reverse each row.

    • Transpose the matrix by swapping elements across the diagonal

    • Reverse each row of the transposed matrix to rotate it clockwise

    • For example, to rotate a 3x3 matrix clockwise: [[1, 2, 3], [4, 5, 6], [7, 8, 9]] -> transpose -> [[1, 4, 7], [2, 5, 8], [3, 6, 9]] -> reverse rows -> [[7, 4, 1], [8, 5, 2], [9, 6, 3]]

  • Answered by AI

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Mostly Dax and sql related questions
  • Q2. ETL related questions

I applied via Campus Placement and was interviewed in Sep 2022. There were 3 interview rounds.

Round 1 - Aptitude Test 

Quantitive-train, boat ,speed and distance, profit lost ,permutation combination,
logical-blood relation ,seating arrangement ,coding and decoding,
verbal-sentence arrangement
total 20 questions-1/2 hr online test

Round 2 - Group Discussion 

Topic for Gd were on higher education vs job, ott vs theatre,social media

Round 3 - Technical 

(3 Questions)

  • Q1. Resume base, palindrome, pattern strings
  • Q2. Logical questions on chess and ludo game logic behind it
  • Q3. Pattern question ,project

Interview Preparation Tips

Interview preparation tips for other job seekers - go through resume throughly ,be confident, all the best
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I was interviewed in Mar 2022.

Interview Questionnaire 

2 Questions

  • Q1. It's more about package discussion
  • Q2. Well structured questions asked by Interviewer. 1.More into theory on Informatica Power centre how the process will go 2. SQL functions and queries related to functions.

I applied via Naukri.com and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Explain the projects you worked on
  • Q2. Give the glance of your work and your role it.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be prepared for explaining your projects clearly.
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Coding Test 

Power bi SQL

Round 3 - HR 

(4 Questions)

  • Q1. Share details of your previous job.
  • Q2. What are your salary expectations?
  • Q3. Why should we hire you?
  • Q4. Where do you see yourself in 5 years?

Interview Preparation Tips

Interview preparation tips for other job seekers - One of the best company I think.I am happy to join in Nihilent and work culture is good.

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. SQL on Joins, window functions, sub query.

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview was pretty straight forward and questions were asked mostly on basic Sql knowledge and past projects.

Clover Infotech Interview FAQs

How many rounds are there in Clover Infotech Data Analyst interview?
Clover Infotech interview process usually has 1 rounds. The most common rounds in the Clover Infotech interview process are Technical.
What are the top questions asked in Clover Infotech Data Analyst interview?

Some of the top questions asked at the Clover Infotech Data Analyst interview -

  1. What is normalisati...read more
  2. What are SQL joi...read more

Tell us how to improve this page.

Clover Infotech Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more
Join Clover Infotech Digital Solutions for the New-Age Enterprise
Clover Infotech Data Analyst Salary
based on 15 salaries
₹2.5 L/yr - ₹9 L/yr
9% less than the average Data Analyst Salary in India
View more details

Clover Infotech Data Analyst Reviews and Ratings

based on 3 reviews

4.0/5

Rating in categories

4.0

Skill development

3.1

Work-life balance

3.2

Salary

3.1

Job security

3.2

Company culture

2.3

Promotions

3.1

Work satisfaction

Explore 3 Reviews and Ratings
Software Engineer
1.2k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Senior Software Engineer
831 salaries
unlock blur

₹4.2 L/yr - ₹15.6 L/yr

Technical Support Engineer
619 salaries
unlock blur

₹2 L/yr - ₹7.5 L/yr

Application Support Engineer
558 salaries
unlock blur

₹2 L/yr - ₹8.3 L/yr

Oracle Database Administrator
481 salaries
unlock blur

₹1.8 L/yr - ₹10 L/yr

Explore more salaries
Compare Clover Infotech with

TCS

3.7
Compare

Wipro

3.7
Compare

Infosys

3.6
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview