Upload Button Icon Add office photos
Engaged Employer

i

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

Technumen Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 42 Reviews

Filter interviews by

Technumen Data Analyst Interview Questions and Answers for Experienced

Updated 4 May 2021

Technumen Data Analyst Interview Experiences for Experienced

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 3 May 2021

I applied via Recruitment Consultant and was interviewed in Apr 2021. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Overall experience?
  • Ans. 

    I have 5 years of experience as a Data Analyst.

    • 5 years of experience as a Data Analyst

    • Proficient in data analysis tools such as SQL, Excel, and Python

    • Experience in data visualization and reporting using Tableau

    • Strong analytical and problem-solving skills

    • Ability to interpret and communicate complex data findings

    • Experience in working with large datasets and performing data cleaning and manipulation

    • Collaborated with cross...

  • Answered by AI
  • Q2. What is a Composite Key?
  • Ans. 

    A composite key is a combination of two or more columns that uniquely identifies a record in a database table.

    • A composite key is used when a single column cannot uniquely identify a record.

    • It is created by combining two or more columns that have unique values.

    • It is commonly used in many-to-many relationships.

    • Example: A table that stores orders may use a composite key of order number and customer ID.

    • Example: A table tha...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Worst interview in my entire career, Panel was late by 5 minutes( not a big deal) and interviewed in a rush, the Interview was scheduled & supposed to be for at least 30 minutes but lasted only for 8 minutes.

I don't know what to call it a Technical/timepass interview, but it was ridiculous. Finally feedback, "not selected". Either it was not the right panel for the interview or they have someone internally they prefer to hire. Anyways it was very unprofessional to rush candidates to attend an interview and they do not interview properly, no professional ethics.

The big question to management, how do you qualify a person to conduct an interview without any relevant or proper experience but you need a person well qualified and experienced just to turn him/her down?

If I were to give the interviewer my rating it would be an astounding -2/5.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Internshala and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Done in notepad. Data analysis fundamental and coding fundamentals were covered.

Round 2 - Technical 

(2 Questions)

  • Q1. Piviot tables, vlookups excel case study.
  • Q2. Window fucntions SQL question and pandas data manupilation.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be clear with the fundamentals
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement

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 - Aptitude Test 

It was easy to approach!

Round 3 - Group Discussion 

Discussions about common topics like boon or bane to society

Round 4 - Case Study 

Asked about the scenarios

Round 5 - Technical 

(1 Question)

  • Q1. Technical round related to skills and resume
Round 6 - HR 

(1 Question)

  • Q1. Discussions regarding work culture and compensations
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(2 Questions)

  • Q1. Databricks compute and config
  • Q2. Dremio optimization process and.migration
Round 3 - One-on-one 

(1 Question)

  • Q1. Data Engineering and Data modelling
Round 4 - HR 

(1 Question)

  • Q1. People management and salary
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - HR 

(1 Question)

  • Q1. Experience, skills, current org and previous org
Interview experience
4
Good
Difficulty level
Easy
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before May 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Project history
  • Q2. Tech stack used
  • Ans. 

    Our tech stack includes Python, SQL, Apache Spark, Hadoop, AWS, and Docker.

    • Python is used for data processing and analysis

    • SQL is used for querying databases

    • Apache Spark is used for big data processing

    • Hadoop is used for distributed storage and processing

    • AWS is used for cloud infrastructure

    • Docker is used for containerization

  • Answered by AI
Round 2 - One-on-one 

(2 Questions)

  • Q1. Handled team or not?
  • Q2. Project experience

Interview Preparation Tips

Topics to prepare for Blenheim Chalcot Data Engineer interview:
  • GCP
  • Python
  • SQL
  • Data Warehousing
Interview preparation tips for other job seekers - Be very clear with your Project history and include technical jargons, so interviewer can relate and understand your experience better

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Internshala and was interviewed in May 2024. There were 2 interview rounds.

Round 1 - Coding Test 

Done in notepad. Data analysis fundamental and coding fundamentals were covered.

Round 2 - Technical 

(2 Questions)

  • Q1. Piviot tables, vlookups excel case study.
  • Q2. Window fucntions SQL question and pandas data manupilation.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be clear with the fundamentals
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. All basic concepts of pthon sql and ml
Round 2 - Coding Test 

Apptitude, tecncal, cognitiive

Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic que on sql join
  • Q2. Python quetions
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed before Feb 2023. There were 3 interview rounds.

Round 1 - Coding Test 

Online platform,
SQL coding

Round 2 - Technical 

(1 Question)

  • Q1. In a one-on-one technical round, all they will ask around your resume
Round 3 - HR 

(1 Question)

  • Q1. Basic HR question on salary and personal backgroung

Tell us how to improve this page.

People are getting interviews through

based on 1 Technumen interview
Recruitment Consultant
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Senior Consultant
50 salaries
unlock blur

₹14.1 L/yr - ₹32 L/yr

Senior Software Engineer
27 salaries
unlock blur

₹10 L/yr - ₹26.3 L/yr

Associate Consultant
22 salaries
unlock blur

₹11 L/yr - ₹26 L/yr

Consultant
21 salaries
unlock blur

₹15 L/yr - ₹31 L/yr

Software Engineer
11 salaries
unlock blur

₹6 L/yr - ₹16 L/yr

Explore more salaries
Compare Technumen with

TCS

3.7
Compare

Infosys

3.7
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview