American Express Software Engineer Interview Questions and Answers

This question is about basic concepts in C and C++ programming languages.

• C and C++ are programming languages used for system and application software development.

• Tokens are the basic building blocks of a program, such as keywords, identifiers, operators, and literals.

• Statements are instructions that perform a specific task.

• Functions are blocks of code that perform a specific task and can be called from other parts of the program.

• Arrays are collections of similar data types st...read more

Program to find 2nd highest number in an unsorted array.

• Sort the array in descending order and return the second element.

• Iterate through the array and keep track of the two highest numbers.

• Handle edge cases like duplicates and small array sizes.

Use SQL JOIN to find common values in two tables.

• Use INNER JOIN to combine the two tables based on a common column

• Select the columns you want to display in the result

• Add a WHERE clause to filter out non-matching values

To find the mid element in a linked list while iterating only once, we can use the two-pointer approach.

• Use two pointers, one moving at twice the speed of the other.

• When the faster pointer reaches the end of the list, the slower pointer will be at the mid element.

SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

• SCD Type 2 maintains a separate row for each change in data, with a start and end date.

• It requires a surrogate key to uniquely identify each row.

• Informatica provides a built-in SCD Type 2 transformation to implement this technique.

• Example: tracking changes in customer addresses over time.

We use a continuous deployment strategy with automated testing and manual approval.

• We have a Jenkins pipeline set up for continuous integration and deployment.

• Our code is automatically tested using unit tests and integration tests.

• Once the tests pass, the code is deployed to a staging environment for manual testing.

• If the staging tests pass, the code is deployed to production.

• We also have rollback procedures in place in case of issues.

• We use Docker containers to ensure consis...read more

Spring Boot is an extension of Spring Framework that simplifies the development of Spring-based applications.

• Spring Boot provides a pre-configured environment for building applications, while Spring Framework requires more configuration.

• Spring Boot includes an embedded server, while Spring Framework requires an external server.

• Spring Boot provides a variety of starter dependencies to quickly add functionality, while Spring Framework requires manual dependency management.

• Sprin...read more

Database sharability refers to the ability of multiple users or applications to access and modify the same database concurrently.

• Allows multiple users or applications to access and modify the same database simultaneously

• Ensures data consistency and integrity by managing concurrent access

• Commonly used in multi-user systems or applications

• Examples include online banking systems where multiple users can access their accounts at the same time