Principal Engineer and Solutions Architecture Interview Questions and Answers

Design an app to bring data from external vendors in different formats

• Create a data ingestion pipeline to collect data from various vendors

• Implement data transformation processes to standardize formats

• Utilize APIs or web scraping techniques to retrieve data from vendors

• Use a database to store and manage the collected data

• Implement data validation and cleansing techniques to ensure data quality

Design a historical pricing app for equity

• Utilize a database to store historical pricing data for equities

• Implement a user-friendly interface for users to search and view historical pricing

• Include features such as chart visualization, comparison tools, and customizable date ranges

• Consider incorporating real-time data updates and alerts for price changes