- Technical Role: ETL Developer Profile.
- Salary: 7.00 Lacs
Round 1:
This round was a simple cognitive assessment . They evaluate math/logic, verbal, and spatial reasoning skills through this test.
few key pointers for the test.
- Test divided into 2 parts.
- 1st Part - 22 minutes - 50 MCQ’s - Aptitude (problem solving & Calculations)/Logical Reasoning/English/Analytical skills….There is no negative marking, so attempt all questions.
- 2nd Part - Personality-based questionnaire - No Time Limit….no negative marking.
There is a cut-off to be met for proceeding ahead.
Round 2:
This round was a technical 1 round. The Interviewer was very friendly.
whole interview Process:
1.Give me your Introduction.
2.Asked to describe some projects which I mentioned in my resume.
3. which libraries have you used during your android projects.
4. which programming language you used in android development.
5.The interviewer told me to share my screen and asked some SQL queries.
6.write SQL query to get the duplicate values from the table.
7.write SQL query to show how to use LEFT JOIN in SQL by taking any two tables.
8.write a SQL query to fetch name starting with the letter 'a'.
9. Write a program to check whether the given character array is palindrome or not.
Round 3:
This round was a technical 2 round.
whole interview Process:
1.Tell me about yourself.
2.Describe the role for which you are sitting on the interview.
3.Difference between outer join and inner join.
4. what is left and right outer join.
5.how do we select which table is going to be left table and which table is going to be right in left and right join.
6.what do you know about API Integration.
7.which API's you used during your project's development.
8. I have used payment gateway in my application so the interviewer asked to me to explain the whole process to integrate payment gateway SDK.
9.what is the get and post method.
10.what is the difference between rest and soap API.
11.format of responses we usually get from web services.
Note: My Interview gone fine but unfortunately not got selected.
Comments
Post a Comment