Upload Button Icon Add office photos

Accenture

Compare button icon Compare button icon Compare

Filter interviews by

Accenture Business Intelligence Consultant Interview Questions, Process, and Tips

Updated 29 May 2021

Accenture Business Intelligence Consultant Interview Experiences

1 interview found

Interview Questionnaire 

5 Questions

  • Q1. Write a query to display the duplicate records without using group by.
  • Ans. 

    Query to display duplicate records without using group by

    • Use self-join to compare records

    • Select records where the values match but the primary key is different

    • Example: SELECT a.* FROM table a, table b WHERE a.value = b.value AND a.id <> b.id

  • Answered by AI
  • Q2. What is the use of ‘for XML’ command
  • Ans. 

    The 'FOR XML' command is used in SQL Server to generate XML output from a query result.

    • It allows transforming the result set of a query into XML format.

    • It can be used to generate XML documents for data exchange or integration purposes.

    • The 'FOR XML' command supports different modes like RAW, AUTO, EXPLICIT, and PATH.

    • It can be combined with other SQL Server features like joins, aggregations, and subqueries.

    • Example: SELEC

  • Answered by AI
  • Q3. What is the difference between stuff() and substring()
  • Ans. 

    stuff() replaces a specified number of characters with another string, while substring() extracts a portion of a string.

    • stuff() is used to replace a specified number of characters in a string with another string.

    • substring() is used to extract a portion of a string based on the starting and ending index.

    • stuff() can be used to mask sensitive data in a string, such as credit card numbers.

    • substring() can be used to extract...

  • Answered by AI
  • Q4. Explain the transaction property in SSIS
  • Ans. 

    Transaction property in SSIS ensures all tasks in a package are completed or rolled back as a single unit.

    • Transaction property is used to ensure data consistency in a package

    • If a task fails, all previous tasks are rolled back

    • If all tasks complete successfully, they are committed as a single unit

    • Transaction property can be set at package or container level

    • Supported isolation levels are Serializable, Repeatable Read, Rea

  • Answered by AI
  • Q5. How will you pass db connection string on runtime
  • Ans. 

    The connection string can be passed on runtime using various methods.

    • One way is to use a configuration file and read the connection string from it.

    • Another way is to pass the connection string as a parameter to the application.

    • The connection string can also be stored in a database and retrieved at runtime.

    • Using environment variables is also a common method to pass connection strings.

    • Connection strings can be encrypted a...

  • Answered by AI

Skills evaluated in this interview

Interview questions from similar companies

I applied via Naukri.com 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 - Technical 

(1 Question)

  • Q1. Introduce, explain project

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep to topic, introuce short, explain more on project

I applied via Naukri.com and was interviewed in Dec 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Question were totally based on TI plus application as I was hired for that particular application and I have put my experience thete

Interview Preparation Tips

Interview preparation tips for other job seekers - The interview process is little slow, after the interview is done we need to follow up with the hiring team multiple times and they take a lot of time to release the offer letter

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

Round 1 - One-on-one 

(1 Question)

  • Q1. Basic one to one conversation about relevant experience and overall experience.
  • Ans. Tell about your skillset, the skills technology you've worked on.
  • Answered Anonymously
Round 2 - HR 

(1 Question)

  • Q1. Salary negotiation and location change if required. Date of joining and last date in your current Organization. Any other queries.

Interview Preparation Tips

Topics to prepare for Capgemini Consultant interview:
  • Selenium
  • Java
Interview preparation tips for other job seekers - Be confident about whatever you answer throughout the interview. Don't speak too much when asked tell me about yourself, give a quick information on your skill set.

Consultant Interview Questions & Answers

Infosys user image Vandana Lekhi

posted on 29 Nov 2020

I applied via Recruitment Consultant

Interview Questionnaire 

3 Questions

  • Q1. Are you prepared for full- time work or freelance ? Can you travel ? How much salary is your expectation ?
  • Q2. I can only commit myself for freelance work with flexible hours . Cannot travel . Reasonable salary is welcome .
  • Q3. What will be the mode of payment for my freelance work ?

Interview Preparation Tips

Interview preparation tips for other job seekers - In any interview honesty is essential while the employer conducts it . One's limitations should be disclosed along with expectations . For example my service to street dogs , cats , birds and squirrels in the colony does not permit me to engage in full-time work . Getting a good work place is more important than aiming for a high salary .

I applied via Naukri.com and was interviewed before Aug 2021. There were 2 interview rounds.

Round 1 - Coding Test 

Standard Coding questing

Round 2 - Technical 

(1 Question)

  • Q1. Core java, java 8 features, collections, Exception handling

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare for Datastructures and Algorithms .

I applied via Referral and was interviewed in Jan 2021. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Basics of Middleware
  • Q2. Everything you are doing as a routine and your tasks tell them and with confidence

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and never loose hope

I applied via Naukri.com and was interviewed in Mar 2021. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Manual testing related questions asked

Interview Preparation Tips

Interview preparation tips for other job seekers - Technical skill should required

Interview Questionnaire 

1 Question

  • Q1. What are the Challenges that you face while migrating reports from one environment to another.
  • Ans. 

    Challenges faced while migrating reports from one environment to another

    • Compatibility issues between the old and new environments

    • Data source connections may need to be updated

    • Formatting and layout may need to be adjusted

    • Security settings may need to be reconfigured

    • Testing and validation of migrated reports is crucial

    • User training may be required for any changes in functionality

  • Answered by AI

Skills evaluated in this interview

Interview Questionnaire 

1 Question

  • Q1. About Sitecore

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident in whatever you tell and openly admit if you don't know

Accenture Interview FAQs

What are the top questions asked in Accenture Business Intelligence Consultant interview?

Some of the top questions asked at the Accenture Business Intelligence Consultant interview -

  1. Write a query to display the duplicate records without using group ...read more
  2. What is the difference between stuff() and substrin...read more
  3. What is the use of ‘for XML’ comm...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.6k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
DXC Technology Interview Questions
3.7
 • 802 Interviews
View all
Accenture Business Intelligence Consultant Salary
based on 20 salaries
₹6.1 L/yr - ₹30.1 L/yr
74% more than the average Business Intelligence Consultant Salary in India
View more details

Accenture Business Intelligence Consultant Reviews and Ratings

based on 1 review

5.0/5

Rating in categories

5.0

Skill development

5.0

Work-life balance

2.0

Salary

2.0

Job security

5.0

Company culture

2.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Application Development Analyst
39k salaries
unlock blur

₹3 L/yr - ₹12 L/yr

Application Development - Senior Analyst
27.4k salaries
unlock blur

₹6.9 L/yr - ₹20.2 L/yr

Team Lead
24.7k salaries
unlock blur

₹7.1 L/yr - ₹25.5 L/yr

Senior Software Engineer
18.2k salaries
unlock blur

₹6 L/yr - ₹20 L/yr

Senior Analyst
17.8k salaries
unlock blur

₹5.5 L/yr - ₹21.3 L/yr

Explore more salaries
Compare Accenture with

TCS

3.7
Compare

Cognizant

3.7
Compare

Capgemini

3.7
Compare

Infosys

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