i
OpenText
Technologies
Filter interviews by
Use SQL JOIN to find common elements from two tables and return results from the first table.
Use INNER JOIN to find common records between two tables.
Example: SELECT a.* FROM TableA a INNER JOIN TableB b ON a.id = b.id;
This query returns all columns from TableA where there is a matching id in TableB.
Ensure that the join condition accurately reflects the common elements you want to compare.
To find the second highest salary, use SQL queries that leverage sorting and distinct values.
Use the 'DISTINCT' keyword to eliminate duplicate salaries.
Sort the salaries in descending order and limit the results.
A common query is: 'SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;'
Alternatively, use a subquery: 'SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM...
Creating an API function to update database info using JSON data involves defining endpoints, parsing data, and executing updates.
Define the API endpoint (e.g., POST /updateRecord).
Use a web framework (e.g., Flask, Express) to handle requests.
Parse the incoming JSON data using libraries (e.g., json in Python).
Validate the data to ensure it meets required formats and constraints.
Connect to the database using an ORM...
Monitoring SOS reports involves tracking system performance, errors, and resource usage to ensure optimal cloud operations.
Utilize cloud monitoring tools like AWS CloudWatch or Azure Monitor to track metrics.
Set up alerts for critical errors or performance degradation.
Regularly review SOS reports for trends in system performance and incidents.
Implement logging solutions (e.g., ELK stack) to analyze logs for troubl...
Java Streams provide a modern way to process sequences of elements, enabling functional-style operations on collections.
Stream Creation: Streams can be created from collections, arrays, or I/O channels. Example: List<String> names = Arrays.asList("Alice", "Bob"); Stream<String> stream = names.stream();
Intermediate Operations: These operations return a new stream and are lazy. Example: stream.filter(nam...
Java offers platform independence, strong community support, and robust security features, making it ideal for various applications.
Platform Independence: Java's 'Write Once, Run Anywhere' capability allows applications to run on any device with a Java Virtual Machine (JVM).
Strong Community Support: Java has a vast community, providing extensive libraries, frameworks, and resources for developers.
Robust Security F...
OOPs (Object-Oriented Programming) is a programming paradigm based on objects and classes, promoting code reusability and modularity.
Encapsulation: Bundling data and methods that operate on the data within one unit (e.g., a class).
Inheritance: Mechanism to create a new class from an existing class, inheriting attributes and methods (e.g., a 'Dog' class inheriting from an 'Animal' class).
Polymorphism: Ability to pr...
Java is a statically typed, compiled language, while Python is dynamically typed and interpreted, leading to different use cases and performance.
Typing: Java is statically typed (e.g., int x = 5;), while Python is dynamically typed (e.g., x = 5).
Syntax: Java requires explicit class definitions and semicolons, whereas Python uses indentation and is more concise.
Performance: Java generally offers better performance ...
Exception handling in Java manages runtime errors to maintain normal application flow.
Exceptions are events that disrupt the normal flow of execution in a program.
Java uses try-catch blocks to handle exceptions. Example: try { int result = 10 / 0; } catch (ArithmeticException e) { System.out.println(e.getMessage()); }
The 'finally' block can be used to execute code regardless of whether an exception occurred. Exam...
OOP concepts in Java include Encapsulation, Inheritance, Polymorphism, and Abstraction, which enhance code modularity and reusability.
Encapsulation: Bundling data and methods that operate on the data within one unit (class). Example: private variables with public getters/setters.
Inheritance: Mechanism where one class inherits properties and behaviors from another. Example: class Dog extends Animal.
Polymorphism: Ab...
I appeared for an interview in Jan 2025.
I have extensive experience in UX design, with my best project being a mobile app redesign for a major e-commerce company.
Redesigned mobile app interface to improve user experience and increase conversions
Conducted user research and usability testing to inform design decisions
Collaborated with cross-functional teams to implement design changes
Resulted in a 20% increase in user engagement and a 15% increase in conversio...
I evaluate the success of a project by analyzing user feedback, metrics, and meeting project goals.
Collect and analyze user feedback through surveys, interviews, and usability testing
Track key metrics such as user engagement, conversion rates, and task completion
Compare project outcomes to initial goals and objectives
Iterate on design based on feedback and data to improve user experience
My approach to a design task involves research, ideation, prototyping, testing, and iteration.
Conduct thorough research to understand user needs and goals
Generate ideas through brainstorming and sketching
Create prototypes to visualize concepts and gather feedback
Test prototypes with users to identify usability issues
Iterate on designs based on feedback and data
One of the most valuable design experiences I had recently was leading a redesign project for a mobile app.
Led a redesign project for a mobile app, involving user research, wireframing, prototyping, and usability testing
Collaborated closely with cross-functional teams to gather feedback and iterate on designs
Implemented user-centered design principles to improve overall user experience and increase user engagement
Design a test with a clearly outlined problem; you need to sketch your ideas and thoughts within one hour.
I designed a user-friendly mobile app for tracking daily water intake.
Focused on intuitive interface for easy input of water consumption
Incorporated visual reminders and progress tracking for motivation
Implemented a feature to set personalized water intake goals
Utilized color-coded visual cues for quick reference
Conducted user testing to gather feedback for improvements
Various scenarios to evaluate UX design skills
User research and persona creation
Wireframing and prototyping
Usability testing and feedback analysis
Accessibility considerations
Collaboration with cross-functional teams
Consider error cases in design to ensure user experience is not negatively impacted.
Input validation errors (e.g. incorrect format, missing required fields)
Network errors (e.g. slow or no internet connection)
System errors (e.g. server downtime, database errors)
User errors (e.g. accidental deletion, incorrect actions)
Security errors (e.g. unauthorized access, data breaches)
I possess strong communication skills, a user-centered approach, and a proven track record of delivering successful UX designs.
Strong communication skills demonstrated through effective collaboration with cross-functional teams
User-centered approach evident in my portfolio showcasing intuitive and user-friendly designs
Proven track record of delivering successful UX designs, as evidenced by positive user feedback and in...
A designer should understand various strategies to effectively solve design problems.
User research and testing
Information architecture
Wireframing and prototyping
Visual design principles
Collaboration with stakeholders
OpenText products are a suite of enterprise software solutions for content management, digital experience, and business process automation.
OpenText Content Suite for managing enterprise content
OpenText Experience Suite for creating personalized digital experiences
OpenText Process Suite for automating business processes
OpenText Documentum for managing documents and records
OpenText Media Management for digital asset mana...
I have extensive experience with designing and optimizing workflows to improve user experience.
Designed workflows for e-commerce platforms to streamline the checkout process and increase conversion rates
Optimized workflows for mobile applications to enhance user engagement and retention
Conducted user research to identify pain points in existing workflows and proposed solutions for improvement
I appeared for an interview in Jun 2025, where I was asked the following questions.
Use SQL JOIN to find common elements from two tables and return results from the first table.
Use INNER JOIN to find common records between two tables.
Example: SELECT a.* FROM TableA a INNER JOIN TableB b ON a.id = b.id;
This query returns all columns from TableA where there is a matching id in TableB.
Ensure that the join condition accurately reflects the common elements you want to compare.
To find the second highest salary, use SQL queries that leverage sorting and distinct values.
Use the 'DISTINCT' keyword to eliminate duplicate salaries.
Sort the salaries in descending order and limit the results.
A common query is: 'SELECT DISTINCT salary FROM employees ORDER BY salary DESC LIMIT 1 OFFSET 1;'
Alternatively, use a subquery: 'SELECT MAX(salary) FROM employees WHERE salary < (SELECT MAX(salary) FROM empl...
Creating an API function to update database info using JSON data involves defining endpoints, parsing data, and executing updates.
Define the API endpoint (e.g., POST /updateRecord).
Use a web framework (e.g., Flask, Express) to handle requests.
Parse the incoming JSON data using libraries (e.g., json in Python).
Validate the data to ensure it meets required formats and constraints.
Connect to the database using an ORM (e.g...
I applied via Approached by Company and was interviewed in Sep 2024. There were 4 interview rounds.
It was medium, I was able to solve
It was a difficult one from leetcode and modified on the basis on the go, I was able to solve with some hints
It was a difficult one and from leetcode and modified during the begining. I was partially able to solve. But the the Interviewer was expecting some exact answer, which might not interest him.
I appeared for an interview in Mar 2025, where I was asked the following questions.
I appeared for an interview in May 2025, where I was asked the following questions.
I manage cloud infrastructure, optimize deployments, and ensure system reliability in a dynamic environment.
Oversee cloud infrastructure management, including AWS and Azure services.
Implement CI/CD pipelines to streamline application deployment, reducing deployment time by 30%.
Monitor system performance and troubleshoot issues, achieving 99.9% uptime.
Collaborate with development teams to optimize cloud resource usage, ...
Monitoring SOS reports involves tracking system performance, errors, and resource usage to ensure optimal cloud operations.
Utilize cloud monitoring tools like AWS CloudWatch or Azure Monitor to track metrics.
Set up alerts for critical errors or performance degradation.
Regularly review SOS reports for trends in system performance and incidents.
Implement logging solutions (e.g., ELK stack) to analyze logs for troubleshoo...
I applied via Campus Placement
Object-Oriented Programming (OOP) in Java focuses on concepts like classes, objects, inheritance, encapsulation, and polymorphism.
1. Classes and Objects: A class is a blueprint for creating objects. Example: 'class Dog { }' creates a Dog object.
2. Inheritance: Allows a new class to inherit properties and methods from an existing class. Example: 'class Puppy extends Dog { }'.
3. Encapsulation: Bundles data and methods th...
Oops concepts in Java refer to Object-Oriented Programming principles like Inheritance, Encapsulation, Polymorphism, and Abstraction.
Inheritance: Allows a class to inherit properties and behavior from another class.
Encapsulation: Bundling data and methods that operate on the data into a single unit.
Polymorphism: Ability of a method to do different things based on the object it is acting upon.
Abstraction: Hiding the imp...
I appeared for an interview in Mar 2025, where I was asked the following questions.
C# is a versatile programming language with features like OOP, LINQ, and async programming, widely used for various applications.
Object-Oriented Programming (OOP): C# supports encapsulation, inheritance, and polymorphism. Example: class and object creation.
LINQ (Language Integrated Query): Allows querying collections in a concise way. Example: var results = from item in collection where item > 10 select item;
Asynchr...
I applied via Naukri.com and was interviewed in Aug 2024. There were 2 interview rounds.
Given input string- This is opentext.
OP- sihT si txtetnepo.
Page Object Model is a design pattern used in test automation to create an object repository for web elements on a page.
It helps in separating the test scripts from the web elements, making the code more maintainable and reusable.
Each web page is represented as a class, and the web elements on the page are defined as variables within the class.
Methods are created within the class to perform actions on the web elements,...
Top trending discussions
Some of the top questions asked at the OpenText Technologies interview for experienced candidates -
The duration of OpenText Technologies interview process can vary, but typically it takes about less than 2 weeks to complete.
based on 40 interview experiences
Difficulty level
Duration
based on 1.1k reviews
Rating in categories
Software Engineer
1.1k
salaries
| ₹12.1 L/yr - ₹21 L/yr |
Senior Software Engineer
1.1k
salaries
| ₹22.1 L/yr - ₹40 L/yr |
Associate Software Engineer
416
salaries
| ₹8 L/yr - ₹13.5 L/yr |
Lead Software Engineer
372
salaries
| ₹29.5 L/yr - ₹52 L/yr |
Software Developer
237
salaries
| ₹12.2 L/yr - ₹20 L/yr |
Amdocs
Automatic Data Processing (ADP)
24/7 Customer