Cracked Amazon as Data Analyst | List of companies hiring for Data Analyst profile

TL;DR

The interviewee shares their successful job application strategies and experiences, including rejections before landing at Amazon.

Transcript

It was a big deal for me because I come from Tier 3 college and I haven't even done B.Tech. So it was a big deal for me to crack Amazon. I want to know that apart from Amazon, did you crack any other offers? Yes, I had cracked the other companies as well. First was Airtel, then I had cracked Moody, and then I had cracked PharmEasy. But apart from t... Read More

Key Insights

• 🧭 Tailoring a resume to specific job descriptions significantly increases the likelihood of passing ATS checks and garnering recruiter interest.
• 😀 Consistency and persistence are essential in job hunting; many candidates give up after facing initial rejections.
• ❓ Utilizing online platforms like LinkedIn and maintaining professional connections can enhance job referral opportunities.
• ❓ Familiarity with technical skills (SQL, Python, Excel) is critical for success in data-related roles, as demonstrated through the interviewee's experience.
• ⚾ Implementing the STAR method helps structure responses to scenario-based questions effectively during interviews.
• ⌛ Job seekers should be strategic about timing their applications, as submitting during peak hours may yield better visibility.
• 🍝 Collecting and reviewing past interview questions can provide valuable insights and prepare candidates for common topics.

Questions & Answers

Q: What was your strategy for job applications?

I typically updated my resume every morning and used two main portals—job sites and LinkedIn—to apply for jobs. I found that 8 am to 10 am was the peak time to submit applications as recruiters were most active then, which increased my chances of getting noticed and receiving interview calls.

Q: How do you approach preparing for interviews?

I prepared by reviewing common interview questions and practicing on platforms like LeetCode for SQL and Python questions. I also maintained a collection of questions from previous interviews, which helped me feel prepared for various scenarios I might encounter in the actual interviews.

Q: What do you recommend for creating a resume?

It’s crucial to personalize your resume for each application, aligning it with the specific job description. Maintenance of an Excel sheet with daily tasks can help easily update your resume when applying for new roles. Focus on concise bullet points that highlight your achievements quantitatively.

Q: Can you share your experience with interviews at Amazon?

The Amazon interview process consisted of five rounds focusing heavily on technical skills, including SQL, Python, and Excel. They emphasized their leadership principles and used a STAR format for scenario-based questions, allowing me to effectively articulate my past experiences and their outcomes.

Q: What challenges did you face during your job search?

One of the biggest challenges was the market tightness and high competition, leading to many rejections from reputable companies like Citibank and HSBC. It was disheartening initially, especially since I applied to over 50 jobs a day without receiving any calls during the first couple of weeks.

Q: What skills are important to focus on when applying for data roles?

Key skills included SQL knowledge, especially joins and output questions, proficiency in Python (notably the Pandas library), and mastering MS Excel formulas. Visualization tools like Power BI were also highlighted as important depending on company requirements.

Q: How did you manage your time while working and applying for new jobs?

I dedicated my evenings and weekends to preparation. Staying late at work allowed me to study for 1-2 hours during the week and focus more on comprehensive studying on weekends, sacrificing leisure activities to ensure I was thoroughly prepared.

Summary & Key Takeaways

• The interviewee discusses the multiple job offers they received from companies including Airtel and PharmEasy, alongside their preparation methods.

• They share their strategies for job hunting, emphasizing the importance of tailoring resumes, checking ATS scores, and utilizing job portals effectively.

• Additionally, they recount facing numerous rejections but maintaining resilience, ultimately succeeding in securing a position at Amazon.