AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
ITC Infotech
Compare
Filter interviews by
ITC Infotech Data Analyst Interview Questions and Answers
ITC Infotech Data Analyst Interview Experiences
4 interviews found
Anonymous
Selected
I applied via AmbitionBox and was interviewed in Nov 2024. There were 4 interview rounds.
(2 Questions)
- Q1. About your self
- Q2. Communication skills
(3 Questions)
- Q1. Programming language
- Q2. What tools do you utilize for data analysis?
- Ans.
I utilize tools such as Excel, Python, SQL, and Tableau for data analysis.
Excel for basic data manipulation and visualization
Python for advanced data analysis and machine learning
SQL for querying databases
Tableau for creating interactive visualizations
- Q3. Pandas numpy seaborn matplot
Data analysis of code in the context of data analysis.
Coding logical question paper.
Rubesh Sekar
(1 Question)
- Q1. How SQL DB works
- Ans.
SQL DB works by storing and managing data in a structured format using tables and relationships.
SQL DB uses tables to store data in rows and columns.
It allows for querying data using SQL commands like SELECT, INSERT, UPDATE, DELETE.
Relationships between tables can be established using foreign keys.
Indexes can be used to optimize query performance.
ACID properties ensure data integrity and consistency.
Skills evaluated in this interview
I was interviewed in Oct 2021.
(1 Question)
- Q1. Core python,python library and data science
(1 Question)
- Q1. Mathematics,python and sql and data science are complete
Interview Preparation Tips
- Python
What people are saying about ITC Infotech
Interview Questionnaire
2 Questions
- Q1. If you are fresher, good communication is only enough to crack all the levels.
- Q2. If you have experience, you need to explain the project and workflow with good communication without lag.
Interview Preparation Tips
ITC Infotech interview questions for designations
Interview questions from similar companies
I applied via Campus Placement and was interviewed in Dec 2024. There were 2 interview rounds.
Basics of mathematical ability and verbal ability
(2 Questions)
- Q1. Introduction - explain projects
- Q2. Data analytics explain
I applied via LinkedIn and was interviewed in Oct 2024. There was 1 interview round.
It was F2F interview , where the interviewer was very friendly and he was given a Excel sheet which need to answer few Excel related questions and another SQL querying intermediate to advance level .
Interview Preparation Tips
- SQL , Exceel
- Advanced level
Practice ..practice ..practice on data sets
Selected
I applied via Referral and was interviewed in Feb 2024. There were 2 interview rounds.
(2 Questions)
- Q1. Basis HR questions
- Q2. Answer confidently
(2 Questions)
- Q1. Based on previous work
- Q2. Answer correctly what you had worked in your previous work
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed in Aug 2023. There were 6 interview rounds.
I am a person with unwavering an working on this company coding test
Aptitude test best' time at the highest goal hardware detected a good time
(6 Questions)
- Q1. Computer knowledge of science in bigner good knowledge
- Q2. I am a person with unwavering support grow with a strong understanding of service
- Q3. All members and clans handling the highest level of service.
- Q4. I believe you have a great connection with any problems honestly working on company rules summary.
- Q5. My summary data analysis skills development consultant all I have already mentioned skills!
- Q6. My dream big and strong person in my challenges data scientist observing a very powerful mindset.
(1 Question)
- Q1. SQL knowledge in this is very important question prepare for everything response
(1 Question)
- Q1. My voice top voice LinkedIn social support all audience people are convenes.
I believe you skills best coding test best' pofomanc and connect clans
30 multiple choice questions
There were many puzzles ,some english ,comp sci related questions
English-arrange sentence in order ,ram,dns server,preposition,smallest unit bit,modem,repeater,lan ,search engine
(2 Questions)
- Q1. What is dns ,www,http,domain name,ip address,html
- Ans.
DNS, WWW, HTTP, domain name, IP address, and HTML are all fundamental components of the internet.
DNS (Domain Name System) is a system that translates domain names into IP addresses.
WWW (World Wide Web) is a system of interlinked hypertext documents accessed via the internet.
HTTP (Hypertext Transfer Protocol) is the protocol used for transmitting data on the web.
A domain name is a human-readable address used to access w...
- Q2. About yourself,family ,would you stay for a year
Skills evaluated in this interview
(2 Questions)
- Q1. Introduce yourself and past experience
- Q2. Describe slowing changing dimensions
- Ans.
Slowly changing dimensions are attributes that change over time, but at a slow rate.
SCD is a technique used in data warehousing to handle changes in dimensions over time
Type 1 SCD overwrites old data with new data
Type 2 SCD creates a new record for each change and maintains a history
Type 3 SCD adds a new column to the existing record to store the new value
Examples of SCD include customer addresses, product prices, and
Interview Preparation Tips
Skills evaluated in this interview
ITC Infotech Interview FAQs
Tell us how to improve this page.
ITC Infotech Interviews By Designations
- ITC Infotech Associate Information Technology Consultant Interview Questions
- ITC Infotech Lead Consultant Interview Questions
- ITC Infotech Associate Consultant Interview Questions
- ITC Infotech Software Developer Interview Questions
- ITC Infotech Associate IT Consultant 2 Interview Questions
- ITC Infotech IT Consultant Interview Questions
- ITC Infotech Software Engineer Interview Questions
- ITC Infotech Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Senior Data Analyst Interview Questions
- Junior Data Analyst Interview Questions
- Data Analyst Intern Interview Questions
- Data Engineer Interview Questions
- Data Research Analyst Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Analyst Interview Questions
- Show more
ITC Infotech Data Analyst Interview Process
based on 2 interviews
Interview experience
Data Analyst Interview Questions from Similar Companies
Fast track your campus placements
ITC Infotech Data Analyst Reviews and Ratings
based on 9 reviews
Rating in categories
|
Associate Information Technology Consultant
5.2k
salaries
|  ₹4.1 L/yr - ₹15 L/yr |
|
Lead Consultant
4.5k
salaries
| ₹9 L/yr - ₹35 L/yr |
|
Associate Consultant
827
salaries
| ₹2.5 L/yr - ₹16.5 L/yr |
|
Software Engineer
503
salaries
| ₹4 L/yr - ₹14.1 L/yr |
|
Senior Software Engineer
377
salaries
| ₹6.6 L/yr - ₹25 L/yr |
TCS
Wipro
HCLTech
Tech Mahindra
- Home >
- Interviews >
- ITC Infotech Interview Questions >
- ITC Infotech Data Analyst Interview Questions
