Upload Button Icon Add office photos

Filter interviews by

Tech Firefly Data Analyst Interview Questions and Answers for Experienced

Updated 18 Jul 2023

Tech Firefly Data Analyst Interview Experiences for Experienced

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 18 Jul 2023

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

I applied via Naukri.com and was interviewed in Jun 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 - Technical 

(1 Question)

  • Q1. Asked questions related to data analytics , prepare for SQL, dash boarding, and visualization based questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Its a general discussion to check fit for the company culture and environment
Round 4 - HR 

(1 Question)

  • Q1. General salary negotiation

Interview questions from similar companies

I applied via Company Website and was interviewed in Jul 2021. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Complex sql scenarios and their results
  • Ans. 

    Complex SQL scenarios and their results

    • Using subqueries to filter data

    • Joining multiple tables with complex conditions

    • Using window functions to calculate running totals

    • Pivoting data to transform rows into columns

    • Using recursive queries to traverse hierarchical data

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Should have strong knowledge in SQL, ETL & DWH concepts

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Job Portal and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - Coding Test 

SQL Test with 5 questions

Round 2 - Technical 

(2 Questions)

  • Q1. Approach towards solving the SQL Queries from the test
  • Q2. Past Experiences
Round 3 - One-on-one 

(2 Questions)

  • Q1. Resume related Questions
  • Q2. Power BI and SQL related questions. How to approach in a dashboard building process
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Normal question about past experience
  • Q2. When you can join and all
Round 2 - Assignment 

SQL test on Select query, insert, create

Round 1 - Aptitude Test 

Math , gk, english

Round 2 - Group Discussion 

AI

Round 3 - One-on-one 

(1 Question)

  • Q1. Ai questions , java questions , coding questions
Round 4 - HR 

(1 Question)

  • Q1. Where do you see yourself in 5 years

Interview Preparation Tips

Interview preparation tips for other job seekers - none , not difficult to get into equifax
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
No response

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

Round 1 - Technical 

(1 Question)

  • Q1. 3rd largest salary from each department(window function)

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL is Imp
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via Company Website and was interviewed in May 2024. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. SQL related basic theory questions
  • Q2. SQL coding test

Interview Preparation Tips

Topics to prepare for Equifax Senior Data Analyst interview:
  • SQL

Data Engineer Interview Questions & Answers

DISYS user image Srinivasa moorthy

posted on 29 Feb 2024

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Explain process in adf
  • Ans. 

    ADF stands for Azure Data Factory, a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.

    • ADF allows you to create data-driven workflows for orchestrating and automating data movement and data transformation.

    • You can use ADF to ingest data from various sources, process and transform the data, and then publish the data to different destinations.

    • ADF supports a wide range of d...

  • Answered by AI

Skills evaluated in this interview

I applied via Naukri.com and was interviewed in Nov 2022. There were 4 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 

(1 Question)

  • Q1. Join two tables in pyspark code and dataframe
  • Ans. 

    Join two tables in PySpark code and DataFrame

    • Create two DataFrames from the tables

    • Specify the join condition using join() function

    • Select the columns to be displayed using select() function

    • Use show() function to display the result

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. What is the best place you visisted in pune
Round 4 - HR 

(1 Question)

  • Q1. How much salary you are expectin herein the saama technoligies

Interview Preparation Tips

Interview preparation tips for other job seekers - good luck,try hard ,you can get it,dont panic in between the intervie ,stay focused.

Skills evaluated in this interview

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

I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.

Round 1 - Assignment 

It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries

Round 2 - Technical 

(1 Question)

  • Q1. All SQL Concepts like Join, normalization, trigger, stored procedure, keys, drop truncate del difference, where having difference, Aggregate scaler window functions, fetch duplicate records query, acid pro...

Interview Preparation Tips

Topics to prepare for Saama Technologies Data Engineer interview:
  • SQL
  • Python
  • Pyspark
Interview preparation tips for other job seekers - Clear your concepts deeply with examples sothat you can able to explain it..

Tech Firefly Interview FAQs

How many rounds are there in Tech Firefly Data Analyst interview for experienced candidates?
Tech Firefly interview process for experienced candidates usually has 4 rounds. The most common rounds in the Tech Firefly interview process for experienced candidates are Resume Shortlist, Technical and One-on-one Round.
What are the top questions asked in Tech Firefly Data Analyst interview for experienced candidates?

Some of the top questions asked at the Tech Firefly Data Analyst interview for experienced candidates -

  1. asked questions related to data analytics , prepare for SQL, dash boarding, and...read more
  2. its a general discussion to check fit for the company culture and environm...read more

Tell us how to improve this page.

Tech Firefly Data Analyst Interview Process for Experienced

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Equifax Interview Questions
3.3
 • 32 Interviews
VDart Interview Questions
4.0
 • 29 Interviews
DISYS Interview Questions
3.0
 • 27 Interviews
CGS Interview Questions
3.5
 • 25 Interviews
Pitney Bowes Interview Questions
3.7
 • 21 Interviews
EagleView Interview Questions
3.3
 • 20 Interviews
View all
Tech Firefly Data Analyst Salary
based on 4 salaries
₹10.5 L/yr - ₹15 L/yr
95% more than the average Data Analyst Salary in India
View more details

Tech Firefly Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

3.0

Skill development

5.0

Work-life balance

5.0

Salary

3.0

Job security

5.0

Company culture

5.0

Promotions

5.0

Work satisfaction

Explore 1 Review and Rating
Content Reviewer
223 salaries
unlock blur

₹2 L/yr - ₹5 L/yr

Content Moderator
33 salaries
unlock blur

₹2.5 L/yr - ₹5.2 L/yr

Talent Acquisition Specialist
20 salaries
unlock blur

₹2 L/yr - ₹4.4 L/yr

Senior Associate
15 salaries
unlock blur

₹4 L/yr - ₹4.6 L/yr

QA Specialist
9 salaries
unlock blur

₹3.2 L/yr - ₹6 L/yr

Explore more salaries
Compare Tech Firefly with

Primus Global Technologies

3.9
Compare

Saama Technologies

3.7
Compare

DISYS

3.0
Compare

Pitney Bowes

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