Ignite Intern interview experience Real time questions & tips from candidates to crack your interview
Data Analyst
Ignite Intern
1 rounds | 5 Coding
problems
Selected Interview preparation journey
Journey
I started my journey by getting admission in DTU. After exploring different courses and trainings, I finally decided to start learning about Data analyst, for this I took a course from coding ninjas. The course help me in making some good projects that help me a lot in cracking the internship.
Application story
I applied for the job through their LinkedIn page, and after a few days, I received an email confirming my shortlisting for the interview.
Why selected/rejected for the role?
I was selected as I had answer almost all the questions asked by the interviewer in a detailed way. Also I think they were impressed by my strong analytical skills, proficiency in data tools like Excel, SQL, and Python, and ability to interpret and visualize data effectively.
Preparation
Duration: 0.5 month
Topics: Basic concepts of Python, Machine Learning Concepts, SQL, Excel, Tableau, Power BI
Tip 1 : Practice basic questions of coding like write a program for table of 5.
Tip 2 : Practice SQL query questions.
Tip 3 : Learn Excel from basic to advance.
Application process
Where: Linkedin
Eligibility: 7 CGPA, (Stipend: 10k per month)
Tip 1: Add at least 2 projects.
Tip 2: Don't put irrelevant information in the resume.
Tip 3: The resume should be clean and crisp.
Interview rounds
01
Round
Medium
Video Call
Duration45 minutes
Interview date14 May 2024
Coding problem5
In this round the interviewer gave me 2 coding questions, 1-2 SQL query questions, and asked some concepts from Microsoft excel.
1. Linear Search
Easy
0/40
Asked in companies
Given an array, arr of n integers, and an integer element x, find whether element x is present in the array.
Problem approach
Iterate over all the elements of the array and check if it the current element is equal to the target element. If we find any element to be equal to the target element, then return the index of the current element. Otherwise, if no element is equal to the target element, then return -1 as the element is not found
2. Check Palindrome
Easy
0/40
Asked in companies
You are given a string s. Write a program to determine if the string is a palindrome
Problem approach
Create two utility functions to get the first and last position of characters present in the string.
Start traversing the string, and keep finding the position of the first and last characters every time.
If the first and last characters are the same for every iteration and the string is traversed completely, then print YES, otherwise print NO.
3. DBMS
- Write an SQL query to find out how many people work in the "HR" department in an office.
- Write an SQL query to retrieve duplicate records from a table consisting employees data.
4. MS Excel
- What are cell references in Excel?
- What is the CONCATENATE function?
- How do you split text into columns?
- What is the purpose of macros in Excel?
- What is XLOOKUP?
5. Python
- What is the difference between a Set and Dictionary? (Learn)
- Differentiate between List and Tuple?
Here's your problem of the day 
Solving this problem will increase your chance to get selected in this company
Skill covered: Programming
What is recursion?
Choose another skill to practice
Similar interview experiences
SDE - 1
3 rounds | 7 problems
Interviewed by OYO
Selected 
4657 views
0 comments
0 upvotes
SDE - Intern
2 rounds | 3 problems
Interviewed by Amazon
Rejected
961 views
0 comments
0 upvotes
SDE - 1
2 rounds | 5 problems
Interviewed by Meesho
Rejected
6450 views
0 comments
0 upvotes
SDE - 1
3 rounds | 9 problems
Interviewed by Salesforce
Selected 3452 views
0 comments
0 upvotes