Tip 1 : Practice Atleast 300 Questions
Tip 2 : Practice different approaches to solve a particular problem
Tip 3 : Do Atleast 2 projects
Tip 1 : Have some Projects on resume
Tip 2 : Do not put false things on resume
Develop an e-commerce page with the product image on the left and product info on the right (reference here). Product info should come from Dynamo DB. When the user clicks on Add to bag, record the choice in DB. When user clicks on proceed to the bag show the summary page.
1. Write a lambda(X) to read the given data from S3: input/dump.json, modify the dateRep to a random date and dump the file onto another s3 folder -- ouput/yyyy-mm-dd/uuid.json (year-month-date of dateRep. Uuid is a universally uniq number) every 1minutes (use cloudwatch to trigger the lambda X.
2. When dumping into the folder check if there is an existing file already. If yes and if the existing file size is less than 10MB then append the new data into the file, else create a new file. The output file to have one json per line.
3. Run AWS Glue and generate schema. Have a lambda (Y) which runs Athena query and converts all of the JSON data (output/*) into ORC files (Using CTAS query).
4. Write lambda (Z) which exposes reset api. On rest api call run the SQL and return the response.
5. Write reactjs app which sends rest api calls every 1minute and plots the graph using react google charts
Are you comfortable with relocation?
Why should we hire you?
What are your strengths and weakness?
Here's your problem of the day
Solving this problem will increase your chance to get selected in this company
Which SQL keyword removes duplicate records from a result set?