Mphasis ETL Developer Interview Questions and Answers

Q1. Basic Question Answer
Add your answer
Q2. Basic SQL , SNWOFLAKE AND ETL Concepts
Add your answer

It's an assignment for apti, verbal

Q1. It's like an what are u mentioned in resume skills.
Add your answer

Q1. Just like interaction with candidate like personal details.
Add your answer

Q1. Run time polymorphism code
Add your answer
Q2. Linked list code
Add your answer
Q3. Deep copy shallow copy differences
Ans. 
Deep copy creates a new copy of an object with its own unique memory space, while shallow copy creates a new object that references the same memory locations as the original object.
• Deep copy duplicates all nested objects, while shallow copy only duplicates the references to nested objects.

• Deep copy ensures that changes to the copied object do not affect the original object, while shallow copy may lead to unintended sid...read more
Answered by AI
Add your answer

Q1. More deep questions about polymorphism code
Add your answer
Q2. Code for interchange of strings without strcpy
Ans. 
Use a loop to swap characters of two strings without using strcpy function.
• Create two arrays of characters to store the strings

• Use a loop to iterate through each character of the strings and swap them

• Ensure to handle cases where strings have different lengths
Answered by AI
Add your answer

Aptitude, core concepts and a code

Q1. What is the one thing you learnt from college club?
Ans. 
I learned the importance of teamwork and collaboration from my college club.
• Developed strong communication skills by working with diverse group of individuals

• Learned how to delegate tasks effectively to achieve common goals

• Gained experience in problem-solving and conflict resolution through group projects
Answered by AI
Add your answer
Q2. What is the one thing you want to expereince?
Ans. 
I want to experience living in a different country and immersing myself in a new culture.
• Traveling to a foreign country and learning about their customs and traditions

• Trying new foods and experiencing different ways of life

• Making friends with locals and exploring the local attractions
Answered by AI
Add your answer

Q1. Difference between relational and non relational dbms
Ans. 
Relational DBMS stores data in tables with predefined relationships, while non-relational DBMS stores data in flexible, schema-less formats.
• Relational DBMS uses structured query language (SQL) for querying data

• Non-relational DBMS can store data in various formats like key-value pairs, document-based, graph databases

• Relational DBMS ensures data integrity through normalization and constraints

• Non-relational DBMS offers be...read more
Answered by AI
Add your answer
Q2. Difference betweeen class,abstract class,interface in python
Ans. 
Class is a blueprint for creating objects, abstract class cannot be instantiated and can have abstract methods, interface is a contract for classes to implement certain methods.
• Class is a blueprint for creating objects with attributes and methods.

• Abstract class cannot be instantiated and can have abstract methods that must be implemented by subclasses.

• Interface is a contract for classes to implement certain methods, bu
Answered by AI
Add your answer
Q3. Project related questions were asked
Add your answer

Q1. What is a comparator?
Ans. 
A comparator is a function that compares two objects to determine their ordering.
• Used in sorting algorithms to determine the order of elements

• Returns a negative value if the first object is less than the second, zero if they are equal, and a positive value if the first object is greater

• Commonly used in Java with the Comparator interface
Answered by AI
Add your answer
Q2. What is reentrant lock?
Ans. 
A reentrant lock is a synchronization primitive that allows a thread to re-enter a critical section it already holds.
• Prevents deadlock by allowing a thread to acquire the lock multiple times

• Each lock acquisition must be followed by a corresponding release

• Commonly used in multi-threaded programming to protect shared resources
Answered by AI
Add your answer

Database Management system SQL and PlSQL

Database Base Management system SQL and PlSQL

Database Management system

Database Management system

Database Management system

Database Management system

Database Base Management system

Q1. Database Management system
Add your answer
Q2. SQL and PlSQL Mango Data And Manu Database Management system
Add your answer
Q3. C Language and C++Language and Java
Add your answer
Q4. Data Analysis and Data entry
Add your answer
Q5. DBMS C,C++ Java Data Entry Ms Excel Ms Word Ms PP
Add your answer

Q1. How to sync primary and standby?
Ans. 
Primary and standby databases can be synced using Data Guard in Oracle.
• Configure Data Guard on primary and standby databases

• Enable redo transport services

• Monitor and resolve any synchronization issues

• Perform switchover or failover when necessary
Answered by AI
Add your answer
Q2. Performance tuning?
Add your answer

Q1. Why you want to change the job?
Ans. 
Seeking new challenges and growth opportunities in a dynamic environment.
• Looking for new challenges to enhance my skills and knowledge

• Seeking growth opportunities for career advancement

• Interested in working in a more dynamic and innovative environment
Answered by AI
Add your answer
Q2. Expected salary.
Add your answer

Basic core java, reasoning,english

Dsa question of arrays

Q1. Tell me about yourself
Ans. 
I am a passionate software developer with experience in Java, Python, and web development.
• Experienced in Java, Python, and web development technologies

• Strong problem-solving skills

• Team player with excellent communication skills
Answered by AI
Add your answer
Q2. Stacks and queues
Add your answer
Q3. Time complexity
Add your answer