Gazelle Information Technologies Software Engineer Trainee Interview Questions and Answers

Coding Test consists of 3 Problem Question (2 Logical questions and 1 SQL Query ) and Around 20 MCQS
Platform - CoderByte

30 Aptitude Question
3 Mail Writing Question

Q1. Explain 1st Problem Solved in Coding Test. Optimize it.
Add your answer
Q2. Explain 2nd Problem Solved in Coding Test. I failed 1 test case in 1st round which was told to solve again.
Add your answer
Q3. Explain 3rd Question based on SQL Query.
Add your answer
Q4. Write a code to Reverse Digits.
View 1 more answer
Q5. A problem question for solving a SQL Query.
Add your answer

Coding Test was on Coderbyte. Consisted 4 questions. 1 coding and 3 of web developement.

Q1. General HR questions.
Add your answer

Q1. General Techinal questions
Add your answer

Q1. Spark architecture.
Add your answer
Q2. Narrow and wide transformations
Add your answer

Coding test duration is 30 to 40 min
on paper pen and topic is simple like related to string,pattern and number's

Q1. Introduction about yourself
Add your answer
Q2. Salary expectation
Add your answer

Q1. Related to the basic of html css and js
Add your answer
Q2. Ask run time short code and explanation
Add your answer

Q1. About yourself and other
Add your answer
Q2. All about company your expectation and salary disscuced
Add your answer

Q1. Strecture of sql statement
Ans. 
SQL statements are used to interact with databases by performing operations like querying, updating, and deleting data.
• SQL statements are made up of keywords like SELECT, INSERT, UPDATE, DELETE, etc.

• They are structured in a specific order, with clauses like WHERE, ORDER BY, GROUP BY, etc.

• Tables are referenced using their names, and conditions are specified to filter data.

• Joins can be used to combine data from multiple
Answered by AI
Add your answer

Q1. Automation testing with testing tools
Ans. 
Automation testing with testing tools involves using software to execute tests and compare actual results with expected results.
• Automation testing saves time and effort compared to manual testing

• Testing tools like Selenium, Appium, and TestComplete are commonly used for automation testing

• Automation testing can be used for regression testing, load testing, and performance testing

• Automation testing requires programming s...read more
Answered by AI
Add your answer
Q2. Integration with automation Devops process
Ans. 
Integration with automation DevOps process is crucial for efficient software testing.
• Automation testing tools can be integrated with DevOps tools like Jenkins, Git, and Docker.

• Continuous integration and continuous delivery (CI/CD) pipelines can be set up for automated testing.

• Test cases can be triggered automatically with each code commit or deployment.

• Test results can be reported back to the development team for quick...read more
Answered by AI
Add your answer

Q1. What programming language are you most proficient?
Ans. 
I am most proficient in Java.
• Extensive experience in developing applications using Java

• Strong understanding of object-oriented programming principles

• Familiarity with popular Java frameworks like Spring and Hibernate
Answered by AI
Add your answer
Q2. .NET, Angular and Sql Server
Add your answer

Q1. How would you design a system that needs to handle million of records
Ans. 
I would design a system using scalable architecture, efficient data storage, and optimized query processing.
• Utilize a distributed database system like Cassandra or Hadoop for storing large volumes of data

• Implement data partitioning and sharding to distribute the data across multiple servers

• Use indexing and caching mechanisms to optimize query performance

• Employ load balancing techniques to evenly distribute incoming req...read more
Answered by AI
Add your answer

Q1. Questions was based on SQL
Add your answer
Q2. SQL queries and joins and
Add your answer