11:11 Systems Senior Software Engineer Interview Questions and Answers

Use SQL JOIN to combine data from 3 tables based on a common key.

• Use INNER JOIN, LEFT JOIN, or RIGHT JOIN depending on the desired result

• Specify the columns to select from each table

• Use ON clause to specify the join condition

Green-field projects are great opportunities to start fresh and implement new technologies.

• Green-field projects allow for creative freedom and innovation

• They provide the opportunity to work with the latest technologies and tools

• Starting from scratch can lead to cleaner code and better architecture

• Examples: Developing a new mobile app, creating a new website from scratch

Count occurrences of a letter in a string.

• Iterate through each character in the string and count occurrences of the specified letter.

• Use a hashmap to store the count of each letter.

• Handle both uppercase and lowercase letters to ensure accurate counting.

Yes

• Worked as a software engineer at a financial institution for 5 years

• Developed and maintained financial software applications

• Implemented complex financial algorithms and calculations

• Collaborated with financial analysts and stakeholders to understand requirements

• Ensured compliance with financial regulations and security standards