Etech Technology Solutions Interview Questions and Answers

Q1. What is the Look and Say sequence, and how can a program be written to generate the next number in this sequence?
Add your answer
Q2. What is the SQL query to perform a join on two tables and calculate the aggregate sum using the product ID?
Add your answer
Q3. What is the process for writing a Bash script to read and parse a CSV file and print the last character of each line?
Add your answer

Platform: Coderbyte Test. The process is similar to the technical round, except that in the last bash script question, instead of printing the last character, print the third last character of each line.

Q1. Can you tell me about yourself?
Add your answer
Q2. What are the principles of Continuous Integration and Continuous Deployment (CI/CD)?
Add your answer
Q3. What version control tools do you use, and can you explain how you utilize them?
Add your answer
Q4. What is the SQL query to join two tables and use aggregate functions such as SUM and AVG with GROUP BY?
Add your answer
Q5. What is the Bash command to suppress all output and errors?
Add your answer

Q1. Can you tell me about yourself and your family?
Add your answer
Q2. Are you comfortable with the possibility of relocating for the position?
Add your answer
Q3. Would it be acceptable to work shift timings from 6:30 AM to 3:30 PM considering that the client is based in New Zealand?
Add your answer

Difference between online study and offline study

Q1. All types of testing one by one (System, integration, usability, black box, white box)
Add your answer
Q2. Question on gaming like are you a mobile game player or pc or console game player, what's the difference between them.
Add your answer

Q1. Basic Javascript questions were asked like Hoisting, Event Loop, Closure.
Add your answer
Q2. What are semantic tags? << HTML based question
Ans. 
Semantic tags in HTML are specific tags that provide meaning to the content they enclose.
• Semantic tags help search engines and screen readers understand the structure of a webpage.

• Examples of semantic tags include <header>, <footer>, <nav>, <article>, <section>, <aside>, <main>, <figure>, <figcaption>.

• Using semantic tags improves SEO and accessibility of a website.
Answered by AI
Add your answer
Q3. What is currying in js?
Ans. 
Currying is a technique in functional programming where a function with multiple arguments is transformed into a sequence of nested functions, each taking a single argument.
• Currying helps in creating reusable functions and partial application.

• It allows you to create new functions by fixing some parameters of an existing function.

• Example: const add = (a) => (b) => a + b; add(2)(3) will return 5.
Answered by AI
Add your answer
Q4. What is the difference between Map and Filter?
Ans. 
Map is used to transform each element of an array, while Filter is used to select elements based on a condition.
• Map returns a new array with the same length as the original array, but with each element transformed based on a provided function.

• Filter returns a new array with only the elements that pass a provided condition function.

• Example for Map: [1, 2, 3].map(num => num * 2) will result in [2, 4, 6].

• Example for Fi...read more
Answered by AI
Add your answer
Q5. What is the difference between Map and ForEach?
Ans. 
Map creates a new array with the results of calling a provided function on every element, while forEach executes a provided function once for each array element.
• Map returns a new array with the same length as the original array, while forEach does not return anything.

• Map does not mutate the original array, while forEach can mutate the original array.

• Map is more suitable for transforming data and creating a new array, w...read more
Answered by AI
Add your answer
Q6. What is the difference between Authentication and Authorization?
Ans. 
Authentication verifies the identity of a user, while authorization determines the user's access rights.
• Authentication confirms the user's identity through credentials like username and password.

• Authorization determines what actions the authenticated user is allowed to perform.

• Authentication precedes authorization in the security process.

• Example: Logging into a website (authentication) and then accessing specific pages
Answered by AI
Add your answer
Q7. What is the difference between Local storage and Session storage?
Ans. 
Local storage persists even after the browser is closed, while session storage is cleared when the browser is closed.
• Local storage has no expiration date, while session storage expires when the browser is closed.

• Local storage stores data with no limit, while session storage has a limit of around 5MB.

• Local storage data is available across all windows/tabs for that domain, while session storage data is only available wit...read more
Answered by AI
Add your answer

Q1. This was the Final round, it lasted for around 30 mins and the interviewer gave me a coding question to build a Countdown Timer app.
Add your answer

Q1. Basic questions about you, past experiences, why do you want to switch, salary expectations
Add your answer

Q1. What do you know about the role & Company?
Add your answer
Q2. How data analysis and reports are made?
Add your answer
Q3. How will you cross collab with different teams?
Add your answer
Q4. Everything related to past experiences, questions on data management, presentations
Add your answer

Q1. What are the key topics related to Generative AI, specifically focusing on Retrieval-Augmented Generation (RAG) and Large Language Models (LLM)?
Add your answer
Q2. What is your understanding of the existing project and the technology stacks used?
Add your answer

Q1. What has been your contribution to existing work and the technologies used in that context?
Add your answer
Q2. ML, DL, Gen AI implementation and flow
Add your answer
Q3. Python Coding logic and semantics
Add your answer

Q1. What are the existing work challenges you face, and what solutions have you implemented to address them?
Add your answer
Q2. What is your understanding of Generative AI and Natural Language Processing (NLP), and can you provide examples of their use cases?
Add your answer

Q1. All questions related to Process and Tool level and Analysis.
Add your answer

Q1. Performance testing questions
Add your answer

Q1. Loadrunner questions
Add your answer

Q1. Process and Tool level questions
Add your answer

Q1. HTML, CSS fundamentals
Add your answer
Q2. Javascript event loop and array methods
Add your answer
Q3. Javascript coding for operation on object array
Add your answer
Q4. React benefits and Redux implementations
Add your answer
Q5. How to create slice and combine reducers
Add your answer

Q1. Questions based on projects, role, responsibilities and initiative at work place
Add your answer
Q2. How to create and optimize a react application
Add your answer

Q1. Day to day activity of workplace and salary negotiation
Add your answer

Find bug in snippet. Code snippet writing.

Q1. Coding concepts , best practices
Add your answer

Q1. Design pattern and app design
Add your answer

Q1. Project management
Add your answer

Q1. Job profile , Family question
Add your answer

Oriented in sql,java logical question and manual testing they asked about that.

Pass by value &pass by reference

About the project &They suggest one topic in based on us

Q1. Self introduction
Add your answer
Q2. About sql,java, logical question and ressume based questions they asked in technical round also we haven.
Add your answer