Add office photos
Engaged Employer
i
This company page is being actively managed by
ITC Infotech Team. If you also belong to the team, you
can get access from
here
ITC Infotech
Compare
Filter interviews by
ITC Infotech Data Warehouse Developer Interview Questions and Answers
Updated
10 May 2020
ITC Infotech Data Warehouse Developer Interview Experiences
1 interview found
Anonymous
I applied via Indeed and was interviewed in Nov 2019. There were 5 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Delete duplicate records. I explained 4 ways.
- Ans.
There are multiple ways to delete duplicate records in a data warehouse.
Using the DISTINCT keyword in a SQL query
Using the GROUP BY clause in a SQL query
Using the ROW_NUMBER() function in SQL to identify and delete duplicates
Using temporary tables or common table expressions (CTEs) to identify and delete duplicates
- Q2. Example for trigger, functions, temp table, procedures, optimization and about dynamic queries as well...
Answered by
AI
View 1 more amswer
Add your answer
Interview Preparation Tips
Interview preparation tips for other job seekers - Be well prepared and be humble.
Skills evaluated in this interview
Top trending discussions
View All
Career Growth
2w
ammy11
·
works at
Nablasol
Notice Period Issues
My new employer wants me to join by 8th Jan, my current employer is not leaving me till 24th which is a long time.
I requested them to reduce notice period but they denied, what should I do?
Can I join new company will 2 weeks are left to complete notice period in current company? can new company know about this?
How can I tackle and get out of this situation?
Got a question about ITC Infotech ?
Ask anonymously on communities.
ITC Infotech Interview FAQs
How to prepare for ITC Infotech Data Warehouse Developer interview?
Go through your CV in detail and study all the technologies mentioned in your CV. Prepare at least two technologies or languages in depth if you are appearing for a technical interview at ITC Infotech . The most common topics and skills that interviewers at ITC Infotech expect are Analytics, Data Warehousing, Financial Services, Healthcare and Hospitality.
What are the top questions asked in ITC Infotech Data Warehouse Developer interview?
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 IT Consultant Interview Questions
- ITC Infotech Software Engineer Interview Questions
- ITC Infotech Associate IT Consultant 2 Interview Questions
- ITC Infotech Java Developer Interview Questions
- Show more
Interview Questions for Popular Designations
- Warehouse Manager Interview Questions
- Warehouse Executive Interview Questions
- Warehouse Supervisor Interview Questions
- Warehouse Incharge Interview Questions
- Warehouse Assistant Interview Questions
- Warehouse Officer Interview Questions
- Senior Warehouse Executive Interview Questions
- Assistant Manager Warehouse Interview Questions
- Show more
People are getting interviews through
based on 1 ITC Infotech interview
Job Portal
100%
Low
Confidence
?
Low Confidence means the data is based on a small number of responses received from the candidates.
Interview Questions from Similar Companies
Fast track your campus placements
14%
less
than the average Data Warehouse Developer Salary in India
View more details
ITC Infotech Data Warehouse Developer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Associate Information Technology Consultant
5.2k
salaries
|  ₹4.1 L/yr - ₹15 L/yr |
|
Lead Consultant
4.4k
salaries
| ₹9 L/yr - ₹35.4 L/yr |
|
Associate Consultant
854
salaries
| ₹2.5 L/yr - ₹16 L/yr |
|
Software Engineer
501
salaries
| ₹4 L/yr - ₹14 L/yr |
|
Senior Software Engineer
362
salaries
| ₹6.4 L/yr - ₹27 L/yr |
Explore more salaries
Compare ITC Infotech with
TCS
Compare
Wipro
Compare
HCLTech
Compare
Tech Mahindra
Compare
Calculate your in-hand salary
Confused about how your in-hand salary is calculated? Enter your annual salary (CTC) and
get your in-hand salary
Did you find this page helpful?
Yes No
- Home >
- Interviews >
- ITC Infotech Interview Questions >
- ITC Infotech Data Warehouse Developer Interview Questions
Share an Interview