Faster and better experience!
i
Loyalytics
Filter interviews by
Union All in SQL is used to combine the result sets of two or more SELECT statements, including duplicate rows.
Union All is used to combine the results of multiple SELECT statements into a single result set.
It includes all rows from each SELECT statement, even if there are duplicate rows.
The number of columns and data types must be the same in all SELECT statements being combined.
Example: SELECT column1 FROM table1 UNI
ETL stands for Extract, Transform, Load and ELT stands for Extract, Load, Transform.
ETL involves extracting data from various sources, transforming it to fit into a target schema, and loading it into a data warehouse.
ELT involves extracting data, loading it into a target system, and then transforming it as needed within the target system.
ETL is commonly used in traditional data warehousing scenarios, while ELT is often...
Union all combines the results of two or more SELECT statements into a single result set.
Union all is used to combine the results of multiple SELECT statements into a single result set.
It includes all rows from each SELECT statement, even if there are duplicates.
The number of columns and data types must be the same in all SELECT statements.
Example: SELECT column1 FROM table1 UNION ALL SELECT column1 FROM table2;
Example...
Python code to merge 3 columns and rows in a dataframe.
Use the pandas library in Python to work with dataframes.
Use the concat() function to merge columns and rows.
Specify the axis parameter as 1 to merge columns.
I applied via Naukri.com and was interviewed in Mar 2024. There was 1 interview round.
1hr, subject-oriented and analytical
I applied via LinkedIn and was interviewed in Feb 2023. There were 2 interview rounds.
Loyalytics interview questions for popular designations
I applied via Internshala and was interviewed before Nov 2022. There were 3 interview rounds.
Simple python algo questions
I applied via Job Portal and was interviewed before Sep 2021. There were 4 interview rounds.
First round was aptitude and coding test. Questions were mostly from SQL Python in coding part
They gave us one scenario to make a PPT and present it.
Top trending discussions
I was interviewed in Jan 2025.
1. Explain about framework architecture and from that all questions derived. asked to write diagram and explain the structure.
2. Difference between class variable and instance variable.
3. what is ITestListener why used and when used in framework.
4. architecture of selenium 4 (geckodriver, chromium driver)
5. what is BDD and cucumber, how both are related to.
6. which kind of framework you go, either POM or Page factory for with testNg/junit?
7. asked to write query on sql joins and how you fetch the second lowest of salary from each department.
8. DDL, DML statements.
9. pathquery and query parameters differences(API)
10. How the responses you are validating in automation framework for Json response file.
11. status code of Https
12. serialization and deserialization difference
13. String Builder, String Buffer and String difference? which is better and which is safe to use.
14. Dropdown in selenium how you handle, how to check which is already selected?
15. multiple data provider in testng and how you pass parameter and how you retrive from excel sheet? Asked to write code!
16.what is flaky testing?
17.Asked to write first code of JDBC connecting establishment with framework.
18. Code execution: input ="aabbabcbb"; output = a:3 , b:5, c:1 like this if they give name also it should count. Tip : HashMap you can write the code.
19. Code execution: a[]={1,2,3,4,0,0,0} b={5,6,7} output need to print as remove all 0's from first array and replace 1,2,3,4 with 5,6,7 some crazy questions.
20. Git cmds and CI/CD tool.
1. asked about architecture and where you used oops concepts?
2. abstract class and interfaces
3. select drop down all options
4. find scrape links from webpage write the code
5. asked for writing xpath for any element random website.
6. asked about following-sibling, descendent and preceding-sibling, normalise-space locators.
7. jdbc connection code.
8. API JSON file - how you done validation in automation testing.
I have not pursued a team lead position because I have been focused on honing my technical skills. I have experience working on projects in both waterfall and agile methodologies.
I have chosen to focus on improving my technical skills as an individual contributor rather than taking on a managerial role.
I have worked on projects using both waterfall and agile methodologies, adapting to the needs of the team and project.
...
I was interviewed in Jan 2025.
I was interviewed in Jan 2025.
---
Example Question (Numerical Ability):
Question:
If 15% of a number is 45, what is 30% of that number?
Solution:
1. Find the number:
If 15% of a number is 45, then
\text{Number} = \frac{45}{0.15} = 300.
2. Calculate 30% of the number:
Now, 30% of 300 is
0.30 \times 300 = 90.
Answer:
30% of the number is 90.
---
Additional Example (Simple Interest):
Question:
A bank offers a simple interest rate of 5% per annum on a deposit of Rs.20,000. What will be the interest earned in 3 years?
Solution:
1. Use the simple interest formula:
\text{Simple Interest} = \frac{P \times R \times T}{100}
= Principal amount = Rs.20,000
= Rate of interest = 5%
= Time = 3 years
2. Calculate the interest:
\text{Interest} = \frac{20000 \times 5 \times 3}{100} = 3000.
Answer:
The interest earned in 3 years is Rs. 3000.
1. Quantitative Aptitude
Q: A sum of ₹10,000 is invested at 10% per annum simple interest. What is the interest after 3 years?
A: Interest = (P × R × T) / 100 = (10,000 × 10 × 3) / 100 = ₹3,000
2. Reasoning Ability
Q: If A is the father of B, but B is not the son of A, what is B’s relation to A?
A: Daughter
3. English Language
Q: Choose the correct sentence:
a) She don’t like coffee.
b) She doesn’t like coffee.
A: b) She doesn’t like coffee.
4. General Awareness (Banking GK)
Q: What does RBI stand for?
A: Reserve Bank of India
---
Example Question (Numerical Ability):
Question:
A bank offers a simple interest rate of 6% per annum. If a customer deposits Rs. 25,000 for 4 years, what is the total simple interest earned over that period?
Solution:
1. Identify the formula for Simple Interest (SI):
\text{SI} = \frac{P \times R \times T}{100}
is the principal (Rs. 25,000)
is the rate of interest (6%)
is the time period (4 years)
2. Substitute the values into the formula:
\text{SI} = \frac{25000 \times 6 \times 4}{100}
3. Calculate the interest:
\text{SI} = \frac{25000 \times 24}{100} = \frac{600000}{100} = 6000.
Answer:
The total simple interest earned over 4 years is Rs. 6,000.
---
Additional Example (Logical Reasoning):
Question:
In a sequence of numbers representing daily bank transactions, the amounts follow an arithmetic progression: 105, 115, 125, ... What will be the 8th transaction amount?
Solution:
1. Identify the first term and common difference:
First term,
Common difference,
2. Use the formula for the nth term of an arithmetic progression:
a_n = a_1 + (n - 1)d
3. Substitute :
a_8 = 105 + (8 - 1) \times 10 = 105 + 70 = 175.
Answer:
The 8th transaction amount is 175.
based on 5 interviews
Interview experience
based on 24 reviews
Rating in categories
3-6 Yrs
Not Disclosed
3-5 Yrs
Not Disclosed
Data Scientist
30
salaries
| ₹6 L/yr - ₹22 L/yr |
Data Engineer
12
salaries
| ₹8 L/yr - ₹15 L/yr |
Business Analyst
10
salaries
| ₹6 L/yr - ₹11.8 L/yr |
Senior Data Scientist
7
salaries
| ₹17.5 L/yr - ₹29 L/yr |
Software Developer
5
salaries
| ₹4.2 L/yr - ₹7.8 L/yr |
Mu Sigma
Fractal Analytics
Tiger Analytics
LatentView Analytics