Upload Button Icon Add office photos

Filter interviews by

DataNutts IT Solutions Interview Questions, Process, and Tips

Updated 17 May 2024

DataNutts IT Solutions Interview Experiences

1 interview found

ETL Developer Interview Questions & Answers

user image Anonymous

posted on 17 May 2024

Interview experience
5
Excellent
Difficulty level
Moderate
Process Duration
2-4 weeks
Result
Selected Selected

I applied via Naukri.com and was interviewed before May 2023. There were 3 interview rounds.

Round 1 - Technical 

(4 Questions)

  • Q1. Explain ETL process ?
  • Ans. 

    ETL process involves extracting data from various sources, transforming it to fit business needs, and loading it into a target database.

    • Extract data from multiple sources such as databases, files, APIs, etc.

    • Transform the data by cleaning, filtering, aggregating, and converting it to the desired format.

    • Load the transformed data into a target database or data warehouse.

    • ETL tools like Informatica, Talend, and SSIS are com

  • Answered by AI
  • Q2. Explain Joins ?
  • Ans. 

    Joins are used to combine rows from two or more tables based on a related column between them.

    • Joins are used in SQL to retrieve data from multiple tables based on a related column.

    • Common types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN.

    • INNER JOIN returns rows when there is at least one match in both tables.

    • LEFT JOIN returns all rows from the left table and the matched rows from the right table.

    • RI...

  • Answered by AI
  • Q3. What is DTM error ?
  • Ans. 

    DTM error stands for Data Transformation Manager error, which occurs during the ETL process when there is an issue with data transformation.

    • DTM error occurs during the ETL process when there is a problem with data transformation

    • It can be caused by incorrect mapping of data fields, data type mismatches, or data quality issues

    • DTM errors can lead to data loss, data corruption, or failed ETL processes

    • Examples of DTM errors...

  • Answered by AI
  • Q4. Explain Workflow?
  • Ans. 

    Workflow is a series of tasks that need to be completed in a specific order to achieve a desired outcome.

    • Workflow involves defining the sequence of steps needed to complete a task or project.

    • It helps in organizing and coordinating tasks among team members.

    • Workflow can be automated using tools like ETL software to streamline processes.

    • Example: In ETL development, a workflow may include extracting data from a source, tra...

  • Answered by AI
Round 2 - Case Study 

Challanges in migration project

Round 3 - HR 

(1 Question)

  • Q1. About you self ?

Interview Preparation Tips

Interview preparation tips for other job seekers - nothing

Skills evaluated in this interview

ETL Developer Interview Questions asked at other Companies

Q1. What are the content of APT_CONFIG_FILE? Can you brief on the relationship between APT_CONFIG_FILE and Partition.
View answer (1)

Interview questions from similar companies

I applied via Campus Placement and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Hr

Interview Preparation Tips

Interview preparation tips for other job seekers - You should be true to what you are putting before the interviewer . Try to put your ideas Add something you did well in your career like in projects /research which you know very well and versed in concepts about it for open interview so that interviewer can get bandwidth where he can ask questions from. This is simply a key .

I applied via Campus Placement and was interviewed before Jul 2020. There were 4 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Description of project
  • Ans. 

    The project involved designing and implementing a new network infrastructure for a large corporation.

    • Conducted a thorough analysis of the existing network infrastructure

    • Designed a new network architecture that met the company's needs

    • Implemented the new network infrastructure with minimal disruption to business operations

    • Tested and optimized the new network to ensure optimal performance

    • Provided ongoing support and maint

  • Answered by AI
  • Q2. Your previous experince

Interview Preparation Tips

Interview preparation tips for other job seekers - Well prepare for your resume

I applied via Walk-in and was interviewed before Feb 2020. There were 4 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Its for FP&A process and the major questions were from the basics of FP&A. How it starts and how its ends and Previous job roles.

Interview Preparation Tips

Interview preparation tips for other job seekers - It's quite a moderate interview but be prepare for more rounds of technical interviews.

I applied via Campus Placement and was interviewed before Jun 2020. There were 3 interview rounds.

Interview Questionnaire 

2 Questions

  • Q1. Simple program
  • Q2. I wrote a simple program in C

Interview Preparation Tips

Interview preparation tips for other job seekers - Be bold and confident

I applied via Referral and was interviewed before Jun 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. My expected tenure, education, technical insights

Interview Preparation Tips

Interview preparation tips for other job seekers - Good

I applied via Campus Placement and was interviewed before Nov 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. Concepts of Oops

Interview Preparation Tips

Interview preparation tips for other job seekers - Prepare with basic concepts of OOPS.Explain final year project.
Be confident.

I applied via Referral and was interviewed before Mar 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

Very easy

Round 2 - HR 

(2 Questions)

  • Q1. What are your strengths and weaknesses?
  • Q2. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Keep up your aptitude and you will surely make it.

I applied via Walk-in and was interviewed before May 2019. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. About yr self, dream, why choose company, happy moment in your life, inspiration person, Apitutude test

Interview Preparation Tips

Interview preparation tips for other job seekers - Really amazing experience, I working with Infosys last 18 month I learned different different training ,team work process knowledge and other skills I am proud be part of Infosys.

I applied via Walk-in and was interviewed before Feb 2021. There were 2 interview rounds.

Round 1 - Aptitude Test 

No

Round 2 - HR 

(1 Question)

  • Q1. Tell me about yourself.

Interview Preparation Tips

Interview preparation tips for other job seekers - Check all the review and think accordingly.

DataNutts IT Solutions Interview FAQs

How many rounds are there in DataNutts IT Solutions interview?
DataNutts IT Solutions interview process usually has 3 rounds. The most common rounds in the DataNutts IT Solutions interview process are Technical, Case Study and HR.
What are the top questions asked in DataNutts IT Solutions interview?

Some of the top questions asked at the DataNutts IT Solutions interview -

  1. What is DTM erro...read more
  2. Explain ETL proces...read more
  3. Explain Join...read more

Tell us how to improve this page.

DataNutts IT Solutions Interview Process

based on 1 interview

Interview experience

5
  
Excellent
View more

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.6k Interviews
Accenture Interview Questions
3.8
 • 8.3k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.7k Interviews
Cognizant Interview Questions
3.7
 • 5.7k Interviews
Amazon Interview Questions
4.0
 • 5.1k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
HCLTech Interview Questions
3.5
 • 3.9k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.9k Interviews
Genpact Interview Questions
3.8
 • 3.2k Interviews
View all

DataNutts IT Solutions Reviews and Ratings

based on 12 reviews

4.0/5

Rating in categories

3.5

Skill development

3.3

Work-life balance

3.2

Salary

3.0

Job security

3.6

Company culture

3.4

Promotions

3.3

Work satisfaction

Explore 12 Reviews and Ratings
Software Developer
39 salaries
unlock blur

₹4 L/yr - ₹8.2 L/yr

Junior Software Developer
10 salaries
unlock blur

₹1 L/yr - ₹5.3 L/yr

Senior Software Developer
9 salaries
unlock blur

₹7 L/yr - ₹11 L/yr

Informatica ETL Developer
6 salaries
unlock blur

₹8.1 L/yr - ₹10 L/yr

Software Engineer
5 salaries
unlock blur

₹4.2 L/yr - ₹10 L/yr

Explore more salaries
Compare DataNutts IT Solutions with

TCS

3.7
Compare

Accenture

3.8
Compare

Wipro

3.7
Compare

Cognizant

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