Filter interviews by
ETL stands for Extract, Transform, Load. It is a process used to extract data from various sources, transform it into a consistent format, and load it into a data warehouse.
Extract: Data is extracted from multiple sources such as databases, files, APIs, etc.
Transform: Data is cleaned, normalized, and transformed into a consistent format suitable for analysis.
Load: The transformed data is loaded into a data warehouse or...
Primary key uniquely identifies each record in a table, while foreign key establishes a link between two tables.
Primary key ensures each record is unique
Foreign key establishes a relationship between tables
Primary key can be a single column or a combination of columns
Foreign key references the primary key of another table
I applied via Naukri.com and was interviewed before Sep 2022. There were 2 interview rounds.
Top trending discussions
I applied via Naukri.com and was interviewed in Jun 2021. There was 1 interview round.
I applied via Referral and was interviewed before Jul 2021. There was 1 interview round.
posted on 28 Oct 2022
I applied via Recruitment Consulltant and was interviewed before Oct 2021. There were 3 interview rounds.
Not applicable , this was final round
I applied via Referral and was interviewed in Feb 2020. There were 6 interview rounds.
Queue can be implemented using two stacks by maintaining the order of elements in the stacks.
Create two stacks, let's call them stack1 and stack2
When an element is enqueued, push it to stack1
When an element is dequeued, pop all elements from stack1 and push them to stack2
Pop the top element from stack2 and return it as the dequeued element
If stack2 is empty, repeat step 3
To get the front element of the queue, peek the
Left join returns all records from left table and matching records from right table. Full outer join returns all records from both tables.
Left join is used to combine two tables based on a common column.
In left join, all records from the left table are returned along with matching records from the right table.
If there is no match in the right table, NULL values are returned.
Example: SELECT * FROM table1 LEFT JOIN table...
Magic functions are special methods in PHP that start with __. Autoloading is a way to automatically load classes.
Magic functions are used to handle certain events in PHP, such as object creation or property access.
Autoloading allows PHP to automatically load classes when they are needed, without requiring manual includes.
Magic functions can be used in conjunction with autoloading to dynamically load classes or handle
Given three sorted arrays, find common elements.
Create three pointers to traverse each array
Compare the elements at the pointers and move the pointer of the smallest element
If all pointers point to the same element, add it to the result and move all pointers
Repeat until any pointer reaches the end of its array
Check if a number is a power of 2 or not.
A power of 2 has only one bit set in its binary representation.
Use bitwise AND operator to check if the number is a power of 2.
If n is a power of 2, then n & (n-1) will be 0.
I applied via Referral
based on 2 interviews
Interview experience
based on 19 reviews
Rating in categories
Software Engineer
17
salaries
| ₹3 L/yr - ₹11.2 L/yr |
Softwaretest Engineer
8
salaries
| ₹3 L/yr - ₹6.5 L/yr |
Software Developer
7
salaries
| ₹6.4 L/yr - ₹11 L/yr |
Associate Software Engineer
5
salaries
| ₹2 L/yr - ₹9 L/yr |
Senior Software Engineer
5
salaries
| ₹7.7 L/yr - ₹13.2 L/yr |
Amazon Sellers Services
Primus Global Technologies
GAMMON INDIA
Practo