Paytm Payments Bank Big Data Engineer Interview Questions and Answers

Q1. Write an update query in SQL (Easy)
Add your answer
Q2. A case study SQL question which needs to be solved using CASE WHEN (Easy)
Add your answer
Q3. Past projects experience
Add your answer
Q4. Banking domain knowledge
Add your answer

Q1. Load 60 GB of csv file and perform transformation.
Ans. 
Use distributed computing framework like Apache Spark to efficiently load and transform the large CSV file.
• Use Apache Spark to distribute the workload across multiple nodes for faster processing.

• Utilize Spark's DataFrame API to read the CSV file and apply transformations.

• Consider partitioning the data to optimize performance.

• Use Spark SQL for complex transformations and aggregations.

• Leverage in-memory processing capabi
Answered by AI
Add your answer

Q1. What is regressions and how you used in your project
Ans. 
Regression is a statistical method used to analyze the relationship between variables.
• Regression is used to predict the value of a dependent variable based on the values of one or more independent variables.

• Common types of regression include linear regression, logistic regression, and polynomial regression.

• In my project, I used regression to analyze the impact of marketing spending on sales revenue.

• Regression helps in ...read more
Answered by AI
Add your answer

Q1. Where are you from? Family background? And salary or near by location Its over.
Add your answer

Q1. What complete your qulification?
Ans. 
I have completed a Bachelor's degree in Computer Science and have received certification in data entry operations.
• Bachelor's degree in Computer Science

• Certification in data entry operations
Answered by AI
Add your answer

Q1. Basics of spark , Hadoop,sql, python
Add your answer

Q1. Building a pipeline
Ans. 
Building a pipeline involves creating a series of interconnected data processing steps to move and transform data from source to destination.
• Identify data sources and destinations

• Determine the data processing steps required

• Choose appropriate tools and technologies

• Design and implement the pipeline

• Monitor and maintain the pipeline
Answered by AI
Add your answer

Q1. Resume based questions
Add your answer

Q1. Where do you see yourself in 5 years
Ans. 
In 5 years, I see myself as a senior data engineer leading a team, implementing innovative solutions, and driving data-driven decision-making.
• Leading a team of data engineers

• Implementing innovative solutions to optimize data processing and analysis

• Driving data-driven decision-making across the organization

• Continuously learning and staying updated with the latest technologies and trends in data engineering

• Contributing t
Answered by AI
Add your answer

Basic concepts, basic formulas

Group discussion and and personal test

Q1. What are your salary expectations?
Add your answer
Q2. Share details of your previous job.
Add your answer
Q3. Why should we hire you?
Add your answer
Q4. Tell me about yourself.
Add your answer
Q5. You will do rotational shifts
Add your answer

Q1. Sql pyspark work related question basic and coding
Add your answer