Altimetrik Interview Questions, Process, and Tips

Q1. How to drop duplicated rows from table
Ans. 
Use the DISTINCT keyword in a SELECT statement to remove duplicate rows from a table.
• Use the DISTINCT keyword in a SELECT statement to retrieve unique rows

• Use the GROUP BY clause with appropriate columns to remove duplicates

• Use the ROW_NUMBER() function to assign a unique row number to each row and then filter out rows with row number greater than 1
Answered by AI
Add your answer
Q2. Big query questions
Add your answer

Q1. About your previous experience
Add your answer
Q2. About your achievements
Add your answer

Technical Assessment Test (MCQs) - 30 mins.

Q1. Basic Questions on: 1.Python 2.SQL 3.Spark
Add your answer
Q2. Python: Replace all occurrences of word: "apple" with "froot" and count no.of occurrences of word: "apple" - in a given string (multiple lines) SQL: 1. Retrieve employee details, drawing the maximum salar...read more
Add your answer
Q3. Convert string (multiple lines) to list
Ans. 
Use the split() method to convert a string with multiple lines into a list of strings.
• Use the split() method with the newline character '\n' as the delimiter to split the string into a list of strings.

• Example: 'Hello\nWorld\n' -> ['Hello', 'World']
Answered by AI
Add your answer
Q4. Convert string of multiple lines with 'n' words to multiple arrays of fixed size: k, with no overlap of elements accross arrays.
Ans. 
Convert a string of multiple lines with 'n' words to multiple arrays of fixed size without overlap.
• Split the string into individual words

• Create arrays of fixed size 'k' and distribute words evenly

• Handle cases where the number of words is not divisible by 'k'
Answered by AI
Add your answer

Hackerrank Coding test with MCQ

With the Engineering Manager. Two Coding Problems were given along with Data Structures

With Senior Engineer In Alitmetrik, Coding Problems, Tech Discussion and Data Structures

Q1. Challenges Faced during the previous Employment.
Add your answer

Coding Test with Client-R1, One Problem Solving and few tech questions.

Coding Test with Client-R2, One Problem Solving with Tech Discussions.

Print the unique elements in the unsorted array without sorting it, achieving a time complexity of O(n).

Q1. OOPS questions, SOLID principles, Functional interface, difference between thread wait and join
Add your answer

Hacker Rank Technical Round

30 Mins Java Selenium

Q1. Explain about Career experience
Ans. 
I have over 5 years of experience in testing various software applications, including creating test plans, executing test cases, and reporting bugs.
• Experience in creating test plans and test cases

• Proficient in executing manual and automated tests

• Strong skills in identifying and reporting bugs

• Familiarity with various testing tools and methodologies

• Collaborating with developers and stakeholders to ensure quality software
Answered by AI
Add your answer
Q2. Walkthrough on Framework
Ans. 
Framework walkthrough involves explaining the structure, components, and functionality of the test automation framework.
• Explain the architecture of the framework (e.g. modular, data-driven, keyword-driven, hybrid)

• Discuss the key components such as test scripts, test data, object repositories, and reporting mechanisms

• Describe how the framework handles test execution, result reporting, and error handling

• Provide examples ...read more
Answered by AI
Add your answer