Add office photos
i
Intrics
Compare
Filter interviews by
Intrics Data Quality Analyst Interview Questions and Answers
Intrics Data Quality Analyst Interview Experiences
1 interview found
Mithilesh Kumar Dubey
Selected
I applied via Referral and was interviewed before Apr 2023. There was 1 interview round.
(3 Questions)
- Q1. Different types of joins, how to handle duplicates in SQL, excel
- Ans.
Different types of joins in SQL include inner join, outer join, left join, and right join. Handling duplicates can be done using DISTINCT keyword or GROUP BY clause.
Types of joins in SQL: inner join, outer join, left join, right join
Handling duplicates in SQL: use DISTINCT keyword or GROUP BY clause
Handling duplicates in Excel: use Remove Duplicates feature
- Q2. Difference betweenunion and union all
- Ans.
Union combines and removes duplicates, Union All combines all rows including duplicates.
Union combines the result sets of two or more SELECT statements and removes duplicates
Union All combines the result sets of two or more SELECT statements including duplicates
Union is slower than Union All as it involves removing duplicates
- Q3. Window function in sql
- Ans.
Window functions in SQL are used to perform calculations across a set of table rows related to the current row.
Window functions are used to calculate values based on a specific subset of rows within a result set.
They do not cause rows to become grouped into a single output row like aggregate functions.
Common window functions include ROW_NUMBER(), RANK(), DENSE_RANK(), and NTILE().
Skills evaluated in this interview
Interview questions from similar companies
(4 Questions)
- Q1. Components of Databricks
- Q2. How to read a json file
- Q3. Second highest salary SQL
- Q4. How to configure the spark while creating the cluster
CSE_A_45_Nidhi Kamboj
(2 Questions)
- Q1. What is Informatica tool
- Ans.
Informatica is a data integration tool used for ETL (Extract, Transform, Load) processes in data engineering.
Informatica is used for extracting data from various sources like databases, flat files, etc.
It can transform the data according to business rules and load it into a target data warehouse or database.
Informatica provides a visual interface for designing ETL workflows and monitoring data integration processes.
It ...
- Q2. What is Datastage tool
- Ans.
Datastage is an ETL tool used for extracting, transforming, and loading data from various sources to a target destination.
Datastage is part of the IBM Information Server suite.
It provides a graphical interface to design and run data integration jobs.
Datastage supports parallel processing for high performance.
It can connect to a variety of data sources such as databases, flat files, and web services.
Datastage jobs can b...
Skills evaluated in this interview
Aniruddh Bhat
(2 Questions)
- Q1. Tell me about 1 project you have worked on and what did you learn during this?
- Ans.
Developed a machine learning model to predict customer churn for a telecom company.
Collected and cleaned customer data including demographics, usage patterns, and customer service interactions.
Used various machine learning algorithms such as logistic regression, random forest, and XGBoost to build and evaluate the model.
Identified key factors contributing to customer churn such as contract length, monthly charges, and ...
- Q2. How do you build a recommendation system?
- Ans.
A recommendation system can be built using collaborative filtering, content-based filtering, or hybrid approaches.
Collect and preprocess data on user preferences and item attributes
Implement collaborative filtering by recommending items based on user behavior and preferences
Utilize content-based filtering by recommending items similar to those previously liked by the user
Consider hybrid approaches that combine collabor...
Skills evaluated in this interview
Selected
I applied via Internshala and was interviewed in May 2024. There were 2 interview rounds.
Done in notepad. Data analysis fundamental and coding fundamentals were covered.
(2 Questions)
- Q1. Piviot tables, vlookups excel case study.
- Q2. Window fucntions SQL question and pandas data manupilation.
Interview Preparation Tips
General Aptitude test
(2 Questions)
- Q1. On SQL functions
- Q2. Python coding questions
(1 Question)
- Q1. Can you tell me about yourself?
Interview Preparation Tips
Selected
I applied via LinkedIn and was interviewed before Oct 2023. There were 3 interview rounds.
Basic aptitude question
(1 Question)
- Q1. Basic analysis and ML questions , more focused on approach instead of coding
(1 Question)
- Q1. As like other HR rounds
Oracle Database Administrator Interview Questions & Answers
Softenger
Anonymous
posted on 10 Jul 2024
(1 Question)
- Q1. My self and some tec question
(1 Question)
- Q1. All tec questions
Interview Preparation Tips
Selected
I applied via campus placement at Nitte Meenakshi Institute of Technology, Bangalore and was interviewed before Nov 2023. There were 5 interview rounds.
2 coding questions in 45 min
(2 Questions)
- Q1. Basics of java and frameworks
- Q2. Basics of SQL and types of queries
30 min of logical reasoning and basic aptitude
30 min of GD over a general topic to check your communication skills
(2 Questions)
- Q1. Why do you want to join our company
- Q2. Why should we hire you
Intrics Interview FAQs
Tell us how to improve this page.
Intrics Interviews By Designations
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Senior Data Engineer Interview Questions
- Senior Data Analyst Interview Questions
- Senior Data Scientist Interview Questions
- Data Science Intern Interview Questions
- Show more
Intrics Data Quality Analyst Interview Process
based on 2 interviews
Interview experience
Interview Questions from Similar Companies
Intrics Data Quality Analyst Reviews and Ratings
based on 1 review
Rating in categories
|
Associate Data Analyst
21
salaries
|  ₹2.2 L/yr - ₹3.2 L/yr |
|
Data Analyst
14
salaries
| ₹2 L/yr - ₹3.1 L/yr |
|
Operations Associate
11
salaries
| ₹2 L/yr - ₹2.6 L/yr |
|
Associate Software Developer
11
salaries
| ₹2 L/yr - ₹3 L/yr |
|
Associate Software Engineer
9
salaries
| ₹2.2 L/yr - ₹4.2 L/yr |
TCS
Infosys
Wipro
HCLTech
- Home >
- Interviews >
- Intrics Interview Questions >
- Intrics Data Quality Analyst Interview Questions
