Times Internet Data Research Analyst Interview Questions, Process, and Tips

Q1. What is your current job like
Add your answer
Q2. What tools do you use in regular work
Add your answer
Q3. If you had to expand in India, which city would you expand in
Add your answer

Q1. Accounting golden rules tell me the answer?
Ans. 
Accounting golden rules are basic principles that guide the process of recording financial transactions.
• The three golden rules of accounting are: 1. Debit the receiver, credit the giver 2. Debit what comes in, credit what goes out 3. Debit expenses and losses, credit income and gains

• These rules help ensure that financial transactions are accurately recorded and classified in the accounting system

• For example, when a com...read more
Answered by AI
View 1 more answer
Q2. About yourself and company introduction yourself me
Add your answer
Q3. What is accountancy?
Ans. 
Accountancy is the process of recording, summarizing, analyzing, and reporting financial transactions of a business.
• Involves recording financial transactions

• Summarizing financial data into financial statements

• Analyzing financial information to make business decisions

• Reporting financial results to stakeholders

• Ensures compliance with financial regulations and standards

• Examples: preparing balance sheets, income statements
Answered by AI
Add your answer
Q4. Five journal entries transfer entry
Add your answer

I'm referred so I don't need to do the coding test

Q1. Went through the cv, talk about the projects
Add your answer
Q2. Weakness and strongness, bq questions
Add your answer

Q1. Logistic regression questions, svm, etc
Add your answer

Medium to Hard 4 DSA questions

Q1. CV discussion and question related to python and data science
Add your answer
Q2. Cumulative sum of an array, frequency of each word in a sentence
Ans. 
The question asks about calculating cumulative sum of an array and frequency of each word in a sentence.
• To calculate cumulative sum of an array, we can use a loop and keep adding the current element to a running sum variable.

• To calculate frequency of each word in a sentence, we can split the sentence into words and use a dictionary to keep track of the count of each word.

• We can use built-in functions in programming lan...read more
Answered by AI
Add your answer

Q1. Behavioural Questions
Add your answer
Q2. Leadership principles
Add your answer

Q1. Data Science and SQL round
Add your answer
Q2. Groupby, joins and window functions
Add your answer

Q1. CV discussion and data science question
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Started with project description, deep dive into project
Questions about ML, Statistics
Coding questions for Python, SQL

Q1. 
Stream of Characters Problem Statement
You are provided with a list, DICTIONARY[], which contains a collection of words, along with a stream of characters (queries). The task is to implement a class Chara...read more
Ans. Brute Force
The idea is to use the brute force approach for this problem. At every queried character, we will form strings in a backward direction and will simultaneously check for the string in the ‘DICTIONARY’. If we found the string, then return true. Otherwise, check till the first queried character. If still no string found in ‘DICTIONARY’, return false.
 
Note:
1. For faster search, we can store the strings present...read more
Answered Anonymously
Add your answer
Q2. How do you retrieve the second highest salary from a SQL database?
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Projects
Machine Learning

Q1. Aptitude Questions
Questions about Statistics
Add your answer

Round duration - 60 minutes
Round difficulty - Easy

Behavioral Round
Questions asked about Amazon Leadership Principles

Round duration - 60 minutes
Round difficulty - Easy

Medium Python questions
Medium SQL questions

Q1. Ninja and Mathematics
Ninja is a genius in mathematics. He got an interview call from MIT. During the interview, the professor asked Ninja a challenging question.
Given two integers 'N1' and '...read more
Ans. Remainder Theorm
The idea is to notice that the fractional part repeats only when we have already seen the same remainder before. So, that means we have to store the end index where this repetition starts in some data structure. 
 
We can use Map / HashMap / Dictionary to store the remainder and its associated index while doing division so that whenever the same remainder comes up, we know there is a repeating f...read more
Answered Anonymously
Add your answer
Q2. How can you find the top 2 salaries for each department in SQL?
View 1 more answer

Q1. What was do searching?
Ans. 
Searching is the process of looking for information or data in a systematic way.
• Searching involves identifying a specific topic or question to investigate.

• It can be done through various methods such as online research, surveys, interviews, or experiments.

• Effective searching requires critical thinking, analysis, and evaluation of sources.

• Examples of searching include conducting a literature review for a research paper, ...read more
Answered by AI
Add your answer
Q2. How can explain plan
Ans. 
Explain plan is a tool used to analyze and optimize SQL queries.
• Explain plan shows the steps the database takes to execute a query.

• It helps identify performance bottlenecks and suggests ways to optimize the query.

• The plan shows the order in which tables are accessed, the join methods used, and the indexes utilized.

• It can be accessed using the EXPLAIN keyword in SQL.

• Explain plan can be used to compare the performance of
Answered by AI
Add your answer