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
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
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
What people are saying about ITC Infotech
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
ITC Infotech interview questions for designations
Interview questions from similar companies
Selected
(6 Questions)
- Q1. Whats your name?
- Ans.
My name is John Doe.
Full name is John Doe
Common first and last name combination
Easy to remember and pronounce
- Q2. Csv stand for?
- Ans.
CSV stands for Comma-Separated Values.
CSV is a file format used to store tabular data in plain text.
Each line in a CSV file represents a row of data, with columns separated by commas.
CSV files can be easily imported and exported in spreadsheet software like Excel.
Example: 'name,age,city' on the first line, followed by 'John,25,New York' on the second line.
- Q3. Tell me something about yourself?
- Ans.
Hello,First of all thankyou very much for giving opportunity to introduced in front of you.I am harsh.I hail from ambala cantt but currently live in defence enclave.I am a fresher. I live in nuclear family.There are 5 of us in my family.I am a object oriented person. I have a master degree in computer application from kurukshetra university.I have done 6 month course in data analyst from chandigarh.I enjoy dancing,Sing...
- Q4. Sql stand for?
- Ans.
SQL stands for Structured Query Language.
SQL is a standard language for accessing and manipulating databases.
It is used to communicate with databases to perform tasks such as querying data, updating data, and creating tables.
Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE, CREATE, and DROP.
- Q5. Write a dml commands?
- Ans.
DML commands are used to manipulate data in a database.
DML stands for Data Manipulation Language
Common DML commands include INSERT, UPDATE, DELETE
Example: INSERT INTO table_name (column1, column2) VALUES (value1, value2)
- Q6. Rdbms stands for?
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
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
