Upload Button Icon Add office photos
Engaged Employer

i

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

Confidential Company Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Confidential Company Senior Analyst Interview Questions and Answers

Updated 18 Nov 2021

Confidential Company Senior Analyst Interview Experiences

2 interviews found

I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. For freshers who are about to become non-freshers - for your next job - once you've passed all interviews/tests in the process and now in the 'Job Offer' phase of the application...

Interview Preparation Tips

Interview preparation tips for other job seekers - Never accept the first offer - as you can safely assume that it's the lowest they can offer in the salary bracket. (because they'll also assume that you're most likely to negotiate - so negotiate!) However, before the job offer takes place, be sure to do your research on how much companies usually pay for your role. You'll see in these websites (e.g. AmbitionBox) that a job has a 'lower' and 'upper' salary limit - try to always go for the upper limit and make sure to back it up with valid reasons (for example: experience, tenure, certifications, etc.) If the employer pushes back and comes up with their own justifications, that's another story - I leave to you how you'll manage! In some special cases - if you're being headhunted for the role, also take advantage of that leverage in the negotiation process. This will really work your negotiations skills - so all the best to you!

I applied via Recruitment Consultant and was interviewed before Nov 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. For freshers who are about to become non-freshers - for your next job - once you've passed all interviews and you're now in the 'Job Offer' phase of the application...

Interview Preparation Tips

Interview preparation tips for other job seekers - Never accept the first offer - you can safely assume that it's the lowest they can offer in the salary bracket because they'll also assume that you're most likely to negotiate - so negotiate! However, before the job offer takes place, be sure to do your research on how much companies pay for your role. You'll see in these websites (e.g. AmbitionBox) that a job has a 'lower' and 'upper' salary limit - try to always go for the upper limit and make sure to back it up with valid reasons (for example: experience, tenure, certifications, etc.) If the employer pushes back and comes up with their own justifications, that's another story - I leave to you how you'll manage! This will really work your negotiation skills - best of luck!

Senior Analyst Interview Questions Asked at Other Companies

Q1. Explain 3 statement financial model Calculating discount rate Cou ... read more
Q2. Tell me about your profile? What do you know about Transaction Mo ... read more
asked in Accenture
Q3. What do you understand by Budgeting and Forecasting?
Q4. Q4. What is the probability of getting 5 Sundays in 31 day month.
Q5. Q4. You are standing in a field. Chances of seeing atleast 1 plan ... read more

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Apr 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

It contains Aptitude, reasoning and Essay Writing.

Round 2 - Coding Test 

It contains pseudo code.

Round 3 - Technical 

(2 Questions)

  • Q1. They will pose questions based on our resume. Whatever the point we kept in the resume, we make sure that we have to know the full knowledge on that.
  • Q2. They asked me about my project and pose questions related C, Java
Round 4 - HR 

(5 Questions)

  • Q1. What is your family background?
  • Q2. Why should we hire you?
  • Q3. Where do you see yourself in 5 years?
  • Q4. What are your strengths and weaknesses?
  • Q5. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Explain your view properly. Good Communication is required.

I applied via Campus Placement and was interviewed before Apr 2021. There were 4 interview rounds.

Round 1 - Aptitude Test 

It contains Aptitude, reasoning and Essay Writing.

Round 2 - Coding Test 

It contains pseudo code.

Round 3 - Technical 

(2 Questions)

  • Q1. They will pose questions based on our resume. Whatever the point we kept in the resume, we make sure that we have to know the full knowledge on that.
  • Q2. They asked me about my project and pose questions related C, Java
Round 4 - HR 

(5 Questions)

  • Q1. What is your family background?
  • Q2. Why should we hire you?
  • Q3. Where do you see yourself in 5 years?
  • Q4. What are your strengths and weaknesses?
  • Q5. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Explain your view properly. Good Communication is required.

I was interviewed before Mar 2021.

Round 1 - Coding Test 

There will be one round of coding

Round 2 - Technical 

(1 Question)

  • Q1. Technical round will be face to face

Interview Preparation Tips

Interview preparation tips for other job seekers - Better to prepare basics of DSA and other coding principles. For database side interview there will be SQL test which will be very tricky

I applied via Campus Placement and was interviewed before Jul 2020. There were 3 interview rounds.

Interview Questionnaire 

4 Questions

  • Q1. COUNT in SQL
  • Ans. 

    COUNT is a SQL function used to count the number of rows in a table or a result set.

    • COUNT can be used with the SELECT statement to count the number of rows that match a certain condition

    • COUNT(*) counts all rows in a table

    • COUNT(column_name) counts the number of non-null values in a specific column

  • Answered by AI
  • Q2. Algorithms ans Pseudo Code
  • Q3. Grouping in SQL
  • Ans. 

    Grouping in SQL is used to group data based on one or more columns.

    • GROUP BY clause is used to group data in SQL

    • Aggregate functions like SUM, COUNT, AVG can be used with GROUP BY

    • GROUP BY can be used with HAVING clause to filter grouped data

  • Answered by AI
  • Q4. I was asked About my Project

Interview Preparation Tips

Interview preparation tips for other job seekers - Be Calm and Say no if you don't know

Skills evaluated in this interview

I applied via Company Website and was interviewed before Jun 2021. 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. SQL test along with ETL
Round 3 - One-on-one 

(1 Question)

  • Q1. Interview by project manager
Round 4 - HR 

(1 Question)

  • Q1. Salary discussion with the HR

Interview Preparation Tips

Interview preparation tips for other job seekers - Good scope for growth if potential is there

Interview Questionnaire 

3 Questions

  • Q1.  They Hired me for payroll process, so all the questions were payroll related.
  • Q2. Why you are leaving your current position ?
  • Q3. Tell me something about your current job profile and the nature of the job you perform.

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and open up yourself.

I applied via Naukri.com and was interviewed before Aug 2020. There was 1 interview round.

Interview Questionnaire 

2 Questions

  • Q1. Tell me about yourself and previous job experience
  • Ans. Explain in brief about your education, hobbies and quality skills that makes you worthy candidate for the required job
  • Answered Anonymously
  • Q2. Why you are leaving current company and why you want to join HCL

Interview Preparation Tips

Interview preparation tips for other job seekers - Provide the genuine answers that would connect with interviewer. Make them understand that what is the hurdle and blockages which were preventing your growth and how by applying here you can overcome those

I applied via Campus Placement and was interviewed before Apr 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. They asked me about looping concepts, oops concepts, asked to write a simple code, and about my project.

Interview Preparation Tips

Interview preparation tips for other job seekers - Before going to interview be ready with a project or any internship it helps a lot. Answer everything in a convincing manner.

Tell us how to improve this page.

Senior Analyst Interview Questions from Similar Companies

View all

Confidential Company Senior Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

2.0

Skill development

2.0

Work-life balance

3.0

Salary

2.0

Job security

2.0

Company culture

3.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Compare Confidential Company 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