AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Tech Firefly Data Analyst Interview Questions and Answers
Tech Firefly Data Analyst Interview Experiences
1 interview found
Anonymous
Selected
I applied via Naukri.com and was interviewed in Jun 2023. There were 4 interview rounds.
(1 Question)
- Q1. Asked questions related to data analytics , prepare for SQL, dash boarding, and visualization based questions
(1 Question)
- Q1. Its a general discussion to check fit for the company culture and environment
(1 Question)
- Q1. General salary negotiation
Interview questions from similar companies
Selected
I applied via Job Portal and was interviewed before Dec 2023. There were 3 interview rounds.
SQL Test with 5 questions
(2 Questions)
- Q1. Approach towards solving the SQL Queries from the test
- Q2. Past Experiences
(2 Questions)
- Q1. Resume related Questions
- Q2. Power BI and SQL related questions. How to approach in a dashboard building process
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
Interview Preparation Tips
Skills evaluated in this interview
Math , gk, english
AI
(1 Question)
- Q1. Ai questions , java questions , coding questions
(1 Question)
- Q1. Where do you see yourself in 5 years
Interview Preparation Tips
Sweety Wadhwa
(2 Questions)
- Q1. Normal question about past experience
- Q2. When you can join and all
SQL test on Select query, insert, create
Selected
I applied via Referral and was interviewed before Feb 2022. There were 3 interview rounds.
2 hr duration test it was. It had the topics like reasoning, number system. Technical section was also there which has sql questions
(11 Questions)
- Q1. Based on my final year project. Some questions based the programming language I added in my resume and other questions asked on sql queries on joins, union, union all difference.
- Q2. Then HR round was there in which asked some behavioral questions and tested some decision making skills
- Q3. Tell me about your final year project is a common question that every interviewer ask for fresher
- Q4. What is inheritance and type of inheritance? if you mentioned c or Java as your skill
- Q5. Tell me about yourself?
- Q6. What are your hobbies?
- Q7. What is your salary expectation.
- Q8. Are you willing to relocate?
- Q9. Are you ready to sign agreement if there is any?
- Q10. Tell me about your family background
- Q11. Is there any for future studies
Interview Preparation Tips
Do not read or practice before 10 mins of your interview.
Practice and research all the possible questions and scenarios before going to an interview
(1 Question)
- Q1. Related to data warehouse
(1 Question)
- Q1. Python, data warehouse, data modelling
(1 Question)
- Q1. Questions about the tech skills you have
(1 Question)
- Q1. Salary discussion .
Interview Preparation Tips
I applied via Naukri.com and was interviewed in Nov 2022. There were 4 interview rounds.
(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
(1 Question)
- Q1. What is the best place you visisted in pune
(1 Question)
- Q1. How much salary you are expectin herein the saama technoligies
Interview Preparation Tips
Skills evaluated in this interview
Data Engineer Interview Questions & Answers
Saama Technologies
Gautamee Jakinkar
posted on 29 May 2024
I applied via Campus Placement and was interviewed in Apr 2024. There were 2 interview rounds.
It was a written test where theoretical SQL questions were asked like primary key, foreign key, set operators and some queries
(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
- SQL
- Python
- Pyspark
Tech Firefly Interview FAQs
Tell us how to improve this page.
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
Tech Firefly Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Tech Firefly Data Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Content Reviewer
215
salaries
|  ₹1.8 L/yr - ₹5 L/yr |
|
Content Moderator
33
salaries
| ₹2.5 L/yr - ₹5.2 L/yr |
|
Talent Acquisition Specialist
20
salaries
| ₹2 L/yr - ₹4.4 L/yr |
|
Senior Associate
15
salaries
| ₹4 L/yr - ₹4.6 L/yr |
|
QA Specialist
9
salaries
| ₹3.2 L/yr - ₹6 L/yr |
Primus Global Technologies
Saama Technologies
DISYS
Pitney Bowes
- Home >
- Interviews >
- Tech Firefly Interview Questions >
- Tech Firefly Data Analyst Interview Questions
