O

Opentext

SWE (Software Engineer)

Interview Date

October 23, 2023

Result

Selected

Difficulty

Medium

Rounds

3 rounds

Drive Type

Full-Time

Topics asked

Data Structures (StringWindow)AlgorithmsPuzzlesSQL (joinsquery optimizationtable creation)RecursionOOPsRESTful API DesignSpring BootDependency InjectionGitJava (Integer vs. Integer.valueOf)Behavioral

Detailed experience

Role: SWE (Software Engineer)

College: Not Specified

Interview Date: October 23, 2023

Interview Type: Full-Time

Result: Selected

Difficulty: Medium

Rounds: 3 rounds

Topics Asked: Data Structures (String, Window), Algorithms, Puzzles, SQL (joins, query optimization, table creation), Recursion, OOPs, RESTful API Design, Spring Boot, Dependency Injection, Git, Java (Integer vs. Integer.valueOf), Behavioral

Experience:

This candidate interviewed for an SWE role in Hyderabad. The total interview process took 2-3 days, and the candidate received a job offer.

Technical Round-1:
This round included several coding and conceptual questions.

  • Coding: Print K non-repeating characters in a String.
  • Coding: Print the maximum length of a window with all unique characters.
  • Puzzle: The Two Ropes Puzzle (how to measure 45 minutes using two identical wires).
  • Discussion on projects and the tables used within them.
  • SQL: Write a SQL query using joins.
  • Coding: Reverse a number using recursion.
  • OOPs: Explain OOPs concepts with a sample program.

Technical Round-2:
This round focused on API design, advanced coding, and framework-specific knowledge.

  • API Design: Write a RESTful API to retrieve information about a department and employees.
  • Coding: Given a list of numbers from 1 to N, but two numbers are replaced with 0. Find those two numbers.
  • Spring Boot: How to initialize a static variable using Spring Boot startup.
  • Spring Boot: Circular bean dependency.
  • Spring Boot: Dependency Injection.
  • Spring Boot: `@Value` annotation.
  • Project: Asked if any ORM framework was used in the project and to explain the project at a high level.
  • Git: `git stash` command.
  • Java: Difference between `new Integer()` and `Integer.valueOf()`.
  • SQL: Two questions, one on creating a new table and another on optimizing an existing query.

Managerial Round:
This round primarily involved typical behavioral questions.

Posted on - 13 Nov 2025
OpenText Interview Experience - SWE (Software Engineer) | OAHelper