Upload Button Icon Add office photos
Engaged Employer

i

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

PowerSchool India Verified Tick

Compare button icon Compare button icon Compare
3.7

based on 258 Reviews

Filter interviews by

PowerSchool India ETL Developer Interview Questions and Answers

Updated 30 May 2024

PowerSchool India ETL Developer Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 13 Feb 2024

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed in Nov 2023. There was 1 interview round.

Round 1 - Technical 

(7 Questions)

  • Q1. 1. Started with the Introduction? Ans; brief about yourself and previous company details along with technology used.
  • Q2. 2. Explain specific role for your the current project End to End and most of the questions from previous project
  • Q3. 3. Snowflake CDC process
  • Q4. 4. I worked on DBT so most of the question on how to transform data, how to implement CDC process , macro's and different layers in DBT tool.
  • Q5. 5. GIT related questions Ans: how Git is connected and explain how you create branch and merge the pull request etc..
  • Q6. 6. Scenario based question on the data load.
  • Q7. 7. Windows functions

Interview Preparation Tips

Topics to prepare for PowerSchool India ETL Developer interview:
  • SQL
  • DBT
  • Cloud
Interview preparation tips for other job seekers - Brush up on your resume points
Be confident on what you explain

Got offer and I am joining.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Company Website and was interviewed in Oct 2024. There were 3 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Basic question of javascript like temporal dead zone, hoisting
  • Q2. Basic of sql and mongo
Round 2 - Technical 

(2 Questions)

  • Q1. Logic bluiding question
  • Q2. 2 leet code quesztion
Round 3 - HR 

(1 Question)

  • Q1. Slaray negotiation
Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Recruitment Consulltant and was interviewed in Jun 2024. There were 2 interview rounds.

Round 1 - Aptitude Test 

Number system,30 min duration

Round 2 - Technical 

(2 Questions)

  • Q1. What is promises
  • Ans. 

    Promises are objects representing the eventual completion or failure of an asynchronous operation.

    • Promises are used in JavaScript to handle asynchronous operations.

    • They can be in one of three states: pending, fulfilled, or rejected.

    • Promises can be chained together using .then() to handle success or failure.

    • They help avoid callback hell and make asynchronous code more readable.

    • Example: const myPromise = new Promise((res

  • Answered by AI
  • Q2. What is html and css
  • Ans. 

    HTML and CSS are languages used for creating and styling web pages.

    • HTML (Hypertext Markup Language) is used for structuring content on a web page.

    • CSS (Cascading Style Sheets) is used for styling the appearance of the content.

    • HTML uses tags like

      for paragraphs and for images.

    • CSS can change colors, fonts, layout, and more on a web page.

Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(1 Question)

  • Q1. Sdlc lifecycle of components and architecture.
  • Ans. 

    SDLC lifecycle involves planning, designing, developing, testing, deploying, and maintaining software components and architecture.

    • SDLC (Software Development Life Cycle) includes phases like planning, designing, coding, testing, and maintenance.

    • Components are designed, developed, tested, and integrated into the overall architecture.

    • Architecture involves defining the structure, behavior, and interactions of software comp...

  • Answered by AI
Round 2 - Technical 

(1 Question)

  • Q1. Role and responsibility my tasks and questions on project

Skills evaluated in this interview

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Campus Placement and was interviewed in Oct 2023. There were 2 interview rounds.

Round 1 - Aptitude Test 

Basic quanti and logicals

Round 2 - Coding Test 

2 test cases were there which we have to passed. solution we had to write in javascript or any js framework

Interview Preparation Tips

Topics to prepare for LearningMate Solutions Software Developer interview:
  • OOPS
  • C#
  • dot net
Interview preparation tips for other job seekers - Interview process was so good. all that just u have to prepare for basics. they would even ask on advance topics just to check how far do you have idea
Interview experience
1
Bad
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
No response

I applied via LinkedIn and was interviewed in Feb 2023. There were 6 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Technical 

(1 Question)

  • Q1. Data structures
Round 3 - Technical 

(1 Question)

  • Q1. System Design fundamentals
Round 4 - Technical 

(1 Question)

  • Q1. System Design questions
Round 5 - Behavioral 

(1 Question)

  • Q1. What do you think about the negative news going around the company
Round 6 - HR 

(1 Question)

  • Q1. Why join this company

Interview Preparation Tips

Interview preparation tips for other job seekers - They took 5 rounds of interview. 3 of them were technical and had easy to moderate level of questions. Rest 2 were more of HR rounds.
After taking 5 rounds, they have the audacity of not even calling back, picking up the calls or providing us with any information. If you are not interested in taking the candidate then why waste their time?

Funniest part is that they are fully aware of what a rubbish organization it is. In the later rounds they talked about cost cutting, negative news around the company, and employee complaints for work life balance. However, they are great at gaslighting as well because they make these sound like employee problems not employer problems.
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Job Fair and was interviewed before Nov 2023. There were 3 interview rounds.

Round 1 - Coding Test 

3 coding question around prime number arrays and strings

Round 2 - Technical 

(2 Questions)

  • Q1. Introduce youself
  • Q2. Question around project and skill in the resume and one coding question to solve
Round 3 - Technical 

(2 Questions)

  • Q1. Question on project and skill in resume
  • Q2. 2 question arouond data structer and algorithm
Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Recruitment Consulltant and was interviewed before Apr 2023. There were 2 interview rounds.

Round 1 - Technical 

(2 Questions)

  • Q1. Practical questions regarding database like sp,trigger,rank
  • Q2. Difference b/w sp and function
  • Ans. 

    Stored procedures are precompiled SQL queries stored in the database, while functions are blocks of code that can be called within SQL queries.

    • Stored procedures are stored in the database and can be called using a specific name.

    • Functions are defined using CREATE FUNCTION and can be called within SQL queries.

    • Stored procedures can have input and output parameters, while functions can only return a single value.

    • Stored pro...

  • Answered by AI
Round 2 - HR 

(1 Question)

  • Q1. Salary negotiations

I applied via Recruitment Consultant and was interviewed in Dec 2020. There were 6 interview rounds.

Interview Questionnaire 

3 Questions

  • Q1. Basic questions on core java,java 8 features, multi threading.
  • Q2. Basic to advanced questions on Hibernate , SQL queries, spring
  • Q3. Questions on architecture,caching, design patterns

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare thoroughly on java,Hibernate,spring,
Prepare well for System design concepts like load balancing , api gateways,caching....

I applied via Company Website and was interviewed before Sep 2019. There were 5 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Why should we hire you?
  • Q2. Why did you leave your last job?

Interview Preparation Tips

Interview preparation tips for other job seekers - My advice is just be honest and rest all will be fine.

PowerSchool India Interview FAQs

How many rounds are there in PowerSchool India ETL Developer interview?
PowerSchool India interview process usually has 1 rounds. The most common rounds in the PowerSchool India interview process are Technical.
What are the top questions asked in PowerSchool India ETL Developer interview?

Some of the top questions asked at the PowerSchool India ETL Developer interview -

  1. 4. I worked on DBT so most of the question on how to transform data, how to imp...read more
  2. 5. GIT related questions Ans: how Git is connected and explain how you create b...read more
  3. 6. Scenario based question on the data lo...read more

Tell us how to improve this page.

People are getting interviews through

based on 1 PowerSchool India interview
Job Portal
100%
Low Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.

Interview Questions from Similar Companies

BYJU'S Interview Questions
3.1
 • 2.2k Interviews
Planet Spark Interview Questions
3.7
 • 354 Interviews
Whitehat jr Interview Questions
3.5
 • 311 Interviews
upGrad Interview Questions
3.7
 • 201 Interviews
Unacademy Interview Questions
3.0
 • 200 Interviews
Vedantu Interview Questions
3.4
 • 190 Interviews
Physicswallah Interview Questions
3.8
 • 182 Interviews
Chegg Interview Questions
4.2
 • 151 Interviews
FOCUS EDUMATICS Interview Questions
3.3
 • 124 Interviews
View all
Senior Software Engineer
133 salaries
unlock blur

₹10.2 L/yr - ₹32 L/yr

Software Engineer
102 salaries
unlock blur

₹5.7 L/yr - ₹20 L/yr

Technical Support Engineer
88 salaries
unlock blur

₹4.2 L/yr - ₹10 L/yr

Associate Software Engineer
50 salaries
unlock blur

₹5 L/yr - ₹10.2 L/yr

Software Engineer2
46 salaries
unlock blur

₹10.2 L/yr - ₹23 L/yr

Explore more salaries
Compare PowerSchool India with

BYJU'S

3.1
Compare

Educomp Solutions

3.5
Compare

MeritNation

3.6
Compare

Toppr

3.4
Compare

Calculate your in-hand salary

Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and get your in-hand salary
Did you find this page helpful?
Yes No
write
Share an Interview