Upload Button Icon Add office photos
Engaged Employer

i

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

Icon Resources & Technologies Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Icon Resources & Technologies BI Consultant Interview Questions and Answers

Updated 14 Aug 2024

Icon Resources & Technologies BI Consultant Interview Experiences

1 interview found

BI Consultant Interview Questions & Answers

user image Neelam Chauhan

posted on 6 Apr 2024

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

10 question from program mostly if else, loop and static variables 20 question from power bi question like which charts is used for what

Interview questions from similar companies

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Tell me about yourself
  • Ans. 

    Experienced Lead Consultant with a background in project management and client relations.

    • Over 5 years of experience in consulting roles

    • Strong project management skills, able to lead teams to successful outcomes

    • Excellent communication and relationship-building abilities

    • Proven track record of delivering results for clients

    • Certified in relevant consulting methodologies

  • Answered by AI
  • Q2. Brief me about your experience
  • Ans. 

    I have over 10 years of experience in consulting, specializing in project management and client relations.

    • 10+ years of consulting experience

    • Specialize in project management

    • Strong client relations skills

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

(1 Question)

  • Q1. Share past challenges
  • Ans. 

    Overcoming challenges in previous roles through problem-solving and perseverance.

    • Successfully managed a project with a tight deadline by prioritizing tasks and delegating responsibilities

    • Resolved conflicts within a team by facilitating open communication and finding common ground

    • Adapted to a new software system by seeking out training resources and practicing regularly

  • Answered by AI
Round 3 - Technical 

(1 Question)

  • Q1. Explain the gaps in your CV
  • Ans. 

    Career breaks for personal development and family commitments

    • Took a year off to travel and gain new perspectives

    • Took a break to care for a sick family member

    • Attended a professional development program to enhance skills

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

(1 Question)

  • Q1. Why should we hire you
  • Ans. 

    I have a proven track record of successfully leading teams and delivering results in complex consulting projects.

    • Extensive experience in consulting industry

    • Strong leadership skills demonstrated through successful project delivery

    • Ability to effectively communicate and collaborate with clients and team members

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be honest and stick to your basics.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Behavioral 

(2 Questions)

  • Q1. About your self and everything
  • Q2. E
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic aptitude and reasoning

Round 2 - Case Study 

Gusstimates, case studies and few HR ques

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

I applied via Naukri.com and was interviewed before Feb 2022. There were 3 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. Expected Ctc ,current ctc,experience etc,etc
Round 3 - Technical 

(1 Question)

  • Q1. System knowledge ,they see if your experience is usable.It’s a long round but if you are skilled and experience d enough ,it will be a breeze

Interview Preparation Tips

Interview preparation tips for other job seekers - Make sure you have good knowledge in your field and be confident in what you say. If you don’t know an answer ,show that you are willing to know or learn that .They appreciate enthusiasm towards your work

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

Round 1 - Technical 

(3 Questions)

  • Q1. Interview based on your programming language , how good you know like java or python or scala
  • Q2. Big data & Data science interview question like working of spark , Hive optimization of queries , what is graphx
  • Q3. Explain your recent project in detail
Round 2 - Technical 

(2 Questions)

  • Q1. More deep dive in your expertise technologies like Spark DAG working explain
  • Q2. How you do data validation in hive
  • Ans. 

    Data validation in Hive involves using built-in functions and custom scripts to ensure data accuracy and consistency.

    • Use built-in functions like IS NULL, IS NOT NULL, and COALESCE to check for missing or null values

    • Use regular expressions and pattern matching to validate data formats

    • Write custom scripts to perform more complex data validation tasks

    • Perform data profiling to identify potential data quality issues

    • Use data...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Salary , why changing job etc..
  • Q2. Your complete background of career

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep your resume things strong for interview tthats it.

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. About the work mostly, and some administrator relayed questions

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

Interview Questionnaire 

4 Questions

  • Q1. Core informatica. Lot of scenario based questions.
  • Q2. Very basic questions. Simple and easy.
  • Q3. Third round was very difficult. Couldn't answer one question properly. But I gave efforts
  • Q4. Get Fibonacci series in informatica
  • Ans. 

    Fibonacci series can be generated in Informatica using a recursive function.

    • Create a mapping with a recursive function

    • Use a variable port to store the previous two values

    • Use an expression transformation to generate the series

    • Example: f(0) = 0, f(1) = 1, f(n) = f(n-1) + f(n-2)

  • Answered by AI

Interview Preparation Tips

General Tips: Informatica prepare well. Sql queries too.
Skills: Communication, Body Language, Problem Solving, Analytical Skills, Presentation Skills
Duration: 1-3 Months

Skills evaluated in this interview

Icon Resources & Technologies Interview FAQs

How many rounds are there in Icon Resources & Technologies BI Consultant interview?
Icon Resources & Technologies interview process usually has 1 rounds. The most common rounds in the Icon Resources & Technologies interview process are Aptitude Test.

Tell us how to improve this page.

Icon Resources & Technologies BI Consultant Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
LTIMindtree Interview Questions
3.8
 • 3k Interviews
Mphasis Interview Questions
3.4
 • 806 Interviews
View all
Icon Resources & Technologies BI Consultant Salary
based on 12 salaries
₹2.6 L/yr - ₹7 L/yr
30% less than the average BI Consultant Salary in India
View more details

Icon Resources & Technologies BI Consultant Reviews and Ratings

based on 2 reviews

1.0/5

Rating in categories

1.0

Skill development

1.0

Work-life balance

1.0

Salary

1.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 2 Reviews and Ratings
Business Intelligence Consultant
14 salaries
unlock blur

₹4 L/yr - ₹8 L/yr

BI Consultant
12 salaries
unlock blur

₹2.7 L/yr - ₹7 L/yr

Senior Consultant
10 salaries
unlock blur

₹6.4 L/yr - ₹9 L/yr

Consultant
7 salaries
unlock blur

₹4.8 L/yr - ₹7.5 L/yr

Associate Consultant
6 salaries
unlock blur

₹3.8 L/yr - ₹5.5 L/yr

Explore more salaries
Compare Icon Resources & Technologies with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

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