Amex Gbt Data Engineer Interview Questions and Answers

Q1. Spark related questions
Add your answer
Q2. Previous projects done
Ans. 
Developed a real-time data processing system for a retail company to optimize inventory management.
• Designed and implemented data pipelines to ingest, process, and analyze large volumes of data

• Utilized technologies like Apache Kafka, Spark, and Hadoop for real-time processing

• Built dashboards and reports for stakeholders to monitor inventory levels and make data-driven decisions
Answered by AI
Add your answer

Q1. 1- Tell me about yourself 2- Spark questions (Architecture, Dag, Lineage,Broadcast, Accumulator, Repartition,coalesce,cache,persist,etc) 3- Basic Pyspark coding problem 4- Python coding problem(Array) 5- ...read more
Add your answer

Q1. 1- Tell me about yourself 2- Spark architecture 3- Parquet vs avro 4- catalyst optimiser 5- external table vs managed table vs cluster table 6- GIL in python 7- Memory management in python 8- Data skewnes...read more
Add your answer

General Aptitude test

Q1. On SQL functions
Add your answer
Q2. Python coding questions
Add your answer

Q1. Cloud Computing
Add your answer
Q2. Spark Programming
Add your answer

Q1. Python, sql, aws
Add your answer

Q1. Aws, architecture and design
Add your answer

Q1. Cultural fit and compensation
Add your answer

Q1. Most of questions from your project
Add your answer
Q2. Oops concepts SQL joins
Add your answer
Q3. Angular Data binding
Add your answer

Q1. Angular project
Add your answer

This aptitude + technical MCQ test was of 120 minutes in duration. Had MCQs on quantitative ability, logical ability, Language, and technical MCQs consisted of questions on DBMS, OS, Networks, DSA. There were two coding questions as well. One on Bit Manipulating, and the other on DFS.

Q1. A question on BFS very similar to Leetcode 924. Was given one hour to discuss and come to an optimized solution with the interviewer.
Add your answer

Q1. Search an element in a sorted and rotated array
Ans. 
Search an element in a sorted and rotated array
• Find the pivot point where the array is rotated

• Divide the array into two sub-arrays based on pivot point

• Perform binary search on the appropriate sub-array
Answered by AI
Add your answer
Q2. SQL query on left join
Add your answer
Q3. Questions on CPP memory management
Add your answer
Q4. Questions related to projects done
Add your answer

Q1. Propose a system for a popular media stream service
Ans. 
Proposed system for a popular media stream service
• Implement a recommendation engine to suggest content based on user preferences and viewing history

• Integrate with social media platforms to allow users to share and discuss content

• Provide multiple subscription options with varying levels of access and features

• Ensure high-quality streaming with minimal buffering through the use of content delivery networks

• Implement robust...read more
Answered by AI
Add your answer
Q2. Questions related to Fullstack Tech Stacks
Add your answer

Guesstimate on number of Reddit users in India. No starting input was given. Gave solution by using bottom to top approach. Tried to focus on quantifying teenagers with internet access and a particular interest about internet. Gave a figure around ~1 million in a year.

Q1. Where do you see yourself at McKinsey?
Add your answer

Coding test on the Turing platform

Q1. Have u worked in a remote environment before?
Ans. 
Yes, I have worked in a remote environment before.
• I have experience working remotely as a software engineer.

• I am comfortable with remote collaboration tools and communication channels.

• I have successfully completed projects while working remotely.

• I am self-motivated and able to manage my time effectively in a remote setting.
Answered by AI
Add your answer