Upload Button Icon Add office photos

Filter interviews by

Artech Infosystems Data Analyst Trainee Interview Questions and Answers

Updated 7 Nov 2024

Artech Infosystems Data Analyst Trainee Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Easy
Process Duration
Less than 2 weeks
Result
Selected Selected

I applied via Approached by Company and was interviewed before Nov 2023. There was 1 interview round.

Round 1 - HR 

(2 Questions)

  • Q1. Tell me About Yourself
  • Q2. About the processor of my laptop

Interview Preparation Tips

Interview preparation tips for other job seekers - If you are hard-working don't go to Artech they don't have enough projects and If you go there be prepared for the sudden termination of the job they don't give you prior notice.

Interview questions from similar companies

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via Naukri.com and was interviewed in Oct 2024. There were 2 interview rounds.

Round 1 - One-on-one 

(2 Questions)

  • Q1. Azure Scenario based questions
  • Q2. Pyspark Coding based questions
Round 2 - One-on-one 

(2 Questions)

  • Q1. ADF, Databricks related question
  • Q2. Spark Performance problem and scenarios
  • Ans. 

    Spark performance problems can arise due to inefficient code, data skew, resource constraints, and improper configuration.

    • Inefficient code can lead to slow performance, such as using collect() on large datasets.

    • Data skew can cause uneven distribution of data across partitions, impacting processing time.

    • Resource constraints like insufficient memory or CPU can result in slow Spark jobs.

    • Improper configuration settings, su...

  • Answered by AI

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
Easy
Process Duration
-
Result
Not Selected

I applied via Naukri.com and was interviewed in Aug 2024. There was 1 interview round.

Round 1 - Technical 

(5 Questions)

  • Q1. Wxaplinnyour project
  • Q2. How would you build a pipeline to connect http source and bring data in adls
  • Ans. 

    Build a pipeline to connect http source and bring data in adls

    • Set up a data ingestion tool like Apache NiFi or Azure Data Factory to pull data from the http source

    • Transform the data as needed using tools like Apache Spark or Azure Databricks

    • Store the data in Azure Data Lake Storage (ADLS) for further processing and analysis

  • Answered by AI
  • Q3. Dimension and fact tabel difference
  • Ans. 

    Dimension tables store descriptive attributes while fact tables store quantitative data.

    • Dimension tables contain attributes that describe the business entities, such as customer, product, or time.

    • Fact tables contain quantitative data or metrics that are typically numeric and additive, such as sales revenue or quantity sold.

    • Dimension tables are denormalized and have a one-to-many relationship with fact tables.

    • Fact table...

  • Answered by AI
  • Q4. Write slq query to get employee having 2manager
  • Ans. 

    Use a self join to find employees with 2 managers in SQL query.

    • Use a self join on the employee table to join the table with itself.

    • Count the number of distinct managers for each employee.

    • Filter the results to only include employees with 2 managers.

  • Answered by AI
  • Q5. Get second highest salary usingSQL

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I applied via LinkedIn and was interviewed in Jul 2024. There were 2 interview rounds.

Round 1 - Coding Test 

It was pair programming round where we need to attempt a couple of Spark Scenario along with the Interviewer. You will have a boiler plate code with some functionalities to be filled up. You will be assessed on writing clean and extensible code and test cases.

Round 2 - Technical 

(1 Question)

  • Q1. Questions will be based on the Project where they try to assess the depth of understading you have on your project, data quality checks, handling failure scenarios, reasoning behind choice of tech stack

Interview Preparation Tips

Interview preparation tips for other job seekers - In the Pair programming round, be interactive with the interviewer and try to improvise the existing code, implement functionality, test cases and communicate what you are thinking so that interviewer can work with you to move towards solution.

For Second round, Spark, Cloud Data Processing Components and being thorough with your previous experience will go a long way.
Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Power BI Difference between ALL() and ALLSELECTED()
  • Ans. 

    ALL() ignores all filters in the query context, while ALLSELECTED() ignores only filters on columns in the visual.

    • ALL() removes all filters from the specified column or table.

    • ALLSELECTED() removes filters from the specified column or table, but keeps filters on other columns in the visual.

    • Example: ALL('Table') would remove all filters on the 'Table' in the query context.

    • Example: ALLSELECTED('Column') would remove filte...

  • Answered by AI
  • Q2. Excel Difference between COUNT() and COUNTA()
  • Ans. 

    COUNT() counts only numeric values, while COUNTA() counts all non-empty cells.

    • COUNT() counts only cells with numerical values.

    • COUNTA() counts all non-empty cells, including text and errors.

    • Example: COUNT(A1:A5) will count only cells with numbers, while COUNTA(A1:A5) will count all non-empty cells.

  • Answered by AI
Round 2 - Technical 

(2 Questions)

  • Q1. Resume based questions like explain the projects that you have done.
  • Q2. Sample dataset questions

Skills evaluated in this interview

Interview experience
4
Good
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Technical 

(2 Questions)

  • Q1. Walk through your project?
  • Ans. 

    Developed a predictive model to forecast sales based on historical data

    • Collected and cleaned historical sales data

    • Performed exploratory data analysis to identify trends and patterns

    • Built and trained a machine learning model using regression techniques

    • Evaluated model performance using metrics like RMSE and MAE

  • Answered by AI
  • Q2. Behavioral questions?
Round 2 - Technical 

(2 Questions)

  • Q1. Questions based on Advanced Excel like Vlookup, Index match, sumifs, pivot tables
  • Q2. Behavioral questions
Round 3 - HR 

(1 Question)

  • Q1. Salary negotiation

Interview Preparation Tips

Interview preparation tips for other job seekers - Be thorough with your projects
Basic SQL, Advanced Excel, Tableau or Power BI
Interview experience
3
Average
Difficulty level
-
Process Duration
-
Result
-
Round 1 - One-on-one 

(2 Questions)

  • Q1. Cache vs persist
  • Ans. 

    Cache is used for temporary storage of data in memory, while persist is used for saving data to disk for long-term storage.

    • Cache is typically faster as it stores data in memory for quick access.

    • Persist saves data to disk for durability and long-term storage.

    • Cache is often used for temporary data that can be recomputed if lost, while persist is used for important data that needs to be retained.

    • Examples: Using cache for ...

  • Answered by AI
  • Q2. Broadcast join and other optimization techniques
Round 2 - One-on-one 

(4 Questions)

  • Q1. Sql window function
  • Q2. Spark architecture, dataframe vs rdd
  • Q3. Python reverse sentence
  • Ans. 

    Reverse a sentence using Python

    • Split the sentence into words using split() method

    • Reverse the list of words using list slicing

    • Join the reversed list of words back into a sentence using join() method

  • Answered by AI
  • Q4. Join based on nulls in sql

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Aptitude Test 

Basic Apititude Questions

Round 2 - Technical 

(2 Questions)

  • Q1. Difference between WHERE and HAVING??
  • Ans. 

    WHERE is used to filter rows before grouping, HAVING is used to filter groups after grouping.

    • WHERE is used with SELECT statement to filter rows based on a condition

    • HAVING is used with GROUP BY statement to filter groups based on a condition

    • WHERE is applied before data is grouped, HAVING is applied after data is grouped

    • Example: SELECT * FROM table WHERE column = 'value'

    • Example: SELECT column, COUNT(*) FROM table GROUP B

  • Answered by AI
  • Q2. Where- Row Level Filters Having-Aggregate Filters
  • Ans. 

    Row level filters are applied before aggregations, while aggregate filters are applied after aggregations.

    • Row level filters are used to filter individual rows of data before any aggregations are performed.

    • Aggregate filters are used to filter the aggregated results after the data has been grouped and summarized.

    • Row level filters are typically applied using WHERE clause in SQL, while aggregate filters are applied using H...

  • Answered by AI
Round 3 - HR 

(2 Questions)

  • Q1. Why do you wanna join Uber?
  • Q2. Best Company Ever

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare SQL and Excel and Basic Python

Skills evaluated in this interview

Interview experience
5
Excellent
Difficulty level
-
Process Duration
-
Result
-
Round 1 - Coding Test 

Basic python questions

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
Less than 2 weeks
Result
Not Selected

I was interviewed in Dec 2023.

Round 1 - Aptitude Test 

Medical knowledge based questions

Round 2 - Technical 

(2 Questions)

  • Q1. General medical questions
  • Q2. Antidiabetics , gerd, antihypertension,gout,bones,fracture
Round 3 - HR 

(1 Question)

  • Q1. Introducation salary expectation skills personality

Artech Infosystems Interview FAQs

How many rounds are there in Artech Infosystems Data Analyst Trainee interview?
Artech Infosystems interview process usually has 1 rounds. The most common rounds in the Artech Infosystems interview process are HR.

Tell us how to improve this page.

Artech Infosystems Data Analyst Trainee Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.4k Interviews
Accenture Interview Questions
3.8
 • 8.1k Interviews
Infosys Interview Questions
3.6
 • 7.5k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Cognizant Interview Questions
3.8
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.7k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
IBM Interview Questions
4.0
 • 2.3k Interviews
CitiusTech Interview Questions
3.4
 • 269 Interviews
View all

Artech Infosystems Data Analyst Trainee Reviews and Ratings

based on 1 review

3.0/5

Rating in categories

1.0

Skill development

3.0

Work-life balance

2.0

Salary

1.0

Job security

3.0

Company culture

2.0

Promotions

2.0

Work satisfaction

Explore 1 Review and Rating
Associate Recruiter
152 salaries
unlock blur

₹2.2 L/yr - ₹5.3 L/yr

Technical Recruiter
148 salaries
unlock blur

₹2.5 L/yr - ₹6.7 L/yr

Software Engineer
80 salaries
unlock blur

₹2.5 L/yr - ₹12.2 L/yr

Senior Technical Recruiter
77 salaries
unlock blur

₹3 L/yr - ₹7 L/yr

HR Executive
65 salaries
unlock blur

₹2 L/yr - ₹5.3 L/yr

Explore more salaries
Compare Artech Infosystems with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

HCLTech

3.5
Compare
Did you find this page helpful?
Yes No
write
Share an Interview