ARPAN INFRASOLUTION System Administrator Interview Questions and Answers

Q1. Normal introduction was asked
Add your answer
Q2. Description of the previous role
Add your answer
Q3. Roles and responsibilities
Add your answer

Not applicable , this was final round

Water scarcity, 3 mins , name-area-parents-topic

Q1. Tell me about yourself
Ans. 
I am a passionate software engineer with experience in developing web applications using various technologies.
• Experienced in developing web applications using HTML, CSS, JavaScript, and frameworks like React and Angular

• Proficient in backend development with Node.js and databases like MySQL and MongoDB

• Familiar with version control systems like Git and deployment tools like Docker

• Strong problem-solving skills and ability
Answered by AI
Add your answer
Q2. What is your background
Ans. 
I have a Bachelor's degree in Computer Science and 5 years of experience in software development.
• Bachelor's degree in Computer Science

• 5 years of experience in software development
Answered by AI
Add your answer

It consists of basic aptitude questions and some coding output questions followed by basic SQL questions. Overall the difficulty level was medium.

Q1. They asked me to write code for 4 problems. All questions consists array medium level and then there are difficult SQL questions to solve. Unfortunately I couldn't passed this round. But it was a great lea...read more
Add your answer

It has general aptitude questions with moderate difficulty

It was mixed coding plus SQL question after the exam I had explain my solution.

Q1. Spark architecture.
Add your answer
Q2. Narrow and wide transformations
Add your answer

Q1. More than technology,a senior recruiter asks where you stay which gali you stay,which temple is near by,what your husband do,getting into more personal and final he will ask your janam kundali and tell you...read more
Add your answer

Q1. Senior recruiter will ask more personal questions
Add your answer

First there will be a topic given to you to write an article of length 300-400 words in 15 mins. This article writing is to check your knowledge of English language.
Then there is a 45 mins round test in which 40 questions will be asked.
20 Technical and 20 Programming.
The programming questions will be from C++, and you are required to choose the correct output of the given C++ program.
The technical aptitude questions were medium to hard.

Q1. It's a 1:30 hr round. In this part, there will be 4 coding questions from arrays topic which you can solve with any programming language you know. Along with this, you will have 2 questions from SQL and e...read more
Add your answer

There was total of 40 questions
First 20: Aptitude based topics like time and work, profit and loss, speed and distance
Second 20: Programming MCQs based on C, C++ and python. Task is to guess the correct output and errors.

There were 4 coding questions based on array, 2 SQL queries and one article.
Coding questions were easy for batch 2 but difficult for batch 1. Star patterns are present in batch 1.
SQL queries were easy.
One article (200-300)words. Topics was Google maps.

Q1. Founder came and asked approach I used to solve coding questions in round 2. He then check the output for each question. Then he checked the SQL queries I have written, in which I had write two wrong queri...read more
Add your answer
Q2. He asked me about different approaches to solve a problem
Add your answer
Q3. He asked about the project I had done on Java Full stack.
Add your answer