Upload Button Icon Add office photos

Filter interviews by

PMJ Gems & Jewellers MIS Analyst Interview Questions and Answers

Updated 16 Apr 2024

PMJ Gems & Jewellers MIS Analyst Interview Experiences

1 interview found

MIS Analyst Interview Questions & Answers

user image Anonymous

posted on 16 Apr 2024

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Apr 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Self intro and past experience
Round 2 - Technical 

(3 Questions)

  • Q1. All about excel
  • Q2. Pivot tables, how it works?
  • Ans. 

    Pivot tables are a data summarization tool in spreadsheet software that allows you to reorganize and summarize selected columns and rows of data.

    • Pivot tables are used to analyze, summarize, and present large amounts of data in a more manageable format.

    • They allow users to group and summarize data based on specific criteria, such as categories or values.

    • Users can easily rearrange and customize the layout of the data to s...

  • Answered by AI
  • Q3. Lookups and its uses
  • Ans. 

    Lookups are used to retrieve data from a table based on a specified criteria.

    • Lookups are commonly used in databases to search for specific information.

    • They can be used to retrieve values from a table based on a key or index.

    • Lookups are essential in data analysis and reporting to fetch relevant data.

    • Examples include VLOOKUP in Excel, INDEX MATCH functions, and SQL SELECT queries.

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

(1 Question)

  • Q1. Manager round, asked about past experience

Interview Preparation Tips

Interview preparation tips for other job seekers - You won't grow unless Boot polishing the manager. Cheap politics/behaviour.

Skills evaluated in this interview

Interview questions from similar companies

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

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

Round 1 - Technical 

(2 Questions)

  • Q1. Tell about the lease accounting and its treatment in financial statement.
  • Ans. 

    Lease accounting involves recording lease agreements on the financial statements in accordance with accounting standards.

    • Lease accounting requires classifying leases as either operating leases or finance leases.

    • Operating leases are treated as off-balance sheet items, while finance leases are recorded as assets and liabilities on the balance sheet.

    • Lease payments for operating leases are expensed on the income statement,...

  • Answered by AI
  • Q2. Question on ms excel
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Campus Placement and was interviewed in Mar 2024. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me about yourself
  • Q2. What is hard work and smartwork

Interview Preparation Tips

Topics to prepare for KGK Group Data Analyst interview:
  • Data Visualization
  • Data Analysis
Interview experience
4
Good
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Sep 2023. 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 - Aptitude Test 

Grammar questions and subject based questions or company questions.

Round 3 - HR 

(5 Questions)

  • Q1. Self information and family details
  • Q2. Besed on subject knowledge questions
  • Q3. General knowledge questions
  • Q4. Growing our company questions
  • Q5. Staff questions
Interview experience
2
Poor
Difficulty level
-
Process Duration
-
Result
Selected Selected
Round 1 - Aptitude Test 

Company feedback, management checking department , quality assurance

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

I applied via Referral and was interviewed in Apr 2023. There were 5 interview rounds.

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 - Assignment 

Sql and excel assignment

Round 3 - Technical 

(1 Question)

  • Q1. Sql based queries
Round 4 - Case Study 

Business case studies

Round 5 - HR 

(1 Question)

  • Q1. Psychoanalytical round
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed before Mar 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Tell me about your experience
Round 2 - Aptitude Test 

SQL based test - timed

Round 3 - One-on-one 

(1 Question)

  • Q1. What is the best decision you've made in your current role

I was interviewed in Jan 2017.

Interview Questionnaire 

9 Questions

  • Q1. Derive formula for Pythagoras , area of circle and many more fundamental questions like these.
  • Q2. Find the volume of some 3D figures with some portion removed.
  • Ans. 

    To find the volume of 3D figures with portions removed, calculate the volume of the complete figure and subtract the volume of the removed portion.

    • Calculate the volume of the complete figure using the appropriate formula (e.g., for a cube, V = side^3)

    • Determine the volume of the removed portion using the appropriate formula (e.g., for a cylinder, V = πr^2h)

    • Subtract the volume of the removed portion from the volume of th

  • Answered by AI
  • Q3. Some questions related to the aptitude round.
  • Q4. General Introduction.
  • Q5. Basics of Business Analysis like risk management, costing analysis, inventory basics, pricing , trading etc etc.
  • Q6. Situation based questions regarding different regions of trading and hence their pricing
  • Q7. Profit Maximizing strategies
  • Q8. Complex puzzles. Many difficult ones.
  • Q9. Business Analysis basics.

Interview Preparation Tips

Round: Technical Interview
Experience: All the above questions were asked in full throttle right after another for approx 1 hour. Interviewer were well informed and were getting inside the skin of the candidate as far as sound knowledge was concerned. As such core technical wasn't examined but management skills were thoroughly analysed as per your CV. Their aptitude test wasn't an easy but to crack and some questions were so good that interviewer asked the same across the table to find out the logic of the candidate. Half an hour interview went on some stress basis as questions were easy but tricky (p.s. you won't expect a pythogoras theorem proving or an area of a circle proving to pop up).
Next gear of interview shifted to business analytics where basics of business e.g. profit maximization , price marking , resource allocation according to location and seasons were interviewed. Many situation based case studies were asked so as to test your management skills.
Last few mins were for your preference and ease of working.
Tips: Be genuine and generous.
Be positive.
Tackle every question properly.
Don't get demoralised in between the interview if you can't solve a question.
Be confident with a smile.

Round: HR Interview
Experience: This was a Skype round. It went for 45 mins approx. Believe me it was the hardest part as puzzles were very complex. But the best part is they watch out for your generalised approach towards solving your puzzles. Rest business analytics part was bit complex this time.
Tips: Be prepared.
Be composed.
Don't lose hope.
Don't make puppy face or demoralised body structure.
Solve puzzles and explain your approach even if it doesn't gets solved.

College Name: Jaypee Institute Of Information Technology, Noida

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

Interview Questionnaire 

1 Question

  • Q1. Questions were asked about MS-Excel , MS-PowerBI , Python , SQL , Pivot tables , DAX Functionalities

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep it simple , learn the basics of all the core topics of python and SQL and excel
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company 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 - Assignment 

Company's sales data was given and I was asked to derive insights out of it

Round 3 - One-on-one 

(1 Question)

  • Q1. Business Expansion- How would you take the business abroad?

PMJ Gems & Jewellers Interview FAQs

How many rounds are there in PMJ Gems & Jewellers MIS Analyst interview?
PMJ Gems & Jewellers interview process usually has 3 rounds. The most common rounds in the PMJ Gems & Jewellers interview process are HR, Technical and One-on-one Round.
How to prepare for PMJ Gems & Jewellers MIS 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 PMJ Gems & Jewellers. The most common topics and skills that interviewers at PMJ Gems & Jewellers expect are MIS Reporting, Pivot Table and VLOOKUP.
What are the top questions asked in PMJ Gems & Jewellers MIS Analyst interview?

Some of the top questions asked at the PMJ Gems & Jewellers MIS Analyst interview -

  1. Pivot tables, how it wor...read more
  2. Lookups and its u...read more
  3. All about ex...read more

Tell us how to improve this page.

PMJ Gems & Jewellers MIS Analyst Interview Process

based on 2 interviews

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Senco Gold Interview Questions
4.5
 • 535 Interviews
Tanishq Interview Questions
4.4
 • 71 Interviews
Bluestone.com Interview Questions
3.8
 • 41 Interviews
GRT Jewellers Interview Questions
4.2
 • 22 Interviews
Joyalukkas Interview Questions
4.3
 • 22 Interviews
Vaibhav Global Interview Questions
3.3
 • 20 Interviews
View all

PMJ Gems & Jewellers MIS Analyst Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

2.0

Skill development

1.0

Work-life balance

3.0

Salary

3.0

Job security

1.0

Company culture

2.0

Promotions

1.0

Work satisfaction

Explore 1 Review and Rating
Senior Sales Officer
16 salaries
unlock blur

₹2.7 L/yr - ₹6.2 L/yr

Business Head
10 salaries
unlock blur

₹18 L/yr - ₹30 L/yr

Sales Executive
10 salaries
unlock blur

₹2.9 L/yr - ₹5 L/yr

Executive Accountant
8 salaries
unlock blur

₹2 L/yr - ₹3.8 L/yr

Senior Sales Executive
7 salaries
unlock blur

₹2.2 L/yr - ₹4.8 L/yr

Explore more salaries
Compare PMJ Gems & Jewellers with

Tanishq

4.4
Compare

Kalyan Jewellers

4.6
Compare

Malabar Gold and Diamonds

4.1
Compare

PC Jewellers

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