AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Nityo Infotech
Compare
Filter interviews by
Nityo Infotech Data Analyst Interview Questions and Answers
Nityo Infotech Data Analyst Interview Experiences
1 interview found
Jyoti Mishra
Very easy based upon Client requirement
(2 Questions)
- Q1. Package details , negotiation, ppf
- Q2. Joining date related discussion
Data Analyst Jobs at Nityo Infotech
Interview questions from similar companies
Anonymous
Selected
I applied via LinkedIn and was interviewed before Jun 2023. There were 3 interview rounds.
Easy questions related to DSA and Python and SQL
(2 Questions)
- Q1. Query to join two table using different joins
- Ans.
Query to join two tables using different joins
Use INNER JOIN to return rows that have matching values in both tables
Use LEFT JOIN to return all rows from the left table and the matched rows from the right table
Use RIGHT JOIN to return all rows from the right table and the matched rows from the left table
Use FULL JOIN to return rows when there is a match in one of the tables
- Q2. Delete and truncate difference
- Ans.
Delete removes rows from a table while truncate removes all rows from a table.
Delete is a DML command while truncate is a DDL command.
Delete operation can be rolled back while truncate operation cannot be rolled back.
Delete operation is slower than truncate operation.
Example: DELETE FROM table_name WHERE condition; TRUNCATE TABLE table_name;
(1 Question)
- Q1. Easy HR questions related to your previous experience
Skills evaluated in this interview
Selected
I applied via Campus Placement and was interviewed before Mar 2023. There were 3 interview rounds.
Easy round with normal pattern matching ques
Topic was given than all are told to speak
(2 Questions)
- Q1. Normal ques related to offer
- Q2. Why do you want to join
Interview Preparation Tips
I appeared for an interview in Aug 2024.
(5 Questions)
- Q1. Questions on Pyspark
- Q2. Questions on SQL
- Q3. Transformations
- Q4. Questions on Sql optimizations
- Q5. Questions About my current Project
I applied via Naukri.com and was interviewed in Nov 2024. There was 1 interview round.
(2 Questions)
- Q1. Tableau Questions 1. Difference between dimensions and measures. 2. What is RLS? 3. What are the functions you can assign in RLS? 4. Explain what is drill down approach. 5. What is LOD? 6. What is a calcul...
- Q2. SQL Questions 1. In employee table find the 2nd highest salary. 2. Find the highest average salary in department 3. Given two tables(sales & product) find total sales per category 4. Two questions to find ...
Interview Preparation Tips
- SQL
- Tableau
- DBMS
Yash Singh
Selected
I applied via Campus Placement and was interviewed before Feb 2023. There was 1 interview round.
(2 Questions)
- Q1. Questions over python scripts and data analysis
- Q2. Output based questions
Selected
I applied via Naukri.com and was interviewed in Jul 2023. There were 4 interview rounds.
Logical questions, mathematics and general knowledge.
(1 Question)
- Q1. Check your communication skills face to face in English.
(1 Question)
- Q1. Basic knowledge questions for system and logical questions.
I appeared for an interview in Jan 2024.
(2 Questions)
- Q1. What joins you used
- Ans.
I have used various types of joins including inner join, left join, right join, and full outer join.
Used inner join to retrieve records that have matching values in both tables
Utilized left join to retrieve all records from the left table and matching records from the right table
Employed right join to retrieve all records from the right table and matching records from the left table
Utilized full outer join to retrieve ...
- Q2. Write query for joins
- Ans.
Query for joins in SQL to combine data from multiple tables
Use JOIN keyword to combine data from two or more tables based on a related column
Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN
Example: SELECT * FROM table1 INNER JOIN table2 ON table1.id = table2.id
Skills evaluated in this interview
Selected
I applied via Approached by Company and was interviewed before Mar 2023. There were 3 interview rounds.
3 SQL questions were given
(1 Question)
- Q1. It was based upon my work experience and technical questions from SQL
(1 Question)
- Q1. Salary discussion
Interview Preparation Tips
Selected
I applied via Company Website and was interviewed before May 2023. There were 3 interview rounds.
There are one hour exam
(1 Question)
- Q1. Advance level of sql and python
- Ans.
Advanced level of SQL and Python skills are essential for a Data Engineer role.
Strong understanding of SQL queries, joins, subqueries, and optimization techniques.
Proficiency in writing complex Python scripts for data manipulation, analysis, and automation.
Experience with data modeling, ETL processes, and working with large datasets.
Knowledge of data warehousing concepts and tools like SQL Server, PostgreSQL, or Snowfl...
(2 Questions)
- Q1. Basic of SQL,some join condition
- Q2. Basic of python
Skills evaluated in this interview
Nityo Infotech Interview FAQs
Tell us how to improve this page.
Nityo Infotech Interviews By Designations
- Nityo Infotech Software Engineer Interview Questions
- Nityo Infotech Senior Software Engineer Interview Questions
- Nityo Infotech Java Developer Interview Questions
- Nityo Infotech Senior IT Recruiter Interview Questions
- Nityo Infotech IT Technical Recruiter Interview Questions
- Nityo Infotech Information Technology Recruiter Interview Questions
- Nityo Infotech Data Engineer Interview Questions
- Nityo Infotech Automation Tester 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
Nityo Infotech Data Analyst Interview Process
based on 1 interview
Interview experience
Data Analyst Interview Questions from Similar Companies
Nityo Infotech Data Analyst Reviews and Ratings
based on 2 reviews
Rating in categories
|
Information Technology Recruiter
191
salaries
|  ₹1 L/yr - ₹5 L/yr |
|
Desktop Support Engineer
134
salaries
| ₹1.5 L/yr - ₹4.6 L/yr |
|
Senior Software Engineer
133
salaries
| ₹7.1 L/yr - ₹25.2 L/yr |
|
Technical Recruiter
100
salaries
| ₹2 L/yr - ₹5.5 L/yr |
|
Software Engineer
92
salaries
| ₹4.4 L/yr - ₹13 L/yr |
ITC Infotech
HTC Global Services
Exela Technologies
HERE Technologies
- Home >
- Interviews >
- Nityo Infotech Interview Questions >
- Nityo Infotech Data Analyst Interview Questions
