Upload Button Icon Add office photos

ACT Fibernet

Compare button icon Compare button icon Compare

Filter interviews by

ACT Fibernet Data Analyst Interview Questions and Answers

Updated 1 Apr 2024

ACT Fibernet Data Analyst Interview Experiences

2 interviews found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 1 Apr 2024

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

(1 Question)

  • Q1. Previous experience

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 6 Aug 2021

Interview Questionnaire 

1 Question

  • Q1. Overall Experience and technical round managerial round

Data Analyst Interview Questions Asked at Other Companies

asked in Deloitte
Q1. Suppose there is a room in the office and X people enter room thr ... read more
asked in Wipro
Q2. Chocolate Distribution Problem You are given an array/list CHOCOL ... read more
asked in Wipro
Q3. Ninja and Substrings Problem Statement Ninja has to determine all ... read more
asked in Capgemini
Q4. Ninja and His Secret Information Encoding Problem Ninja, a new me ... read more
Q5. Sliding Window Maximum Problem Statement You are given an array/l ... read more

Interview questions from similar companies

I applied via Recruitment Consulltant and was interviewed before Jul 2021. There were 2 interview rounds.

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 - One-on-one 

(3 Questions)

  • Q1. SQL joins and simple query
  • Q2. Phython basics and simle data fram
  • Q3. Hr round only formality

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Confident and work on basics, do not take lot of tension
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Questions were based on DSA and C
  • Q2. It was basically a coding round with simple logic
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via AmbitionBox and was interviewed in Nov 2022. There were 2 interview rounds.

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 - Technical 

(2 Questions)

  • Q1. Qualification of my degree
  • Q2. My personal skills for company

Interview Preparation Tips

Interview preparation tips for other job seekers - Market yourself .Use informational interview to network .Know yourself and what you want.
Interview experience
4
Good
Difficulty level
Hard
Process Duration
2-4 weeks
Result
Selected Selected

I appeared for an interview in Jan 2025.

Round 1 - Technical 

(5 Questions)

  • Q1. Could you elaborate on your roles and responsibilities in your previous employment?
  • Ans. 

    In my previous role, I was responsible for analyzing data, creating reports, and providing insights to support decision-making.

    • Performed data cleaning, transformation, and analysis using tools like Excel, SQL, and Python.

    • Generated reports and dashboards to visualize data trends and patterns.

    • Collaborated with cross-functional teams to identify key metrics and KPIs for business performance.

    • Presented findings and recommen...

  • Answered by AI
  • Q2. What was your role in the project, specifically related to data transformation and dashboard creation?
  • Ans. 

    I was responsible for data cleaning, transformation, and visualization to create interactive dashboards for stakeholders.

    • Performed data cleaning and transformation to ensure accuracy and consistency of data

    • Utilized tools like SQL, Python, and Tableau to manipulate and visualize data

    • Collaborated with stakeholders to understand their requirements and design interactive dashboards

    • Generated insights from data analysis to d

  • Answered by AI
  • Q3. How do you optimize and manage large datasets, and what data sources do you utilize to obtain this data?
  • Ans. 

    I optimize and manage large datasets by using tools like SQL, Python, and Excel. I utilize various data sources such as databases, APIs, and web scraping.

    • Utilize SQL queries to efficiently extract and manipulate data from databases

    • Use Python for data cleaning, analysis, and visualization tasks

    • Leverage Excel for organizing and summarizing data in a user-friendly format

    • Obtain data from sources like internal databases, ex

  • Answered by AI
  • Q4. Guesstimates like how many traffic signals are there in Noida.
  • Ans. 

    There are approximately 500-600 traffic signals in Noida.

    • Estimate based on the size and population of Noida

    • Consider the number of major intersections and roads in the city

    • Take into account the traffic density and need for traffic management

    • Consult local traffic authorities for more accurate data

  • Answered by AI
  • Q5. The interviewer asked SQL questions related to window functions, joins, and advanced aggregations, such as running sum and rolling sum.
Round 2 - Technical 

(1 Question)

  • Q1. Second round is also a technical round and similar to first round . Medium to high level sql questions and questions related to the project you're working on and Guesstimates will be asked by the interview...
Round 3 - Technical 

(1 Question)

  • Q1. Project manager will take the third round interview and inquire about your knowledge of the company, and some technical and scenario-based questions related to decision-making and problem-solving approach.
Round 4 - HR 

(1 Question)

  • Q1. Final round will be an HR round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare to cover SQL from basic to advanced levels, as well as explore concepts related to Tableau and Power BI.
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Difference between joins
  • Ans. 

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

    • Inner Join: Returns rows when there is a match in both tables.

    • Left Join: Returns all rows from the left table and the matched rows from the right table.

    • Right Join: Returns all rows from the right table and the matched rows from the left table.

    • Full Outer Join: Returns rows when there is a match in one of the tables.

    • Cross Join:

  • Answered by AI
  • Q2. Window function
Round 2 - Technical 

(1 Question)

  • Q1. Write sql query in pythons
  • Ans. 

    Writing SQL queries in Python allows for seamless integration of data analysis and manipulation.

    • Use libraries like pandas or sqlalchemy to execute SQL queries in Python

    • Remember to establish a connection to the database before executing queries

    • Utilize Python's flexibility to manipulate and analyze data retrieved from SQL queries

  • 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 Campus Placement and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Easy Aptitude and SQL questions

Round 2 - Technical 

(2 Questions)

  • Q1. Guesstimate question
  • Q2. SQL Joins and DSA
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Behavioral interview 

(2 Questions)

  • Q1. It was an easy situational ques
  • Q2. It was an easy situational questiokn
Round 2 - Behavioral interview 

(2 Questions)

  • Q1. Same as the first one
  • Q2. Same as the previous round
Round 1 - Technical 

(1 Question)

  • Q1. Current roles and responsibilities, Few queries to write, few questions related to DWH and what type of role you have done in past etc
Round 2 - Technical 

(1 Question)

  • Q1. Managerial round mostly questions like what challenges did you face, how did you overcome on that, what was the major success / appreciation you got

Interview Preparation Tips

Interview preparation tips for other job seekers - If you don't know anything, show that you can learn and do it

ACT Fibernet Interview FAQs

How many rounds are there in ACT Fibernet Data Analyst interview?
ACT Fibernet interview process usually has 1 rounds. The most common rounds in the ACT Fibernet interview process are One-on-one Round.

Tell us how to improve this page.

ACT Fibernet Data Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
ACT Fibernet Data Analyst Salary
based on 11 salaries
₹4 L/yr - ₹6.5 L/yr
24% less than the average Data Analyst Salary in India
View more details

ACT Fibernet Data Analyst Reviews and Ratings

based on 6 reviews

4.2/5

Rating in categories

3.2

Skill development

4.1

Work-life balance

2.4

Salary

4.1

Job security

4.1

Company culture

2.9

Promotions

3.5

Work satisfaction

Explore 6 Reviews and Ratings
Network Engineer
1.2k salaries
unlock blur

₹1.2 L/yr - ₹5.5 L/yr

Senior Network Engineer
574 salaries
unlock blur

₹2.1 L/yr - ₹6 L/yr

Team Lead
340 salaries
unlock blur

₹3.3 L/yr - ₹8.5 L/yr

Senior Executive
256 salaries
unlock blur

₹1.9 L/yr - ₹6 L/yr

Sales Executive
207 salaries
unlock blur

₹1.8 L/yr - ₹4.7 L/yr

Explore more salaries
Compare ACT Fibernet with

Vodafone Idea

4.0
Compare

Bharti Airtel

4.0
Compare

Ericsson

4.1
Compare

Tata Communications

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