Upload Button Icon Add office photos
Premium Employer

i

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

Gen Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Gen Business Intelligence Analyst Interview Questions and Answers

Updated 11 Jul 2024

Gen Business Intelligence Analyst Interview Experiences

1 interview found

Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed before Jul 2023. There were 2 interview rounds.

Round 1 - Coding Test 

Databases mcq,coding test in any language and SQL and etl questions

Round 2 - HR 

(1 Question)

  • Q1. How do you handle conflicts inside the team?

Interview Preparation Tips

Topics to prepare for Gen Business Intelligence Analyst interview:
  • python
  • sql
  • informatica
  • Azure
  • databricks
Interview preparation tips for other job seekers - It's easy,but the company is not stable.layoff happens frequently

Interview questions from similar companies

I applied via Company Website and was interviewed before Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Scrum
  • Q2. Agile

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be yourself

Data Analyst Interview Questions & Answers

McAfee user image Sidharth Kriplani

posted on 13 Aug 2023

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

I applied via Referral and was interviewed before Aug 2022. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Properly align and format text in your resume. A recruiter will have to spend more time reading poorly aligned text, leading to high chances of rejection.
View all tips
Round 2 - Technical 

(4 Questions)

  • Q1. I was provided with three tables: 1st table had city wise sales, 2nd table had province_id and name, 3rd table had city_id, city_name, and province_id 1. Get the highest sales value, city, province. Do th...
  • Q2. Can aggregate functions be used with HAVING clause? With WHERE clause? What is the difference between WHERE and HAVING clause? Can HAVING be used without GROUP BY?
  • Ans. 

    Yes, aggregate functions can be used with HAVING and WHERE clauses. WHERE filters rows before grouping, HAVING filters groups after grouping.

    • Aggregate functions can be used with HAVING clause to filter groups based on the result of the aggregate function.

    • Aggregate functions can also be used with WHERE clause to filter rows before grouping.

    • WHERE clause filters rows before grouping, while HAVING clause filters groups aft...

  • Answered by AI
  • Q3. What is the order of execution of a SQL Query?
  • Ans. 

    The order of execution of a SQL query is: FROM, WHERE, GROUP BY, HAVING, SELECT, ORDER BY.

    • FROM: Specifies the tables involved in the query

    • WHERE: Filters the rows based on specified conditions

    • GROUP BY: Groups the rows that have the same values into summary rows

    • HAVING: Filters the groups based on specified conditions

    • SELECT: Selects the columns to be displayed in the result set

    • ORDER BY: Sorts the result set based on speci

  • Answered by AI
  • Q4. What are User Defined Functions? Stored Procedures? Triggers?
  • Ans. 

    User Defined Functions, Stored Procedures, and Triggers are database objects used to perform specific tasks in database management systems.

    • User Defined Functions are custom functions created by users to perform specific calculations or operations in a database.

    • Stored Procedures are precompiled SQL statements that can be executed by calling the procedure name.

    • Triggers are special types of stored procedures that are auto...

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

(1 Question)

  • Q1. This was a managerial round

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare for SQL the most

Skills evaluated in this interview

Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Clear and general to the point questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. Basic why you are leaving your previous job
  • Q2. What are you looking for
Round 3 - HR 

(2 Questions)

  • Q1. Salary expectation
  • Q2. Basic about your background details earlier experience
Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - One-on-one 

(5 Questions)

  • Q1. What are scrum ceremonies?
  • Ans. 

    Scrum ceremonies are regular meetings held in Agile project management to facilitate communication and collaboration among team members.

    • Sprint Planning: Setting goals and planning tasks for the upcoming sprint.

    • Daily Stand-up: Short daily meetings to discuss progress, roadblocks, and plans for the day.

    • Sprint Review: Demo of completed work to stakeholders for feedback.

    • Sprint Retrospective: Reflection on what went well, w...

  • Answered by AI
  • Q2. How do you define sprint?
  • Ans. 

    A sprint is a time-boxed period during which a specific amount of work must be completed.

    • Sprints are typically 2-4 weeks long in Agile methodology

    • At the beginning of a sprint, the team plans the work to be done and commits to completing it by the end of the sprint

    • Sprints end with a review and retrospective to discuss what went well and what could be improved for the next sprint

  • Answered by AI
  • Q3. How do you make story points?
  • Ans. 

    Story points are estimates used in Agile methodology to measure the complexity and effort required for a task.

    • Story points are typically assigned based on the perceived complexity, risk, and effort involved in a user story or task.

    • They are not based on time, but rather on relative sizing compared to other tasks.

    • Common scales for story points include Fibonacci sequence (1, 2, 3, 5, 8, 13, etc.) or t-shirt sizes (XS, S, ...

  • Answered by AI
  • Q4. Scenario-based questions on stakeholder manager
  • Q5. How is product management different from project management?
  • Ans. 

    Product management focuses on the development and marketing of a specific product, while project management involves overseeing a specific project from start to finish.

    • Product management is focused on the entire lifecycle of a product, from ideation to launch and beyond.

    • Project management is focused on the successful completion of a specific project within a set timeframe and budget.

    • Product managers work closely with c...

  • Answered by AI

Skills evaluated in this interview

I applied via LinkedIn and was interviewed in Mar 2022. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Questions on basic to advanced SQL, Advanced Excel, Power BI. 1) Difference between UNION and UNION ALL 2) Difference between COUNT and COUNTA 3) Scenario based SQL query questions on windows functions (ra...

Interview Preparation Tips

Interview preparation tips for other job seekers - SQL questions will not be so easy, at the same time not so tough. Critical thinking will play vital role.
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Sep 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 - HR 

(1 Question)

  • Q1. Introduction , why did you left and why wants to join
Round 3 - Aptitude Test 

Online test (objective)

Round 4 - One-on-one 

(1 Question)

  • Q1. This is an ops around with the manager and they will ask abt your process knowledge.

Interview Preparation Tips

Interview preparation tips for other job seekers - Dont join as they dont have projects they will ask you to leave after few months.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I was interviewed before Jan 2024.

Round 1 - Technical 

(1 Question)

  • Q1. Database related Query proformance and DBA related questions.
Round 2 - One-on-one 

(1 Question)

  • Q1. Python, pandas and Power BI
Round 3 - HR 

(1 Question)

  • Q1. Salary discussion

Interview Preparation Tips

Interview preparation tips for other job seekers - Strong your base concepts and focus on trending Skill.
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
4-6 weeks
Result
No response

I applied via Indeed and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. How to you manage team conflicts
  • Ans. 

    I address team conflicts by promoting open communication, active listening, and facilitating constructive discussions.

    • Encourage open communication among team members to address conflicts early on

    • Practice active listening to understand all perspectives and concerns

    • Facilitate constructive discussions to find mutually beneficial solutions

    • Implement team-building activities to improve relationships and prevent conflicts

    • Seek...

  • Answered by AI
  • Q2. How many members in your team
  • Ans. 

    There are 7 members in my team.

    • Our team consists of 3 business analysts, 2 data analysts, and 2 project managers.

    • Each member has a specific role and responsibilities within the team.

    • We work collaboratively to analyze business requirements and provide data-driven insights.

  • Answered by AI
Round 2 - Behavioral 

(2 Questions)

  • Q1. Elevator pitch case study
  • Q2. Are you willing to move to hyderabad
  • Ans. 

    Yes, I am willing to relocate to Hyderabad for the right opportunity.

    • I am open to relocating for the right job opportunity

    • I have researched about Hyderabad and am comfortable with the idea of living there

    • I am excited about the prospect of working in a new city

  • Answered by AI
Interview experience
5
Excellent
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 

Multiple choice questions

Round 2 - One-on-one 

(2 Questions)

  • Q1. OOPS concepts and SQL knowledge
  • Q2. Managerial Round with Behavioral questions

Gen Interview FAQs

How many rounds are there in Gen Business Intelligence Analyst interview?
Gen interview process usually has 2 rounds. The most common rounds in the Gen interview process are Coding Test and HR.
How to prepare for Gen Business Intelligence 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 Gen. The most common topics and skills that interviewers at Gen expect are Analytical, Analytics, Coding, Data Analysis and GCP.

Tell us how to improve this page.

Gen Business Intelligence Analyst Interview Process

based on 1 interview

Interview experience

1
  
Bad
View more

Interview Questions from Similar Companies

Globant Interview Questions
3.8
 • 172 Interviews
Chetu Interview Questions
3.3
 • 172 Interviews
Oracle Cerner Interview Questions
3.7
 • 157 Interviews
AVASOFT Interview Questions
3.6
 • 146 Interviews
ServiceNow Interview Questions
4.1
 • 120 Interviews
Thomson Reuters Interview Questions
4.1
 • 112 Interviews
Amadeus Interview Questions
3.9
 • 107 Interviews
SPRINKLR Interview Questions
3.1
 • 100 Interviews
UKG Interview Questions
3.1
 • 99 Interviews
View all
Senior Software Engineer
92 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Software Engineer
75 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Sales Operations Analyst
58 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Principal Software Engineer
37 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

SQA Engineer
28 salaries
unlock blur

₹0 L/yr - ₹0 L/yr

Explore more salaries
Compare Gen with

McAfee

4.0
Compare

Kaspersky Lab

2.2
Compare

QUICK HEAL TECHNOLOGIES

3.7
Compare

Seqrite

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