Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Ksolves India Limited Team. If you also belong to the team, you can get access from here

Ksolves India Limited Verified Tick

Compare button icon Compare button icon Compare

Filter interviews by

Ksolves India Limited Azure Data Engineer Interview Questions and Answers

Updated 3 Jun 2023

Ksolves India Limited Azure Data Engineer Interview Experiences

1 interview found

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I appeared for an interview in May 2023.

Round 1 - Technical 

(1 Question)

  • Q1. Cte vs subQuery Stored Procedure vs Functions in SQL Left outer join Pyspark optimisation DIA in azure data factory
  • Ans. 

    CTE is used to create temporary result sets, stored procedures are reusable blocks of code, left outer join combines rows from two tables based on a related column

    • CTE (Common Table Expression) is used to create temporary result sets that can be referenced within a SELECT, INSERT, UPDATE, or DELETE statement.

    • Stored Procedures are reusable blocks of code that can be executed with a single call. They can accept input para...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. 2 python and 1 sql questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep hustling.

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

6 Questions

  • Q1. Tell something about yourself
  • Ans. 

    I am a software engineer with 5 years of experience in developing web applications using Java and JavaScript.

    • I have a Bachelor's degree in Computer Science.

    • I am proficient in Spring Framework and AngularJS.

    • I have worked on projects involving RESTful APIs and microservices architecture.

    • I am a quick learner and enjoy working in a team environment.

  • Answered by AI
  • Q2. Why do you want to join this company?
  • Ans. 

    I am impressed with the company's innovative approach and commitment to excellence.

    • I have researched the company and its products extensively and am excited about the potential for growth and development.

    • I am impressed with the company's reputation for innovation and cutting-edge technology.

    • I believe that the company's commitment to excellence aligns with my own values and goals.

    • I am excited about the opportunity to wo...

  • Answered by AI
  • Q3. What are your future plans?
  • Ans. 

    My future plans include continuous learning, honing my skills, and contributing to the growth of the company.

    • I plan to attend relevant conferences and workshops to stay updated with the latest technologies.

    • I want to work on challenging projects that will help me improve my skills.

    • I aim to become a valuable asset to the company by contributing to its growth and success.

    • I plan to mentor and guide junior developers to hel

  • Answered by AI
  • Q4. Mathematics
  • Q5. Programming
  • Q6. Logic

Interview Preparation Tips

Round: Test
Experience: It was a bit lengthy and I wasn't able to solve all the questions, but the rest was accurately completed by me.
Tips: One needs to know basic programming and logic. The rest is doable. Pay attention to time and the accuracy of your answers.
Duration: 120 minutes
Total Questions: 50

Round: Group Discussion
Experience: A few points were given to us and we had to proceed from there. I gave new ideas as well as new points of view on the already presented ideas. I also encouraged others to participate.
Tips: Don't be too quiet/passive or too loud/active. Let others also talk and don't talk about the same points again & again.
Duration: 15 minutes

Round: HR Interview
Experience: It was a good interview. I felt at ease and myself while talking about me. The CTO of the company was conducting it.
Tips: See the direction in which the interview is going and frame your answers accordingly. Tell them what they want to hear, but don't lie.

Round: Technical Interview
Experience: It was a telephonic interview, and the HR team present there was guiding me through it. The questions were easy.
Tips: Be confident while answering the questions. Don't think too much on it, and answer appropriately. Be clear and concise.

General Tips: As I said earlier as well, be yourself and be confident.
Skill Tips: Be adequately prepared on what you prepare for; know the ins and outs of the company you are sitting in for; be confident and clear on what you speak.
Skills: Programming, Logic Building, Common Aptitude, Personality
College Name: IIT Bombay
Motivation: I wanted to do programming which was also in the engineering domain. Hence Altair came as the perfect fit for me.
Funny Moments: I was not able to listen properly to the telephonic interview, but the CTO was impressed with me in the HR interview so he happily guided me through. I also found out that one of the seniors interviewing me was from the same place as that of mine, so we had a small discussion there as well. I felt at ease hence.

Interview Preparation Tips

Round: Resume Shortlist
Experience: My experience with IITB racing for more than 2 years helped me with this process. Additionally, my work as an electronic differential engineer which required development of a detailed vehicle model was more closer to the

College Name: IIT BOMBAY

Interview Preparation Tips

Round: Test
Tips: Screening test is done online and contains objective questions..
Total Questions: Online

Round: Group Discussion
Experience: Shortlisted candidates were divided in groups of 9-10 students for group discussion. GD lasted for about 40 min.
Duration: 40 minutes

Round: Interview
Experience: Technical interview was of about 35 min. There was no hr interview. Questions were related to the projects that the candidate performed during his stay at IIT Roorkee. Two puzzles were also asked. Other questions were based on the answers that the candidate gave to the previous questions.

General Tips: This company looks for people with strong technical aptitude. So do not shy from showing all your projects. In other companies too many projects may lead them to believe that you are more interested in pursuing research and will leave the company soon. This may have a negative effect on other companies. But at Altair it is good to show all your projects, your research publications, any additional courses taken. Along with your technical projects it will be good if you could show them your coding ability. They are looking for technical people with a stint for coding.
College Name: IIT ROORKEE
Motivation: Altair deals with engineering services, product design, and engineering finite element software development (eg. hypermesh, hypermath, etc). The profile for which it takes the new recruits is for engineering software code writer.

Interview Preparation Tips

Round: Test
Experience: Written Test – 50 ppl appeared 15 were shortlisted for interview, 3 were finally selected. Technical interview  mainly based on project and the basics of the subject HR – be pleasing If someone wants to appear for this company. .
Tips: Prepare some common topics such as globalization, reservation in IITs and IIMs, etc.

General Tips: Never let them ask you the points in which you are weak& Always lead the interviewer to the questions that you are expecting.
College Name: IIT BOMBAY

I applied via Naukri.com and was interviewed before Sep 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Problem solving and string processing

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice problem solving questions.

I applied via LinkedIn and was interviewed in Jan 2021. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. I have been questioned on AEM Concepts, Sling Models, schedulers, servlets, OSGI services
  • Q2. Be prepared for most of the concepts in AEM

Interview Preparation Tips

Interview preparation tips for other job seekers - The overall interview experience was very good.

I applied via Company Website and was interviewed in Sep 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Coding and solution architecture

Interview Preparation Tips

Interview preparation tips for other job seekers - It’s one good interview worth to attend
Interview experience
5
Excellent
Difficulty level
Hard
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Referral and was interviewed in Nov 2023. There were 4 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Don’t add your photo or details such as gender, age, and address in your resume. These details do not add any value.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Coding Round, Design Pattern
Round 3 - Technical 

(1 Question)

  • Q1. Coding, Design Pattern
Round 4 - Technical 

(1 Question)

  • Q1. Coding, SOLID, System Design
Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Test was quiet easy and got selected after making 1 question wrong

Round 2 - One-on-one 

(1 Question)

  • Q1. Had this round with the manager and he asked me some logical questions and as I was a fresher no previous experience questions were asked.

Interview Preparation Tips

Interview preparation tips for other job seekers - Brush up OOPS concepts

Ksolves India Limited Interview FAQs

How many rounds are there in Ksolves India Limited Azure Data Engineer interview?
Ksolves India Limited interview process usually has 3 rounds. The most common rounds in the Ksolves India Limited interview process are Technical and Resume Shortlist.
What are the top questions asked in Ksolves India Limited Azure Data Engineer interview?

Some of the top questions asked at the Ksolves India Limited Azure Data Engineer interview -

  1. Cte vs subQuery Stored Procedure vs Functions in SQL Left outer join Pyspark op...read more
  2. 2 python and 1 sql questi...read more

Tell us how to improve this page.

Ksolves India Limited Azure Data Engineer Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

Apisero Interview Questions
4.3
 • 65 Interviews
Zenoti Interview Questions
3.0
 • 42 Interviews
TestingXperts Interview Questions
3.9
 • 41 Interviews
Credera Interview Questions
3.8
 • 40 Interviews
Damco Solutions Interview Questions
3.9
 • 38 Interviews
View all
Software Developer
197 salaries
unlock blur

₹2 L/yr - ₹10.8 L/yr

Senior Software Engineer
47 salaries
unlock blur

₹6.5 L/yr - ₹22 L/yr

Software Engineer
45 salaries
unlock blur

₹4.1 L/yr - ₹12.7 L/yr

Softwaretest Engineer
44 salaries
unlock blur

₹4 L/yr - ₹10 L/yr

Senior Software Developer
40 salaries
unlock blur

₹5 L/yr - ₹14.5 L/yr

Explore more salaries
Compare Ksolves India Limited with

Tekwissen

4.8
Compare

Damco Solutions

3.9
Compare

smartData Enterprises

3.3
Compare

In Time Tec Visionsoft

3.8
Compare
Did you find this page helpful?
Yes No
write
Share an Interview