i
Helm360
Filter interviews by
SQL indexing is a technique to improve query performance by creating indexes on columns in database tables.
Indexes are created using CREATE INDEX statement in SQL.
Indexes can be clustered or non-clustered.
Clustered indexes physically reorganize the table to match the index order.
Non-clustered indexes store a separate copy of the indexed columns.
Indexes should be created on columns frequently used in WHERE, JOIN, and OR...
I have 5 years of experience in IT recruitment, specializing in sourcing, screening, and interviewing candidates.
Specialize in sourcing candidates through job boards, social media, and networking events
Skilled in screening resumes and conducting initial phone interviews
Experienced in coordinating interviews between candidates and hiring managers
Proficient in negotiating job offers and closing candidates
Familiar with ap...
Market research analysis, Sales, customer satisfaction
Helm360 interview questions for popular designations
Basic questions like:
1. Star pattern
2. Reverse array
3. Second highest salary
I was interviewed before Jun 2023.
Regression testing is the process of retesting a software application to ensure that new code changes have not adversely affected existing functionality.
Regression testing is performed after code changes to verify that the existing features still work correctly.
It helps in identifying any defects introduced by new code changes.
Automated testing tools are often used for regression testing to save time and effort.
Regress...
Prioritize test cases based on criticality and impact, automate repetitive tests, and focus on high-risk areas.
Prioritize test cases based on criticality and impact
Automate repetitive tests using test automation tools
Focus on high-risk areas to ensure maximum coverage in limited time
I applied via Company Website and was interviewed in Jul 2021. There were 4 interview rounds.
SQL is a programming language used to manage and manipulate relational databases.
SQL stands for Structured Query Language
It is used to create, modify, and query databases
Common SQL commands include SELECT, INSERT, UPDATE, and DELETE
SQL is used in various industries including finance, healthcare, and e-commerce
Joins are used in SQL to combine data from two or more tables based on a related column.
INNER JOIN returns only the matching rows from both tables
LEFT JOIN returns all rows from the left table and matching rows from the right table
RIGHT JOIN returns all rows from the right table and matching rows from the left table
FULL OUTER JOIN returns all rows from both tables
CROSS JOIN returns the Cartesian product of both tables
Developed a predictive model to forecast sales for a retail company
Used historical sales data to train the model
Incorporated external factors such as weather and holidays
Evaluated model performance using metrics like RMSE and MAE
I was interviewed before Feb 2021.
Abstract classes can have implementation while interfaces cannot. Classes can implement multiple interfaces but only inherit from one abstract class.
Abstract classes can have constructors while interfaces cannot
Interfaces can only have method signatures while abstract classes can have both method signatures and implementation
Abstract classes can have access modifiers while interfaces cannot
Classes can implement multipl...
One number is missing from 1 to 100. Find it's value.
Use the formula n(n+1)/2 to find the sum of numbers from 1 to 100
Subtract the sum of numbers given from the sum of numbers from 1 to 100 to find the missing number
The missing number is 5050 minus the sum of given numbers
I was interviewed in Aug 2021.
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.
...
based on 13 interviews
Interview experience
3-6 Yrs
Not Disclosed
7-12 Yrs
Not Disclosed
5-10 Yrs
Not Disclosed
Software Engineer
45
salaries
| ₹3.2 L/yr - ₹10 L/yr |
Senior Software Engineer
27
salaries
| ₹7 L/yr - ₹16 L/yr |
QA Engineer
26
salaries
| ₹5.5 L/yr - ₹8.5 L/yr |
Associate Software Engineer
17
salaries
| ₹3.5 L/yr - ₹6.6 L/yr |
Msbi Consultant
9
salaries
| ₹3.5 L/yr - ₹5 L/yr |
Saviom
Nalashaa Solutions
Accops Systems
Innovapptive