American Express Analytics : Enterprise Digital and Data Solutions (EDDS) Interview Questions & Experience Guide

Interview Preparation
,
1

American Express Analytics : Enterprise Digital and Data Solutions (EDDS) Interview Questions & Experience Guide

2

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Location: [Not specified]

Application Process: [Not specified]

Interview Rounds:

  • Round 1 - One-on-one Round:
    • Questions Asked:
      1. Accounting Standards
      2. International Financial Reporting
    • Your Approach: [Not specified]
    • Outcome: [Not specified]

Preparation Tips:

  • Focus on understanding Accounting Standards and International Financial Reporting (IFRS).
  • Brush up on skills like Variance Analysis, US GAAP, Automation, and Analytical skills as they are highly recommended for this role.

Conclusion:

[Not specified]

3

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Application Process: [Details not provided]

Interview Rounds:

  • Round 1 - Technical Round:
    • Questions Asked:
      1. Selenium basics
      2. SQL questions and Java
    • Your Approach: [Details not provided]
    • Outcome: [Details not provided]

Preparation Tips:

  • Focus on Selenium basics, SQL, and Java for technical rounds.
  • Practice hands-on coding and problem-solving in these areas.

Conclusion:

  • The interview was technical, focusing on Selenium, SQL, and Java. Preparing thoroughly for these topics would be beneficial for future candidates.
4

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Location: [Not specified]

Application Process: Applied via the company website in July 2024.

Interview Rounds:

  • Round 1 - HR Round:
    • Questions Asked:
      1. Background check.
      2. Work history and skills.
    • Your Approach: I ensured my resume was up-to-date and aligned with the job description. I also prepared to discuss my past experiences and how they relate to the role.
    • Outcome: [Result not specified]

Preparation Tips:

  • Do your due diligence when applying for a corporate job. Ensure your resume and skills match the job requirements.

Conclusion:
The interview process was straightforward, focusing on my background and skills. I recommend thoroughly reviewing your work history and being prepared to discuss how it aligns with the role.

5

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Application Process: The application was likely submitted online or through campus placement, though specific details were not provided.

Interview Rounds:

  • Round 1 - Technical Round:
    • Questions Asked:
      • Define your project structure.
    • Your Approach: I outlined the key components of my project, including the problem statement, methodology, tools used, and the outcomes. I emphasized how the structure aligned with business objectives and scalability.
    • Outcome: The round was focused on assessing my technical clarity and communication skills. Feedback was not explicitly shared, but the discussion was engaging.

Preparation Tips:

  • Brush up on explaining your projects concisely, focusing on structure and impact.
  • Be prepared to discuss how your work aligns with business goals.

Conclusion:
The interview was a great opportunity to articulate my project work in a structured manner. I could have prepared more examples of how my projects addressed real-world challenges. For future candidates, clarity and confidence in explaining your work are key.

6

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Application Process: I applied via a recruitment consultant and was interviewed before March 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: N/A (Resume-based shortlisting)
    • Your Approach: Ensured my resume was concise and highlighted relevant skills and experiences.
    • Outcome: Advanced to the next round.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. Questions aligned with the skill set and expertise mentioned in my resume.
      2. Specific technical questions:
        • How you copied on-prem data to cloud?
        • How you implemented a model in your application?
        • How you made your Hadoop clusters secure?
    • Your Approach: The interviewers were professional and well-behaved. The discussion started with introductions, followed by fundamental and in-depth questions, including some business cases.
    • Outcome: The round was challenging but insightful.

Preparation Tips:

  • Prepare thoroughly for everything mentioned on your resume.
  • Be ready to discuss practical implementations and business cases related to your skills.

Conclusion:
The interview process was professional and focused on validating my technical expertise. It reinforced the importance of being well-prepared for every detail on my resume. For future candidates, I’d advise focusing on practical applications of your skills and being ready to discuss real-world scenarios.

7

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Application Process: I applied through a recruitment consultant and was interviewed before October 2022.

Interview Rounds:

  • Round 1 - Resume Shortlist:

  • Questions Asked: N/A (Resume screening)

  • Your Approach: Ensured my resume was well-formatted and aligned to make it easy for the recruiter to review.

  • Outcome: Cleared the round.

  • Round 2 - Aptitude Test:

  • Questions Asked: Computer-based exam with aptitude questions.

  • Your Approach: Prepared by practicing general aptitude questions and time management.

  • Outcome: Cleared the round.

  • Round 3 - Technical Round:

  • Questions Asked: Managerial round (specific questions not mentioned).

  • Your Approach: Focused on demonstrating analytical and problem-solving skills relevant to the role.

  • Outcome: Cleared the round.

Preparation Tips:

  • Ensure your resume is well-structured and easy to read.
  • Practice aptitude tests to improve speed and accuracy.
  • Brush up on technical and analytical skills relevant to the role.

Conclusion:
The overall interview process was smooth, and I focused on presenting my skills clearly at each stage. Proper resume formatting and aptitude practice were key to my success. For future candidates, I’d recommend thorough preparation and attention to detail in every round.

8

Company Name: American Express

Position: Analytics : Enterprise Digital and Data Solutions (EDDS)

Location: Not specified

Application Process: Applied via LinkedIn and was interviewed in November 2023.

Interview Rounds:

  • Round 1 - Resume Shortlist:

    • Questions Asked: None (resume screening round).
    • Your Approach: Ensured my resume was crisp and highlighted relevant skills and experiences.
    • Outcome: Successfully shortlisted for the next round.

  • Round 2 - Technical Round:

    • Questions Asked:
      1. Given a list of strings, if the number is even, add 1 to convert it to odd; otherwise, keep it as is. Return the converted list. Also, write JUnit test cases.
      2. Create a stateless microservice in Spring Boot with CRUD APIs. Explain your approach and what you would return.
      3. General question about microservices.
    • Your Approach:
      • For the first question, I wrote a function to iterate through the list, check for even numbers, and modify them accordingly. I also prepared JUnit test cases to validate the function.
      • For the second question, I outlined the structure of a Spring Boot application, including controllers, services, and repositories. I explained the RESTful endpoints and the response formats.
      • The third question was more conversational, where I discussed my understanding of microservices architecture.
    • Outcome: Cleared the technical round.

Preparation Tips:

  • Be ready to create REST APIs during the interview.
  • Practice coding problems involving data manipulation and unit testing.
  • Brush up on Spring Boot and microservices concepts.

Conclusion:
The interview process was smooth, and the questions were aligned with the role’s requirements. I could have prepared more thoroughly for the microservices discussion, but overall, it was a great learning experience. For future candidates, focus on hands-on coding and system design, especially for roles involving analytics and backend development.

9

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Application Process: I applied via an online platform and was interviewed before April 2022.

Interview Rounds:

  • Round 1 - HR Round:

    • Questions Asked:
      • Tell me about yourself and why do you want to leave your current job?
    • Your Approach: I kept my introduction concise, focusing on my professional background and key achievements. For the second part, I highlighted my desire for growth and new challenges as the reason for seeking a change.
    • Outcome: I passed this round and moved to the next stage.

  • Round 2 - Technical Round:

    • Questions Asked:
      • What is the P2P Cycle, and when does AP work start?
    • Your Approach: I explained the Procure-to-Pay (P2P) cycle in detail, covering each stage from requisition to payment. For the AP (Accounts Payable) part, I clarified that it begins once the invoice is received and verified.
    • Outcome: I successfully answered the question and advanced further in the process.

Preparation Tips:

  • Ensure you are well-prepared for both HR and technical questions.
  • Stay updated with current affairs, as they might be relevant to the role.

Conclusion:
The interview process was smooth, and I felt confident in my responses. Preparing thoroughly for both behavioral and technical aspects was key. For future candidates, I’d recommend researching the company and role-specific concepts in advance.

10

Company Name: American Express

Position: Analytics - Enterprise Digital and Data Solutions (EDDS)

Application Process: The application process involved two interview rounds: a coding test and a technical round.

Interview Rounds:

  • Round 1 - Coding Test:

    • Questions Asked:
      • What would you do if a batch fails in production?
    • Your Approach: I explained the steps I would take to troubleshoot and resolve the issue, including checking logs, identifying the root cause, and implementing a fix while ensuring minimal downtime.
    • Outcome: Passed this round and moved to the next stage.

  • Round 2 - Technical Round:

    • Questions Asked:
      • What is a constraint in Oracle?
      • What are joins in Oracle?
    • Your Approach: For the first question, I defined constraints and provided examples like PRIMARY KEY, FOREIGN KEY, etc. For the second question, I explained different types of joins (INNER, OUTER, etc.) and their use cases.
    • Outcome: Successfully cleared this round as well.

Preparation Tips:

  • Focus on understanding database concepts, especially constraints and joins in Oracle.
  • Practice troubleshooting scenarios for production issues.
  • Brush up on SQL queries and their optimization.

Conclusion:
Overall, the interview process was smooth, and the questions were aligned with the role’s requirements. I felt well-prepared, but I could have spent more time on real-world troubleshooting scenarios. My advice to future candidates is to thoroughly understand database concepts and practice problem-solving for production issues.