Upload Button Icon Add office photos

J. C. Penney

Compare button icon Compare button icon Compare

Filter interviews by

J. C. Penney Business Analyst Interview Questions and Answers

Updated 16 Oct 2023

J. C. Penney Business Analyst Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - One-on-one 

(1 Question)

  • Q1. Techno Functional
Round 3 - One-on-one 

(1 Question)

  • Q1. Functional Round
Round 4 - One-on-one 

(1 Question)

  • Q1. Aptitude , functional and behavioral

Interview questions from similar companies

I applied via Recruitment Consulltant and was interviewed in Jun 2022. 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 

(2 Questions)

  • Q1. Difference between where and having clause?.
  • Ans. 

    WHERE clause filters rows before grouping while HAVING clause filters groups after grouping.

    • WHERE clause is used to filter rows based on a condition before grouping them.

    • HAVING clause is used to filter groups based on a condition after grouping them.

    • WHERE clause is used with SELECT, UPDATE, DELETE statements while HAVING clause is used with GROUP BY clause.

    • WHERE clause is faster than HAVING clause as it filters rows be...

  • Answered by AI
  • Q2. Lead lag questions . Explain windows functions and stored procedure

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL in detail. Prepare one machine learning project

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(1 Question)

  • Q1. Do you have any offer in hand
  • Ans. 

    Yes, I have received an offer from another company.

    • Received offer from Company XYZ for Data Analyst position

    • Currently evaluating the offer and considering my options

    • No decision has been made yet

  • Answered by AI

I applied via Naukri.com and was interviewed in Oct 2020. There was 1 interview round.

Interview Questionnaire 

3 Questions

  • Q1. Online Aptitude Test
  • Q2. Questions from my resume/previous employment
  • Q3. Scenario based question/Business case study

Interview Preparation Tips

Interview preparation tips for other job seekers - This interview was for Data analyst role at Reliance Retail. First , I had online aptitude test-50 questions 12 minutes. You need to at least solve 20 correctly. Post this I had online technical interview which lasted for about 40minutes. Initially the interviewer asked me about few accomplishments from my previous employment which had impacted business. I took him through few major projects that I worked and how these impacted business. I made sure to keep everything aligned to data analyst role. I spoke about what Data visualization tools (Domo/tableau) and languages(SQL) I had used previously to analyze data. He had follow up questions and I again made sure to explain clearly by highlighting my role. Next , there was one scenario based question asked.
Q: There are a couple of reliance stores that are bleeding(doing really bad) in one region. You have all the necessary data related to these stores. What would be those factors that you will consider first ? What will you do to ensure these stores do well.
Since I had retail background it was easier for me to understand the scenario based question. The interviewer wanted to understand how I would approach the problem.
Last, I had few questions to the interviewer based on the role.
On the same day I received call from HR saying that I have cleared the interview and offered the role.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Sep 2023. There were 3 interview rounds.

Round 1 - Case Study 

Road daily revenue collection

Round 2 - Technical 

(2 Questions)

  • Q1. SQL question, Python coding
  • Q2. Highest salary in a table
Round 3 - HR 

(1 Question)

  • Q1. Salary Negotiation
Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via LinkedIn and was interviewed in Mar 2024. There were 2 interview rounds.

Round 1 - Coding Test 

It was Python based basic questions only

Round 2 - HR 

(1 Question)

  • Q1. Basic question, strength, weakness

Interview Preparation Tips

Interview preparation tips for other job seekers - read your resume content
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. The difference between union and union all
  • Ans. 

    Union combines and removes duplicates, while Union All combines without removing duplicates.

    • Union combines two result sets and removes duplicates

    • Union All combines two result sets without removing duplicates

    • Union is slower than Union All as it involves removing duplicates

    • Union requires both result sets to have the same number of columns and compatible data types

  • Answered by AI
  • Q2. SQL query execution order

Skills evaluated in this interview

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

I applied via Company Website and was interviewed before Oct 2023. There were 2 interview rounds.

Round 1 - Technical 

(1 Question)

  • Q1. SQL basic questions
Round 2 - Case Study 

Business Thinking Case studies

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

10 sql and 10 python questions

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
-

I applied via Job Portal

Round 1 - Technical 

(1 Question)

  • Q1. Round 1: This is an initial screening round. You will be tested on the foundation of multiple technologies. SQL (Majority), Python, Visualization skillset and some basic statistics. Round 2 : Advance t...

Interview Preparation Tips

Topics to prepare for Target Data Analyst interview:
  • SQL

J. C. Penney Interview FAQs

How many rounds are there in J. C. Penney Business Analyst interview?
J. C. Penney interview process usually has 4 rounds. The most common rounds in the J. C. Penney interview process are One-on-one Round and Resume Shortlist.
What are the top questions asked in J. C. Penney Business Analyst interview?

Some of the top questions asked at the J. C. Penney Business Analyst interview -

  1. Aptitude , functional and behavio...read more
  2. Techno Functio...read more
  3. Functional Ro...read more

Tell us how to improve this page.

J. C. Penney Business Analyst Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more
J. C. Penney Business Analyst Salary
based on 12 salaries
₹8 L/yr - ₹24 L/yr
53% more than the average Business Analyst Salary in India
View more details

J. C. Penney Business Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

2.0

Skill development

1.0

Work-life balance

2.0

Salary

4.0

Job security

1.0

Company culture

1.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
L2 Engineer
70 salaries
unlock blur

₹8.3 L/yr - ₹18 L/yr

Analyst
61 salaries
unlock blur

₹5 L/yr - ₹12.7 L/yr

Senior Software Engineer
56 salaries
unlock blur

₹11.9 L/yr - ₹26.5 L/yr

Senior Engineer
54 salaries
unlock blur

₹10 L/yr - ₹26.5 L/yr

Senior Analyst
43 salaries
unlock blur

₹5.7 L/yr - ₹21.5 L/yr

Explore more salaries
Compare J. C. Penney with

Reliance Retail

3.9
Compare

DMart

3.9
Compare

Future Group

4.3
Compare

Landmark Group

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