Upload Button Icon Add office photos

Filter interviews by

Agrawal Metal Works Data Analyst Interview Questions and Answers

Updated 5 Dec 2024

Agrawal Metal Works Data Analyst Interview Experiences

1 interview found

Data Analyst Interview Questions & Answers

user image Anonymous

posted on 5 Dec 2024

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

I applied via Recruitment Consulltant and was interviewed before Dec 2023. There were 3 interview rounds.

Round 1 - HR 

(1 Question)

  • Q1. Basic questions about yourself
Round 2 - Technical 

(2 Questions)

  • Q1. Advance excel formulas and features
  • Q2. Power BI basic questions
Round 3 - One-on-one 

(1 Question)

  • Q1. Technical questions related to Mechanical Engineering

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare very well as it's a lengthy process.

Interview questions from similar companies

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

(1 Question)

  • Q1. Background experience, previous client facing challenges
Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed before Mar 2023. There was 1 interview round.

Round 1 - Technical 

(1 Question)

  • Q1. Explain PTP process
  • Ans. 

    PTP process stands for Procure-to-Pay process, which involves the steps from purchasing goods/services to making payment.

    • PTP process starts with requisitioning of goods/services by a department.

    • Next step involves obtaining quotes, selecting a vendor, and creating a purchase order.

    • Goods/services are received, and invoices are matched with the purchase order.

    • Payment is made to the vendor based on the invoice.

    • The process ...

  • Answered by AI

Skills evaluated in this interview

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

I appeared for an interview before Feb 2024.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Can you describe the challenging accounting projects you have managed?
  • Ans. 

    Managed complex accounting projects involving revenue recognition, mergers and acquisitions, and financial statement analysis.

    • Led a team in implementing new revenue recognition standards, ensuring compliance with GAAP

    • Managed the accounting aspects of a merger, including due diligence, purchase price allocation, and integration of financial systems

    • Conducted detailed financial statement analysis to identify trends, varia

  • Answered by AI
  • Q2. What ERP software have you worked with?
  • Ans. 

    I have worked with SAP, Oracle, and Microsoft Dynamics ERP software.

    • Experience with SAP ERP software

    • Proficiency in Oracle ERP software

    • Familiarity with Microsoft Dynamics ERP software

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

(2 Questions)

  • Q1. What is your approach to measuring team performance?
  • Ans. 

    I measure team performance through a combination of KPIs, regular feedback sessions, and performance reviews.

    • Establish key performance indicators (KPIs) to track team progress

    • Conduct regular feedback sessions to address strengths and areas for improvement

    • Schedule periodic performance reviews to evaluate individual and team achievements

    • Utilize tools like balanced scorecards or dashboards to visualize performance data

  • Answered by AI
  • Q2. Can you describe how you contributed to reducing costs within the company?
  • Ans. 

    I implemented process improvements and negotiated better vendor contracts to reduce costs.

    • Identified inefficiencies in current processes and proposed solutions to streamline operations

    • Negotiated with vendors to secure better pricing and terms for supplies and services

    • Implemented cost-saving measures such as switching to more cost-effective suppliers or technologies

    • Analyzed spending patterns and identified areas where c...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Salary discussion and negotiations
  • Q2. Preferred location and joining date
  • Ans. 

    Preferred location is New York City and preferred joining date is within the next month.

    • Preferred location: New York City

    • Preferred joining date: Within the next month

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Research the company culture before joining; do not be swayed solely by a lucrative salary increase. Reach out to individuals for recommendations and references.
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Approached by Company and was interviewed in Jul 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 - Technical 

(3 Questions)

  • Q1. They took a technical test for basic accounting skill and also take one email writing.
  • Q2. Basic accounting knowledge test
  • Q3. Email writing for the response from client
Round 3 - One-on-one 

(1 Question)

  • Q1. Overall they asked me about my current profile in detail some of they asked accounting questions.

Interview Preparation Tips

Interview preparation tips for other job seekers - For this company every hiring person said before the interview that they will provide the offer letter on the spot but as I selected they hold my profile, I don't know why and I really disappointed from this company because when you go for Face to face interview to the company, you prepare for interview, also find the time from current company and after selection they hold your profile, really time waste and regretting feeling.

Interview Questionnaire 

2 Questions

  • Q1. Why do you want to join the company?
  • Ans. 

    I am excited to join the company because of its reputation for innovation and commitment to employee development.

    • The company has a strong track record of developing cutting-edge technology.

    • I am impressed by the company's commitment to employee training and development programs.

    • I am excited about the opportunity to work with a team of talented and motivated professionals.

    • The company's values align with my own, and I bel...

  • Answered by AI
  • Q2. What do you understand about safety?
  • Ans. 

    Safety refers to the measures taken to prevent harm or danger to people, property, or the environment.

    • Safety involves identifying and assessing potential hazards

    • It requires implementing measures to control or eliminate those hazards

    • Safety also involves training and educating individuals on safe practices

    • Regular inspections and maintenance are necessary to ensure ongoing safety

    • Examples of safety measures include wearing...

  • Answered by AI

Interview Preparation Tips

Round: Interview
Experience: Simple HR questions were asked along with questions on specifics of the company.
Tips: Don’t upload information that you cannot justify.

Round: Test
Experience: Pretty easy test.

Round: technical + HR interview
Experience: The technical questions are pretty tough, HR questions are pretty standard and easy. Simple HR questions and questions related to your department
Tips: One should prepare a lot of technical questions.

Skill Tips: Internships and projects in your own department subjects is encouraged. Team involvement is encouraged.
Skills: Good communication skills
College Name: IIT-Kharagpur

Interview Preparation Tips

Round: Resume Shortlist
Tips: Prepare on the basis of your resume and gather company info. Be sure of why you want to join the company and how can you handle the rigors of field work in a core job. No technical questions.

Round: telephonic interview
Experience: Preliminary check of the candidate.
Tips: Check for tips on how to appear in a telephonic interview in a calm and relaxed state of mind.

Round: Test
Tips: Preparing from the CAT study materials helps a lot and the website provides sample question and answers for preparation. Answers in the personality questionnaire are checked for any inconsistencies. So try to be natural.
Duration: 90 minutes

Round: Technical Interview
Experience: Interview by an engineer related to your core field, checks for the candidate’s technical proficiency and team work skills. Questions are usually straight forward and some technical questions will be asked.
Tips: The candidates must remember specific details of his internship experience as it usually decides the interview outcome The usual preparation for appearing in an interview should do.

Round: Technical Interview
Experience: Interview by a senior engineer. Interview is usually informal in nature and any doubts regarding work life are explained. He may check thecandidate’s software skills.

General Tips: The company looks for motivated candidates to work for the company. Aspiring students should have a clear idea of the work environment and the safety precautions it entails, the potential dangers of field work in a remote area. Go though the responses in the previous editions of Tnpedia and get the details from seniors who got placed.
Skill Tips: CGPA > 8 is usually preferred though not mandatory, Must have a clear idea of the basic engineering principles. Ability to work in a team is essential for the company. The company often asks for prior experience of managing multiple tasks and meeting deadline. Quantitative Language and Non-verbal skills are checked in the online tests. Internship in the Core industrial field are highly preferred. The candidates are often selected on the basis of the work performed in their internships.
Skills: Quantitative skills, Verbal & Non-verbal
College Name: IIT Kharagpur

Interview Preparation Tips

Round: Resume Shortlist
Experience: Simple HR questions. Specifics of the company. Why do you want to join the company? What do you understand about safety? These were some of the common questions asked to applicants.
Tips: Don’t upload information that you cannot justify.

Round: Test
Experience: Pretty easy test (Focused areas: math ability, verbal ability, and a psychometric test)

Round: Technical Interview
Experience: The technical questions are pretty tough.
Tips: One should prepare a lot.

Round: HR Interview
Experience: HR questions are pretty standard and easy. Simple HR questions and questions related to your department
.

Skill Tips: Good academic credentials, but you don’t require a very high CGPA. Team involvement is encouraged. Internships and projects in your own department subjects is encouraged. Good communication skills are important.
College Name: IIT-Kharagpur

Interview Questionnaire 

11 Questions

  • Q1. I was asked to tell something about myself. I focused on my Technical Skills( projects, BTP. Tried to present my interest in Energy sector and in technology in general), then my POR where I told about vari...
  • Q2. What do I know about Rio and why do I want to join it
  • Ans. 

    Rio is a global mining company with a focus on sustainable practices and community engagement.

    • Rio is one of the largest mining companies in the world

    • They have a strong commitment to sustainability and reducing their environmental impact

    • Rio places a high value on community engagement and working with local communities

    • They offer opportunities for career growth and development

    • I am excited to join Rio because of their repu

  • Answered by AI
  • Q3. About my technical skills
  • Q4. About my POR
  • Q5. About cross cultural experience
  • Q6. If I am given an offer from Schlum and Rio both, then what would I choose and why
  • Ans. 

    I would choose the company that aligns better with my career goals and values.

    • I would research both companies thoroughly to understand their culture, values, and career growth opportunities.

    • I would consider the location and work-life balance offered by both companies.

    • I would also take into account the compensation and benefits package offered by both companies.

    • Ultimately, I would choose the company that offers the best...

  • Answered by AI
  • Q7. If I liked any sports or art forms etc
  • Ans. 

    I enjoy playing basketball and painting in my free time.

    • I have been playing basketball since high school and enjoy playing pick-up games with friends.

    • I also enjoy painting and have taken a few art classes to improve my skills.

    • I find both activities to be a great way to relieve stress and unwind after a long day.

  • Answered by AI
  • Q8. My 3rd yr internship project
  • Q9. My BTP
  • Q10. Why m I not going for higher studies rt away?
  • Ans. 

    I believe gaining practical experience in the industry will enhance my understanding and skills before pursuing higher studies.

    • I want to gain practical experience in the industry before pursuing higher studies

    • I believe this will enhance my understanding and skills

    • I want to apply the knowledge gained during my undergraduate studies in a practical setting

    • I want to explore different career paths before committing to a spe

  • Answered by AI
  • Q11. Have I done something ever which promoted safety awareness/practices around me( These people are too obsessed with safety)

Interview Preparation Tips

Round: Test
Experience: They have a long short listing process. Online aptitude test, 3 short essays etc but mostly, short listing is resume based. There is a telephonic round as well but questions for the same are known well in advance. Few keywords for short listing are 
1 .Technical Skills 
2. POR
3. Cross - Cultural Experience 
4. You get bonus points if you have done some project related to energy, environment etc and have been exposed to an atmosphere where safety practices were critically followed.

Round: HR Interview
Experience: I had 2 round of interviews. Few people had even more than 3 rounds. I was told that I am being given an offer during my 2nd round itself.

Round 1. – Interviewers- Three in no., 1 Australian, 2 Indians.
Round 2. Interviewers- Five in no.- Three Australian. 2 Indian( Don’t know if anyone of them was an engineer. Mostly HR people.)

Because few of the interviewers were Australians, it became all the more important that I spoke slow and it should be clear to everyone.

General Tips: If you are targeting day one companies than you need to have certain spikes in your resume. These spikes can be academic, research based, internships, POR, extra currics etc. What most of us do not realize is that interview preparation in itself is a very good spike which can definitely get you shortlisted in more no. of companies and increase your chances of getting selected in each of them. I would just suggest. Take good amount of time in deciding what you really want to do. If you decide that you want do a job after your education at IITK, then prepare well for it and earn it.
Skill Tips: The thing that went well was that most of the questions I was asked were expected so I had already prepared for them. They look for certain traits in individuals.
1 .Technical Skills 
2. POR(not necessarily in extra currics, even a good project management counts)
3. Cross - Cultural Experience(Adaptability-because you are placed in Australia) 
4. Confidence 
5. Outgoing Nature
6. Interest in energy/environment etc.


I could present that I have most of these traits. I could not prepare well for aptitude during my placement preparation which I should have. I gave few aptitude test but did not get selected. I had some amount of bad luck in BCG and Diamond both in pre interview process and during interview, but that is something which can happen so it is advisable to be mentally prepared for it and try and get shortlisted in as many companies as you can.
College Name: IIT KANPUR

Interview Preparation Tips

Round: Test
Experience: Everyone who had applied was allowed to appear for a psychometric test. This was a test to determine whether the person is suitable for the position or not. A psychometric test is a way to analyze test taker’s personality traits by analyzing whether one’s response to a situation remains same if the same question has been put differently.
After the psychometric test there was a written test for the selected candidates. The test was simple and not so tough and had general questions from verbal ability, quantitative ability and logical reasoning. You just need to make sure you don’t commit silly mistakes and you will be able to clear the test easily.

Round: Group Discussion
Experience: Next round was a group discussion which was like a group case study. The general theme of the case study is mentioned below.
Case Study based on the production capacity of a plant. Various variables were given along with target production of that day. The group had to discuss upon various issues and use the most optimum conditions keeping a right balance between target and safety requirements.

Round: HR Interview
Experience: The personal interview had HR questions. The HR questions were nothing extra ordinary but the normal ones that are expected in any personal interview. They included details about me, my strengths and weaknesses, my long term and short term goals. Also they also asked me whether I would be able to adjust to field life easily.
Besides these questions they had few plant related questions. This was about the working of the plant and about how you are going to respond to a certain emergency situations if they arise. These were related to production, work culture and working of the labour union. Besides this there were questions about extraction of metal and in my case the metal was copper.

College Name: IIT ROORKEE

Agrawal Metal Works Interview FAQs

How many rounds are there in Agrawal Metal Works Data Analyst interview?
Agrawal Metal Works interview process usually has 3 rounds. The most common rounds in the Agrawal Metal Works interview process are HR, Technical and One-on-one Round.
What are the top questions asked in Agrawal Metal Works Data Analyst interview?

Some of the top questions asked at the Agrawal Metal Works Data Analyst interview -

  1. Technical questions related to Mechanical Engineer...read more
  2. Advance excel formulas and featu...read more
  3. Power BI basic questi...read more

Tell us how to improve this page.

Agrawal Metal Works Data Analyst Interview Process

based on 1 interview

Interview experience

4
  
Good
View more

Interview Questions from Similar Companies

Rio Tinto Interview Questions
3.5
 • 40 Interviews
Super Smelters Interview Questions
3.9
 • 33 Interviews
Ambey Mining Interview Questions
3.3
 • 29 Interviews
MSPL Interview Questions
4.1
 • 24 Interviews
View all
Agrawal Metal Works Data Analyst Salary
based on 4 salaries
₹4.6 L/yr - ₹6.8 L/yr
At par with the average Data Analyst Salary in India
View more details

Agrawal Metal Works Data Analyst Reviews and Ratings

based on 1 review

4.0/5

Rating in categories

3.0

Skill development

5.0

Work-life balance

5.0

Salary

5.0

Job security

5.0

Company culture

5.0

Promotions

3.0

Work satisfaction

Explore 1 Review and Rating
Assistant Engineer
15 salaries
unlock blur

₹3.3 L/yr - ₹7 L/yr

Engineer
13 salaries
unlock blur

₹4 L/yr - ₹8.3 L/yr

Production Supervisor
13 salaries
unlock blur

₹2 L/yr - ₹3.5 L/yr

Executive
13 salaries
unlock blur

₹3 L/yr - ₹6.3 L/yr

Quality Engineer
12 salaries
unlock blur

₹2 L/yr - ₹4.2 L/yr

Explore more salaries
Compare Agrawal Metal Works with

Super Smelters

3.9
Compare

MN Dastur & Company

4.1
Compare

MSPL

4.1
Compare

Toyota Tsusho

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