Nxtgen Datacenter Cloud Technologies Sales Interview Questions and Answers

Q1. About Sales Process
Add your answer

3 SQL and 2 Python questions were asked, SQL was moderate, Python was tough

Python and SQL questions were asked

Q1. I was asked about the project
Add your answer

Q1. ACID properties of DBMS
Add your answer

Q1. HR question and family background
Add your answer

Python , dictionary operations

Q1. Family background
Add your answer
Q2. Location and salary
Add your answer

Q1. Spark based questions and coding questions
Add your answer

Q1. What are acid properties,tell about decorator in python,list comprehension questions,project explanation
Add your answer

Q1. How to optimize spark jobs ?
Ans. 
Optimizing Spark jobs involves tuning various parameters such as memory allocation, partitioning, and caching.
• Increase memory allocation for executors and driver

• Partition data appropriately to avoid skewness

• Cache frequently accessed data to avoid recomputation

• Use broadcast variables for small data sets

• Avoid shuffling data unnecessarily

• Use appropriate serialization format

• Use appropriate hardware for cluster

• Monitor and o
Answered by AI
Add your answer
Q2. What is coalesce and repartition ?
Ans. 
Coalesce is used to select the first non-null value from a set of columns. Repartition is used to shuffle data across nodes.
• Coalesce is a function that returns the first non-null value from a set of columns.

• Repartition is used to shuffle data across nodes to increase parallelism.

• Coalesce reduces the number of columns in a DataFrame.

• Repartition increases or decreases the number of partitions in a DataFrame.

• Coalesce is u...read more
Answered by AI
Add your answer

It wa really a great experience.

It was really a great experience.

Q1. Where do you see yourself after 3 years?
Ans. 
In 3 years, I see myself leading a team of data engineers, implementing cutting-edge technologies, and driving impactful data-driven decisions.
• Leading a team of data engineers

• Implementing cutting-edge technologies

• Driving impactful data-driven decisions
Answered by AI
Add your answer
Q2. What are your strenghts?
Ans. 
My strengths include strong analytical skills, attention to detail, and the ability to work well in a team.
• Strong analytical skills - able to analyze complex data sets and derive meaningful insights

• Attention to detail - meticulous in ensuring data accuracy and quality

• Team player - collaborate effectively with colleagues to achieve common goals
Answered by AI
Add your answer

Q1. What projects you have worked upon?
Ans. 
I have worked on projects involving building data pipelines, optimizing database performance, and creating machine learning models.
• Built data pipelines using Apache Spark and Kafka

• Optimized database performance by tuning queries and indexes

• Created machine learning models for predictive analytics

• Implemented real-time data processing using technologies like Apache Flink
Answered by AI
Add your answer
Q2. What is your CGPA?
Ans. 
My CGPA is 3.8 out of 4.0.
• My CGPA is 3.8, which is considered high in my university.

• I have consistently maintained a high CGPA throughout my academic career.

• I have received several academic awards based on my CGPA.

• My CGPA reflects my dedication and hard work towards my studies.
Answered by AI
Add your answer
Q3. What are your hobbies?
Ans. 
My hobbies include hiking, photography, and playing the guitar.
• Hiking: I enjoy exploring nature trails and challenging myself physically.

• Photography: I love capturing moments and landscapes through my camera lens.

• Playing the guitar: I find relaxation and creativity in strumming chords and learning new songs.
Answered by AI
Add your answer