UAE Exchange Interview Questions and Answers

Q1. Why does Paytm company commit fraud with its agents and why does it not pay the salary of its agents on time? While working in Paytm, why is the salary held and why is the money not given?
Add your answer
Q2. Why is Paytm merchant not heard? Why is customer care number not reachable?
Add your answer
Q3. Talking about salary of 18000, why only ₹10000 is given in Paytm. Why is salary held?
Add your answer
Q4. When will I get my salary? The salary was promised on the 30th but did not come. The salary was promised on the 5th but did not come. Today is the 9th. When will my salary come? Why has my salary been put ...read more
Add your answer
Q5. How can the team leaders and HR at Paytm be so careless? Why is no one's salary being paid? Why is their salary being withheld?
Add your answer

Q1. Salary Expectation
Add your answer
Q2. Work Experience
Add your answer
Q3. Relocation Plans
Add your answer

Codility Test General C# and SQL

Q1. (live coding) Create a class Employees with fields FirstName LastName, DoB, and Gender Return avg age of employees, return avg age by genders
Ans. 
Create a class Employees with fields FirstName LastName, DoB, and Gender. Return avg age of employees and avg age by genders.
• Create a class Employees with fields FirstName, LastName, DoB, and Gender

• Calculate the average age of all employees

• Calculate the average age by genders
Answered by AI
Add your answer
Q2. What design pattern you know
Ans. 
I am familiar with design patterns such as Singleton, Factory, Observer, and MVC.
• Singleton pattern ensures a class has only one instance and provides a global point of access to it.

• Factory pattern creates objects without specifying the exact class of object that will be created.

• Observer pattern defines a one-to-many dependency between objects so that when one object changes state, all its dependents are notified and up...read more
Answered by AI
Add your answer
Q3. SOLID principles
Add your answer
Q4. How to optimize SQL Queries
Ans. 
Optimizing SQL queries involves using indexes, minimizing data retrieval, avoiding unnecessary joins, and optimizing query structure.
• Use indexes on columns frequently used in WHERE clauses

• Minimize data retrieval by selecting only necessary columns

• Avoid unnecessary joins by using EXISTS or IN clauses instead

• Optimize query structure by using appropriate joins and subqueries
Answered by AI
Add your answer
Q5. Which type of Indexes you know
Ans. 
Types of indexes include clustered, non-clustered, unique, composite, and filtered indexes.
• Clustered index: Physically reorders the data in the table based on the index key.

• Non-clustered index: Contains a sorted list of references to the table data rows.

• Unique index: Ensures that no two rows have the same values in the indexed columns.

• Composite index: Index that is created on multiple columns.

• Filtered index: Index that...read more
Answered by AI
Add your answer
Q6. Have you ever read SQL Execution Plan?
Ans. 
Yes, I have read SQL Execution Plans to optimize query performance.
• I have analyzed SQL Execution Plans to identify bottlenecks in queries.

• I have used SQL Execution Plans to optimize query performance by understanding how the database engine executes queries.

• I have made query optimization recommendations based on SQL Execution Plans.

• I have experience with tools like SQL Server Management Studio to view and analyze Execu
Answered by AI
Add your answer
Q7. .NET Framework DI 3th party tools
Add your answer
Q8. Are you familiar with MSUnit, xUnit, nUnit
Add your answer
Q9. Unit Testing libraries (e.g Bogus, Moq..)
Add your answer

Q1. What questions do you have?
Add your answer
Q2. How was your interview's?
Add your answer
Q3. Why you want to change your job?
Add your answer

Q1. Tell me about yourself.
Ans. 
I am a dedicated and detail-oriented business analyst with a strong background in data analysis and problem-solving.
• I have a Bachelor's degree in Business Administration

• I have 5 years of experience in analyzing business processes and identifying areas for improvement

• I am proficient in using data analysis tools such as Excel and SQL

• I have a proven track record of delivering actionable insights to drive business growth
Answered by AI
Add your answer
Q2. What are your reasons for wanting to change your current situation?
Ans. 
I am seeking new challenges and opportunities for growth in my career.
• Seeking new challenges to continue learning and developing skills

• Looking for opportunities for career advancement

• Interested in working in a different industry or with a different team
Answered by AI
Add your answer
Q3. Are you comfortable working in an office environment?
Ans. 
Yes, I am comfortable working in an office environment.
• I have experience working in office environments in my previous roles.

• I am familiar with office protocols and procedures.

• I am comfortable using office software and technology.

• I enjoy collaborating with colleagues in an office setting.
Answered by AI
Add your answer

Q1. What was your previous job role, and what challenges did you face in that position?
Ans. 
I was previously a Business Analyst at a software company.
• Analyzed market trends and competitor data to make strategic recommendations

• Facilitated communication between stakeholders to ensure project alignment

• Developed and implemented data-driven solutions to improve business processes
Answered by AI
Add your answer
Q2. About yourself
Add your answer

Q1. Knn algorithm using python
Ans. 
KNN algorithm is a simple and effective machine learning algorithm for classification and regression tasks.
• KNN stands for K-Nearest Neighbors.

• It is a non-parametric, lazy learning algorithm.

• Works by finding the K closest training examples in feature space to a given input data point.

• Classification: Assign the most common class among the K nearest neighbors.

• Regression: Take the average of the K nearest neighbors' target...read more
Answered by AI
Add your answer
Q2. Some LC problem on suffix and prefix
Add your answer

Q1. Case study on imbalanced dataset
Add your answer
Q2. Evaluation metrics
Add your answer