Upload Button Icon Add office photos
Engaged Employer

i

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

Z1 Tech Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Z1 Tech Data Analyst Interview Questions and Answers

Updated 31 May 2024

Z1 Tech Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 31 May 2024

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

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

Round 1 - Technical 

(2 Questions)

  • Q1. Questions on vlook up, h-look up, pivot and if else condition
  • Q2. You must know how to use vlook up, h-look up and if-else condition
Round 2 - Assignment 

Excel file was give, used sumifs, countifs , index match formulas

Interview Preparation Tips

Interview preparation tips for other job seekers - Just learn the excel famous questions and concept like look up, index match, nested if, concate function etc

Interview questions from similar companies

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

I applied via LinkedIn and was interviewed before Aug 2023. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Difference between union and union all in SQL?
  • Ans. 

    Union combines and removes duplicates, Union All combines without removing duplicates.

    • Union combines result sets and removes duplicates

    • Union All combines result sets without removing duplicates

    • Union is slower than Union All as it involves removing duplicates

    • Example: SELECT column1 FROM table1 UNION SELECT column1 FROM table2;

    • Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;

  • Answered by AI
  • Q2. How to show top 5 in pandas?
  • Ans. 

    To show top 5 in pandas, use the nlargest() function.

    • Use the nlargest() function with the 'n' parameter set to 5 to get the top 5 values in a pandas DataFrame.

    • For example: df['column_name'].nlargest(5) will return the top 5 values in the specified column.

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. If we have 3 numerical columns, which chart is a better representation these column?
  • Ans. 

    A scatter plot is a better representation for 3 numerical columns.

    • Use a scatter plot to show the relationship between the numerical columns.

    • Scatter plots are effective for visualizing correlations and patterns in data.

    • Each point on the plot represents a data point with values from all 3 columns.

  • Answered by AI

Interview Preparation Tips

Topics to prepare for Omnicom Media Group Data Analyst interview:
  • SQL Server
  • Pandas
  • Power Bi

Skills evaluated in this interview

I applied via Campus Placement and was interviewed in May 2022. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic general English language

Round 2 - Group Discussion 

Basic question

Interview Preparation Tips

Interview preparation tips for other job seekers - I have good job and good salary experience
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview before Mar 2024.

Round 1 - Technical 

(2 Questions)

  • Q1. About datorama explain how it works
  • Q2. More about digital marketing

I applied via Referral and was interviewed in Nov 2021. There was 1 interview round.

Interview Questionnaire 

4 Questions

  • Q1. Difference between coalesce and repartition
  • Ans. 

    Coalesce is used to select the first non-null value from a set of columns. Repartition is used to shuffle data across nodes.

    • Coalesce reduces the number of partitions to the minimum required.

    • Repartition increases or decreases the number of partitions.

    • Coalesce is a narrow transformation while repartition is a wide transformation.

    • Coalesce is used to optimize data for queries while repartition is used to balance data acros...

  • Answered by AI
  • Q2. How to optimise joins
  • Ans. 

    Optimizing joins involves selecting appropriate join types, indexing tables, and minimizing data movement.

    • Choose the appropriate join type based on the size and structure of the tables being joined

    • Index the tables on the join columns to speed up the join process

    • Minimize data movement by selecting only the necessary columns and filtering rows before joining

    • Consider using denormalization or materialized views to precompu

  • Answered by AI
  • Q3. Spark optimizations
  • Q4. Difference between RDD dataset and dataframe
  • Ans. 

    RDD is a low-level distributed data structure while DataFrame is a high-level structured data abstraction.

    • RDD is immutable and unstructured while DataFrame is structured and has a schema

    • DataFrames are optimized for SQL queries and can be cached in memory

    • RDDs are more flexible and can be used for complex data processing tasks

    • DataFrames are easier to use and provide a more concise syntax for data manipulation

    • RDDs are the...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - The major focus was on Apache Spark.

Skills evaluated in this interview

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

I applied via LinkedIn and was interviewed before Oct 2022. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Be honest with your years of experience. All information you share will be verified at the time of joining.
View all tips
Round 2 - Coding Test 

Basic dsa question in python and data engineering questions ,sql

Round 3 - Coding Test 

Basic dsa question in python and data engineering questions

Round 4 - HR 

(1 Question)

  • Q1. Salary negotiation
Interview experience
1
Bad
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Jul 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL Window Functions and RANK, DENSE RANK Difference
  • Ans. 

    SQL Window Functions like RANK and DENSE RANK are used to assign a rank to rows within a partition.

    • RANK function assigns a unique rank to each distinct row within a partition.

    • DENSE RANK function assigns a unique rank to each distinct row within a partition, but without any gaps.

    • Both functions are used with the OVER() clause in SQL to define the partition and order of rows.

  • Answered by AI
  • Q2. Hadoop Default Replication Factor

Interview Preparation Tips

Topics to prepare for Vertoz Data Engineer interview:
  • SQL
  • Spark
  • Hadoop
  • YARN
Interview preparation tips for other job seekers - Easy questions asked related to SQL Window Functions, Spark Repartition and Coalesce, Spark Architecture, YARN, Hadoop Replication Factor, Spark Write Modes and many such easy questions.

Salary offered is below industry standard.
Overall not a good experience.

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before Sep 2019. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. What you would do if you have someone in your team who is unable to communicate ?

Interview Preparation Tips

Interview preparation tips for other job seekers - It is always in advantage of yours when you are well-aware of company, it's history, operations, office locations, everything that you need to know. So, that if at all they ask a question which you are either not aware or are not prepared, you can think of the best answer. So, I would advice to do an extensive research on the company, the operations, the position you would be interviewing for and the importance and role of that position.
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via AmbitionBox and was interviewed in Jan 2024. There were 3 interview rounds.

Round 1 - Aptitude Test 

It is the starting round in every companys

Round 2 - Technical 

(1 Question)

  • Q1. Ask me anything
Round 3 - HR 

(1 Question)

  • Q1. Ask me anything

Interview Preparation Tips

Topics to prepare for Coalition Technologies Front end Developer interview:
  • HTML
  • CSS
  • Javascript
  • Servlets
  • JDBC
  • MySQL
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Feb 2023. There were 4 interview rounds.

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

Nimber series arithmetic aptitude

Round 3 - HR 

(4 Questions)

  • Q1. Why you lokking for a new role
  • Q2. Ask me about webtechnologies
  • Q3. Tell me about yousrself
  • Q4. Ask me about my course
Round 4 - Assignment 

Calculator assignment on webtechnologies

Interview Preparation Tips

Interview preparation tips for other job seekers - Good communication skills and technical skills diciplain, self motivation,self confidence, willing to relocate

Z1 Tech Interview FAQs

How many rounds are there in Z1 Tech Data Analyst interview?
Z1 Tech interview process usually has 2 rounds. The most common rounds in the Z1 Tech interview process are Technical and Assignment.
How to prepare for Z1 Tech Data Analyst interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at Z1 Tech. The most common topics and skills that interviewers at Z1 Tech expect are Analytical Chemistry, Automation Testing, CRM, Data Analysis and Digital Marketing.
What are the top questions asked in Z1 Tech Data Analyst interview?

Some of the top questions asked at the Z1 Tech Data Analyst interview -

  1. you must know how to use vlook up, h-look up and if-else condit...read more
  2. Questions on vlook up, h-look up, pivot and if else condit...read more

Tell us how to improve this page.

Z1 Tech Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
Z1 Tech Data Analyst Salary
based on 7 salaries
₹3.6 L/yr - ₹6 L/yr
25% less than the average Data Analyst Salary in India
View more details

Z1 Tech Data Analyst Reviews and Ratings

based on 4 reviews

4.8/5

Rating in categories

4.8

Skill development

5.0

Work-life balance

4.8

Salary

4.6

Job security

5.0

Company culture

4.8

Promotions

5.0

Work satisfaction

Explore 4 Reviews and Ratings
Front end Developer
15 salaries
unlock blur

₹2.4 L/yr - ₹8 L/yr

Senior Associate
10 salaries
unlock blur

₹5.8 L/yr - ₹10 L/yr

Data Analyst
7 salaries
unlock blur

₹3.6 L/yr - ₹6 L/yr

Junior Software Developer
6 salaries
unlock blur

₹4 L/yr - ₹5 L/yr

Associate Director
5 salaries
unlock blur

₹18.5 L/yr - ₹20 L/yr

Explore more salaries
Compare Z1 Tech with

Franchise India Brands

2.1
Compare

Omnicom Media Group

2.9
Compare

7Search PPC

4.8
Compare

Moris Media

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