Avanze Technologies Senior Associate Interview Questions and Answers

Q1. Related to MDM and IICs And ETL and SQL
Add your answer

Maths english gK GS And all aptitude

Q1. Define ur birthday eve
Ans. 
Birthday eve is the day before one's birthday, often celebrated with anticipation and excitement.
• It is a time for reflection on the past year and anticipation for the year ahead

• Some people have birthday eve traditions such as a special dinner or gathering with loved ones

• Gifts or surprises may be exchanged on birthday eve as well
Answered by AI
Add your answer

Q1. Define toughest sitiation of your life
Add your answer

Q1. How many year experience
Ans. I have 10 year experience same office
Answered Anonymously
View 3 more answers
Q2. When you will join company?
Ans. If i got selected i need 30 days paper period on my current office
Answered Anonymously
Add your answer
Q3. How much salary you will expected?
Ans. I will expect 20 k salary
Answered Anonymously
Add your answer
Q4. Are u interested to work night shift
Ans. Yes I interested day or night shift
Answered Anonymously
Add your answer
Q5. Are u interested to week end
Add your answer
Q6. Why you resign your current office
Ans. I interested to learn new things that's only reason
Answered Anonymously
Add your answer
Q7. You interested voice or non voice job
Add your answer
Q8. Tell me your interest skills
Ans. I am to work always sir
Answered Anonymously
Add your answer

Q1. Write a embedded C program which will communicate with DB and fetch some data back while using host and indicator varibles.
Ans. 
A C program that communicates with a database and retrieves data using host and indicator variables.
• Use appropriate database libraries and APIs to establish a connection with the database.

• Define host and indicator variables to store the fetched data.

• Write SQL queries to fetch the required data from the database.

• Execute the queries and retrieve the data into the host variables.

• Use the indicator variables to check for an...read more
Answered by AI
View 1 more answer

Q1. Finding the second maximum number in the list
Ans. 
To find the second maximum number in a list, sort the list in descending order and return the second element.
• Sort the list in descending order

• Return the second element in the sorted list
Answered by AI
Add your answer

Q1. Loops in Informatica
Ans. 
Loops in Informatica are used to iterate over a set of data or perform repetitive tasks.
• Loops in Informatica can be implemented using the 'Expression' or 'Router' transformations.

• They are useful for processing multiple rows of data in a mapping.

• Common types of loops include 'While' and 'For' loops.

• Loops can help in performing complex data transformations and validations.
Answered by AI
Add your answer

Q1. What is the reason for change
Add your answer

Based on genral questions and reasoning

Q1. Face to face with genral questions and reasoning questions along with apptitude
Add your answer
Q2. Previous company roles and responsibilities
Add your answer
Q3. How do you Sell a pen to me?
Ans. 
I would highlight the pen's unique features and benefits to show how it can meet your needs.
• This pen has a sleek design that is both stylish and professional.

• It writes smoothly and effortlessly, making it perfect for everyday use.

• The ink is long-lasting and won't smudge or smear, ensuring your writing stays neat and tidy.

• It's also refillable, so you can use it for years to come and save money on buying new pens.

• Overall...read more
Answered by AI
Add your answer

Two coding round in Javascript, first one to right CRUD operation in React.

Second one have to right JS for Flattened Array

Q1. Asking about Salary Structure
Add your answer