GyanDhan Interview Questions and Answers for Freshers

Q1. Basic details, qualification,skills int
Add your answer
Q2. Last salary and expected
Add your answer

Q1. How do you think Business analyst?
Ans. 
Business analysts think analytically and strategically to identify business needs and recommend solutions.
• Business analysts analyze data to identify trends and patterns.

• They work closely with stakeholders to gather requirements and understand business processes.

• They use tools such as SWOT analysis, process flow diagrams, and data modeling to recommend solutions.

• Business analysts communicate effectively to bridge the ga...read more
Answered by AI
Add your answer
Q2. Please tell me about your data analyst experience.
Add your answer
Q3. Do you have any experience on SQL or Python
Ans. 
Yes, I have experience with both SQL and Python.
• I have used SQL to query databases and extract relevant information.

• I have written Python scripts to automate data analysis and reporting tasks.

• I am familiar with using SQLAlchemy in Python for database interactions.

• I have experience with data manipulation and visualization using Python libraries like Pandas and Matplotlib.
Answered by AI
Add your answer

Q1. Data Structure and algorithm
Add your answer
Q2. System design question
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Timing was 9 PM. Platform was not good. Platform was very lagging so overall it was bad experience.

Q1. 
Find the Third Greatest Element
Given an array 'ARR' of 'N' distinct integers, determine the third largest element in the array.
Input:
The first line contains a single integer 'T' representing the numb...read more
Ans. 
Find the third largest element in an array of distinct integers.
• Sort the array in descending order and return the element at index 2.

• Handle cases where the array has less than 3 elements separately.

• Use a set to store distinct elements for efficient processing.
Answered by AI
Add your answer
Q2. 
Longest Palindromic Substring Problem Statement
You are provided with a string STR of length N. The task is to find the longest palindromic substring within STR. If there are several palindromic substring...read more
Ans. 
Find the longest palindromic substring in a given string.
• Iterate through the string and expand around each character to find palindromes

• Keep track of the longest palindrome found so far

• Return the longest palindromic substring
Answered by AI
Add your answer
Q3. 
Ninja and Geometry Problem Statement
In this problem, Ninja is provided with two lines on a 2D plane. The first line 'AB' is determined by two points A and B. The second line 'PQ' is determined by two poi...read more
Ans. 
Calculate the intersection point of two lines on a 2D plane with precision up to six decimal places.
• Implement a function to calculate the intersection point of two lines on a 2D plane

• Handle precision up to six decimal places in the output

• Return -1.000000 -1.000000 if the lines do not intersect

• Ensure the lines 'AB' and 'PQ' are distinct
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Medium

Timing was 9 PM. Platform was not good. Platform was very lagging so overall it was bad experience.

Q1. 
Find the Third Greatest Element
Given an array 'ARR' of 'N' distinct integers, determine the third largest element in the array.
Input:
The first line contains a single integer 'T' representing the numb...read more
Ans. 
Find the third largest element in an array of distinct integers.
• Sort the array in descending order and return the element at index 2.

• Handle cases where there are less than 3 elements in the array.

• Consider edge cases like negative integers and duplicates.
Answered by AI
Add your answer
Q2. 
Longest Palindromic Substring Problem Statement
You are provided with a string STR of length N. The goal is to identify the longest palindromic substring within this string. In cases where multiple palind...read more
Ans. 
Identify the longest palindromic substring in a given string.
• Iterate through each character in the string and expand around it to find palindromes

• Keep track of the longest palindrome found so far

• Return the longest palindromic substring with the smallest start index
Answered by AI
Add your answer
Q3. 
Ninja and Geometry Problem Statement
In this problem, Ninja is provided with two lines on a 2D plane. The first line 'AB' is determined by two points A and B. The second line 'PQ' is determined by two poi...read more
Ans. 
Calculate the intersection point of two lines on a 2D plane with precision up to six decimal places.
• Implement a function to calculate the intersection point of two lines on a 2D plane

• Handle precision up to six decimal places in the output

• Return -1.000000 -1.000000 if the lines do not intersect

• Ensure the lines 'AB' and 'PQ' are distinct
Answered by AI
Add your answer

Round duration - 90 minutes
Round difficulty - Hard

Timing was 9 PM. Platform was not good. Platform was very lagging so overall it was bad experience.

Q1. 
Find the Third Greatest Element
Given an array 'ARR' of 'N' distinct integers, determine the third largest element in the array.
Input:
The first line contains a single integer 'T' representing the numb...read more
Ans. 
Find the third largest element in an array of distinct integers.
• Sort the array in descending order and return the element at index 2.

• Handle cases where the array has less than 3 elements separately.

• Consider using a set to ensure distinct elements in the array.
Answered by AI
View 1 more answer
Q2. 
Longest Palindromic Substring Problem Statement
You are provided with a string STR of length N. The goal is to identify the longest palindromic substring within this string. In cases where multiple palind...read more
Ans. 
Identify the longest palindromic substring in a given string.
• Iterate through the string and expand around each character to find palindromes

• Keep track of the longest palindrome found

• Return the longest palindromic substring with the smallest start index
Answered by AI
Add your answer
Q3. 
Ninja and Geometry Problem Statement
In this problem, Ninja is provided with two lines on a 2D plane. The first line 'AB' is determined by two points A and B. The second line 'PQ' is determined by two poi...read more
Ans. 
Calculate the intersection point of two lines on a 2D plane with precision up to six decimal places.
• Use the formula for finding the intersection point of two lines in 2D space.

• Handle precision issues that may arise due to floating-point arithmetic.

• Return -1.000000 -1.000000 if the lines do not intersect.

• Ensure the lines 'AB' and 'PQ' are distinct.
Answered by AI
Add your answer

Round duration - 90 Minutes
Round difficulty - Easy

Problem solving using SQL questions

Round duration - 90 Minutes
Round difficulty - Easy

A marketing campaign is run, how will you decide metrics to be tracked. Techincaly a KPI round

Q1. In a marketing campaign, how would you decide which metrics to track?
Ans. 
Metrics selection based on campaign objectives, target audience, and key performance indicators.
• Identify campaign objectives and goals

• Consider target audience and their behavior

• Select key performance indicators (KPIs) relevant to the campaign

• Track metrics such as conversion rate, click-through rate, ROI, customer acquisition cost

• Analyze data to measure success and make data-driven decisions
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

Social empathatic fit round