i
PowerSchool India
Filter interviews by
I applied via Referral and was interviewed before May 2023. There was 1 interview round.
I would rate myself an 8 in SQL. I have strong knowledge and experience in writing complex queries and optimizing database performance.
I have extensive experience writing complex SQL queries
I am proficient in optimizing database performance
I have worked on various database management systems such as MySQL, SQL Server, and Oracle
I applied via Job lever and was interviewed before Sep 2021. There were 2 interview rounds.
Easy leetcode code 2 questions , HTML5 css javascript simple screen design
posted on 27 Jul 2021
I appeared for an interview in Feb 2021.
I appeared for an interview before May 2021.
Round duration - 60 Minutes
Round difficulty - Easy
It was an coding round
Compute the skyline of given rectangular buildings in a 2D city, eliminating hidden lines and forming the outer contour of the silhouette when viewed from a distance. Each building is ...
Compute the skyline of given rectangular buildings in a 2D city, eliminating hidden lines and forming the outer contour of the silhouette.
Iterate through the buildings and create a list of critical points (x, y) where the height changes.
Sort the critical points based on x-coordinate and process them to form the skyline.
Merge consecutive horizontal segments of equal height into one to ensure no duplicates.
Return the fin...
You need to determine all possible paths for a rat starting at position (0, 0) in a square maze to reach its destination at (N-1, N-1). The maze is represented as an N*N ma...
Find all possible paths for a rat in a maze from source to destination.
Use backtracking to explore all possible paths in the maze.
Keep track of visited cells to avoid revisiting them.
Recursively try moving in all directions (up, down, left, right) until reaching the destination.
Return a list of strings representing valid paths sorted in alphabetical order.
Round duration - 30 Minutes
Round difficulty - Easy
It was an HR round with some general questions. it was just for formality.
Tip 1 : Stay focused
Tip 2 : Practice coding questions.
Tip 3 : View previous interviews of the companies
Tip 1 : Don't lie on resume
Tip 2 : Just write in format that is catchy
I applied via LinkedIn and was interviewed before May 2021. There were 2 interview rounds.
var, let, and const are all used to declare variables in JavaScript, but they have different scoping rules and behaviors.
var has function scope and can be redeclared and reassigned
let has block scope and can be reassigned but not redeclared
const has block scope and cannot be reassigned or redeclared
Use const for values that won't change, let for values that will, and avoid var
CSS box model defines the layout of elements on a webpage. Padding and margin can apply to block-level elements but not to inline elements.
CSS box model consists of content, padding, border, and margin around an element.
Padding adds space inside the border of an element.
Margin adds space outside the border of an element.
Padding and margin can apply to block-level elements like <div> but not to inline elements lik
Arrow functions are shorter syntax for writing function expressions.
Arrow functions do not have their own 'this' keyword.
Arrow functions cannot be used as constructors.
Arrow functions do not have the 'arguments' object.
Arrow functions are more concise and easier to read.
Regular functions are better for methods and constructors.
JavaScript asynchronous model allows non-blocking code execution by using callbacks and promises.
JavaScript uses an event loop to handle asynchronous operations.
Callbacks are functions passed as arguments to other functions and executed when the operation is complete.
Promises are objects that represent the eventual completion or failure of an asynchronous operation.
Async/await is a newer syntax that allows writing asyn...
I applied via Walk-in and was interviewed in Jun 2024. There was 1 interview round.
Python technical SQL basic
I applied via Naukri.com and was interviewed before Oct 2023. There was 1 interview round.
Check if a string is the same forwards and backwards
Iterate through the string from both ends and compare characters
Use built-in functions like reverse() to check for palindrome
Ignore spaces and punctuation when checking for palindrome
I applied via Job Portal and was interviewed before Nov 2023. There were 3 interview rounds.
Use a user table with a column for user type (free, gold, platinum)
Create a user table with columns for user ID, name, email, user type
Use a separate table for user types with columns for type ID and type name
Establish a one-to-many relationship between user and user type tables
Example: user table - user_id, name, email, type_id; user_type table - type_id, type_name
High-level design for a live rank dashboard for a live test with millions of users.
Use a scalable architecture to handle millions of users concurrently.
Implement real-time data processing to update ranks dynamically.
Utilize caching mechanisms to improve performance and reduce load on the database.
Design a user-friendly interface with intuitive data visualization.
Include features for filtering, sorting, and searching to
posted on 17 Jul 2023
I applied via Recruitment Consulltant and was interviewed before Jul 2022. There were 2 interview rounds.
let is mutable and can be reassigned, const is immutable and cannot be reassigned
let allows reassignment of values, const does not
const must be initialized with a value, let can be declared without a value
const is block-scoped, let is function-scoped
Closures are functions that have access to variables from their containing scope even after the parent function has finished executing.
Closures allow functions to maintain access to variables from their parent scope
They are created when a function is defined within another function
Closures are commonly used in event handlers and callbacks
typeof null returns 'object' in JavaScript.
typeof null is 'object' in JavaScript
This is a historical bug in JavaScript that has not been fixed for backward compatibility
Example: console.log(typeof null) will output 'object'
Finding palindrome strings in an array of strings.
Iterate through each string in the array.
For each string, check if it is equal to its reverse to determine if it is a palindrome.
Store palindrome strings in a separate array or print them out.
Debouncing is a technique used to limit the rate at which a function is called.
Debouncing is used to prevent multiple rapid calls to a function, typically in response to user input.
It involves setting a delay before allowing the function to be called again.
Example: Debouncing a search input field to only trigger the search function after the user has stopped typing for a certain period.
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Senior Software Engineer
136
salaries
| ₹10.2 L/yr - ₹32 L/yr |
Software Engineer
103
salaries
| ₹5.5 L/yr - ₹21.8 L/yr |
Technical Support Engineer
91
salaries
| ₹4.2 L/yr - ₹10 L/yr |
Software Engineer2
54
salaries
| ₹13 L/yr - ₹23 L/yr |
Product Manager
49
salaries
| ₹19 L/yr - ₹40 L/yr |
BYJU'S
Whitehat jr
Unacademy
Extramarks Education