TSYS|Total System Services Sdet Automation Test Engineer Interview Questions and Answers

SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

• SCD Type 2 maintains a separate row for each change in data, with a start and end date.

• It requires a surrogate key to uniquely identify each row.

• Informatica provides a built-in SCD Type 2 transformation to implement this technique.

• Example: tracking changes in customer addresses over time.

Multi tasking, multi processing, and multi programming are different approaches to managing tasks in an operating system.

• Multi tasking allows multiple tasks to run concurrently on a single processor.

• Multi processing involves multiple processors running tasks simultaneously.

• Multi programming allows multiple programs to be loaded into memory and executed concurrently.

• Examples of multi tasking operating systems include Wi...read more

Memory allocation refers to the process of assigning memory to programs during runtime.

• Stack allocation is done automatically and is limited in size.

• Heap allocation is done manually and is larger in size.

• Stack memory is used for local variables and function calls.

• Heap memory is used for dynamic memory allocation.

• Memory leaks can occur if heap memory is not properly managed.

Use a shared variable and synchronization mechanisms to ensure natural order printing of numbers.

• Create two threads, one for printing even numbers and the other for printing odd numbers.

• Use a shared variable to keep track of the current number to be printed.

• Implement synchronization mechanisms like locks or semaphores to ensure only one thread can access the shared variable at a time.

• Each thread should check if it is i...read more

Printing a matrix in spiral order

• Start from the first element and print it

• Move in a spiral order towards the center of the matrix

• Repeat until all elements are printed

Thread class and Runnable Interface are used for multithreading in Java.

• Thread class is a predefined class in Java that provides methods to create and control threads.

• Runnable interface is used to define a task that can be executed by a thread.

• Thread class implements Runnable interface.

• Thread class provides more control over threads than Runnable interface.

• Example: Thread t = new Thread(new MyRunnable()); t.start();

• Exa...read more

Linked List is a dynamic data structure while ArrayList is a static data structure.

• Linked List is best for frequent insertion and deletion operations.

• ArrayList is best for frequent access operations.

• Linked List uses more memory than ArrayList.

• ArrayList is faster than Linked List for accessing elements.

• Use Linked List when you need to frequently add or remove elements from the list.

• Use ArrayList when you need to frequen

I am not interested in a career in investment banking.

• I am more interested in a career in software development

• I enjoy problem-solving and creating innovative solutions through coding

• Investment banking does not align with my passion and skill set

I have chosen to apply to J.P. Morgan because of their reputation, global presence, and opportunities for growth.

• J.P. Morgan has a strong reputation in the financial industry.

• They have a global presence with offices in multiple countries.

• The company offers various opportunities for career growth and development.

• J.P. Morgan is known for its innovative technology solutions in the financial sector.

• I am impressed by their ...read more

Yes, I have made a mistake in my previous project.

• I underestimated the complexity of a task and ended up missing the deadline.

• I failed to properly test a feature, resulting in a bug that affected user experience.

• I accidentally deleted an important file without having a backup.

• I misunderstood a requirement and implemented a feature incorrectly.

I have a Bachelor's degree in Business Administration and a Master's degree in Finance.

• Bachelor's degree in Business Administration

• Master's degree in Finance

There are approximately 200,000 ATMs in India.

• As of March 2021, there were around 200,000 ATMs in India.

• The number of ATMs in India has been steadily increasing over the years.

• ATMs are operated by various banks and financial institutions in India.

• The Reserve Bank of India regulates the functioning of ATMs in the country.

Analytics offers a diverse range of career opportunities and aligns with my interests and skills.

• Mining engineering and analytics share common skills such as data analysis and problem-solving.

• Analytics offers a wider range of industries to work in, including finance, healthcare, and technology.

• I have taken courses in data analytics and found it to be a fascinating field with endless possibilities.

• I believe that my back...read more

Ph.D not necessary for Business Analyst role

• Ph.D is not a requirement for a Business Analyst role

• Experience and skills are more important than a Ph.D

• A Ph.D may not provide practical business knowledge

• A Ph.D may not align with the goals of a Business Analyst role

Citi is a leading global bank with a strong reputation for innovation and customer service.

• Citi has a strong global presence with operations in over 160 countries

• Citi is known for its innovative approach to banking, including its mobile app and digital banking services

• Citi has a strong reputation for customer service, consistently ranking highly in customer satisfaction surveys

• Citi offers a wide range of financial prod...read more

Citi bank should set up its offices in major cities like Mumbai, Delhi, and Bangalore.

• Citi bank should consider the economic and political stability of the region.

• The bank should also consider the availability of skilled workforce and infrastructure.

• Major cities like Mumbai, Delhi, and Bangalore have a large customer base and a well-established financial sector.

• Setting up offices in multiple cities can help the bank re...read more