Mantra Technologies Sales Head Interview Questions and Answers for Experienced

Q1. About myself and work exp.
Add your answer

Process knowledge and flight details

Question and answer about attitude

Q1. About myself and work exp
Add your answer

Q1. Dataflow related questions.
Add your answer
Q2. Bigquery related questions
Add your answer

Q1. Basic profile & experience related
Add your answer

Q1. Ads, operation, platform technical part, logical part, case study handling situation
Add your answer
Q2. There are various task to be performed, but totally depends on team lead, how they deal with it with different candidate
Add your answer

Q1. Same as above asked by another person
Add your answer

Q1. As I am a CCM developer there were brief questions about the tool that's it
Add your answer
Q2. The application was getting upgraded to a new one,I was some situation and asked how to solve it.
Add your answer

Q1. The second round was with the delivery lead and he was mostly explaining about the work and the project
Add your answer

Q1. This was on the employee benefits and salary negotiation
Add your answer

Q1. Basics about big data tools. Use case on Pyspark. How to add the new column and what is AQE benefits and Delta table optimisation tenchiques.
Add your answer
Q2. Basics about Azure resources like ADF, Azure Databricks. Explained the project architecture and sone questions on that.
Add your answer
Q3. Pyspark optimisation techniques explain and write scd type 2 sample code.
Ans. 
Optimisation techniques in Pyspark and sample code for SCD type 2
• Use broadcast variables to reduce data shuffling

• Partition data based on key columns to improve performance

• Use cache() or persist() to avoid recomputing data

• Use coalesce() or repartition() to reduce the number of partitions

• For SCD type 2, use merge() function to update or insert new records

• Example code for SCD type 2: https://github.com/awantik/pyspark-101
Answered by AI
Add your answer

Q1. How huge data your are working? What are toughest problem you faced and resolved it ?
Ans. 
I have worked with huge data sets in the past.
• I have experience working with data sets ranging from a few gigabytes to several terabytes.

• One of the toughest problems I faced was optimizing a query that was taking too long to execute.

• I resolved it by analyzing the query plan and identifying the bottleneck, then optimizing the query accordingly.

• Another challenge I faced was dealing with data inconsistencies, which I reso...read more
Answered by AI
Add your answer
Q2. Explain you project architecture ? Show some sample codes of the same.
Ans. 
Our project architecture follows a microservices approach with containerization using Docker and orchestration with Kubernetes.
• We have divided our application into smaller, independent services that communicate with each other through APIs.

• Each service is containerized using Docker, allowing for easy deployment and scaling.

• We use Kubernetes for orchestration, which automates the deployment, scaling, and management of o...read more
Answered by AI
Add your answer

Q1. Compensation decision and clear your doubts regarding organisation.
Add your answer

Q1. Project amd Advanced C++ concepts
Add your answer

C++ coding questions and logical questions

Q1. Basic Mainframe questions and some advanced scenario based questions
Add your answer

Q1. The usual how,what,why MR round questions
Add your answer

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. Why are you looking for a change?
Add your answer
Q5. Tell me about yourself.
Add your answer
Q6. Where do you see yourself in 5 years?
Add your answer