Zeotap India Interview Questions, Process, and Tips

Q1. 1.introduce yourself? 2.how do you rate yourself in Java and SQl? 3.what are the difficult task you faced in last months?
Ans. 
I am a Technical Support Engineer with expertise in Java and SQL.
• I have a strong understanding of Java programming language and SQL database management.

• I have experience in troubleshooting technical issues and providing solutions to customers.

• In the last few months, I faced challenges in resolving complex database issues and optimizing query performance.

• I constantly strive to learn and improve my skills to provide the
Answered by AI
Add your answer
Q2. 4.how do you solve an issue? 5.why you choose this career instead of other one? 6.why are seeking for opportunities?
Add your answer

Q1. 1.write a SQL query to find commissions of more than 12 percent
Ans. 
SQL query to find commissions of more than 12 percent.
• Use the SELECT statement to retrieve data from the table.

• Use the WHERE clause to filter the data based on the commission percentage.

• Use the > operator to filter the data for commissions greater than 12 percent.
Answered by AI
Add your answer
Q2. 2) A)Search for the string “Error” and “ERROR” in Log Level B) Find Logs Between Two Timestamps C) We don’t want to store the username who has accessed the service. Therefore, let’s remove :: [User1] ::...read more
Ans. 
Technical Support Engineer 1 interview question on log analysis
• To search for the string 'Error' and 'ERROR' in Log Level, use a regular expression or a log analysis tool

• To find logs between two timestamps, use a log analysis tool or filter the logs based on timestamp

• To remove the username from each log line, use a regular expression or a log analysis tool
Answered by AI
Add your answer
Q3. 3.Script to convert CSV to json
Ans. 
Script to convert CSV to json
• Use a CSV parsing library like csvtojson or papaparse

• Loop through the CSV data and convert each row to a JSON object

• Write the JSON data to a file or return it as a string
Answered by AI
Add your answer

Q1. 1.what is your day to day activities
Add your answer
Q2. 2.do you have API calls tool experience
Ans. 
Yes, I have experience with API calls tools.
• I have worked with various API tools such as Postman, Insomnia, and Swagger.

• I am familiar with RESTful APIs and have experience in making GET, POST, PUT, and DELETE requests.

• I have also worked with API documentation and testing.

• I am comfortable with troubleshooting API issues and providing solutions.
Answered by AI
Add your answer
Q3. 3.what kind of db your comfortable
Add your answer
Q4. 4.some user scenario based questions
Add your answer
Q5. 5.how do you interact with client
Ans. 
I interact with clients by actively listening to their concerns, providing clear and concise solutions, and following up to ensure satisfaction.
• Listen actively to client concerns

• Provide clear and concise solutions

• Follow up to ensure satisfaction

• Maintain a professional and courteous demeanor

• Communicate effectively through various channels (phone, email, chat)

• Empathize with clients and understand their perspective
Answered by AI
Add your answer

Q1. What i did Roles and responsibilities Previous projects
Add your answer
Q2. Java dsa databasesNetworking
Add your answer

1:1 coding and dsa
Tech discussion

Q1. Networking Databases
Add your answer

Q1. About compny Why i am looking for change
Add your answer

Dsa dbms questions. medium lc level

It contains two easy medium coding questions and a SQL question.

Q1. An interviewer will be there and ask two medium questions.
Add your answer

Q1. This round will be on hackerrank and your code should pass all the test cases.
Add your answer