AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
ITC Infotech
Compare
Filter interviews by
ITC Infotech Data Warehouse Developer Interview Questions and Answers
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...
Interview Preparation Tips
Skills evaluated in this interview
Top trending discussions
Interview questions from similar companies
I applied via Newspaper Ad and was interviewed before Jun 2021. There were 3 interview rounds.
(1 Question)
- Q1. Basic questions of java.
(1 Question)
- Q1. Intro and other hr related questions.
Interview Preparation Tips
I applied via Walk-in and was interviewed before Jul 2021. There was 1 interview round.
(1 Question)
- Q1. .net questions - routing in asp.net MVC ?
Interview Preparation Tips
I appeared for an interview in Sep 2016.
Interview Questionnaire
2 Questions
- Q1. Tell me about Your project
- Ans.
Developed a web-based project management tool for a software development company.
Used Agile methodology for development
Implemented features like task assignment, progress tracking, and team collaboration
Integrated with third-party tools like GitHub and Slack
Designed a user-friendly interface with responsive design
Deployed on AWS using EC2 and RDS
- Q2. Tell me about your CV!
- Ans.
My CV showcases my experience in software development, including projects in Java, Python, and web development.
Experience in Java, Python, and web development
Worked on projects involving database management systems
Familiar with Agile development practices
Interview Preparation Tips
Experience: Tough! But manuplative ,yes manuplative ,I feel that your test scores are manuplated by the company! You score full marks in the test , but you are mechanical engineer you might not qualify for the next round! I say this as per ny experience . POINTER ,BRANCH and then score in this test describe the overall perfomance!
Tips: The company is totally for IT engineers if you are from other branch fonnot hope much, have a backup.
Duration: 1 hour 20 minutes
Total Questions: 80
Round: Technical + HR Interview
Experience: They Play with your minds,yes they do! Believe me donot show tough expressions!
Tips: Stay Calm ,they are not to scare you!
Skills: Technical, knowledge, gritt, Behavioural Skills
College Name: Atharva College Of Engineering
I appeared for an interview in May 2017.
Interview Questionnaire
1 Question
- Q1. Tell me about your Project done in 4th year Btech
- Ans.
Developed a web-based project management system for tracking tasks and deadlines.
Used HTML, CSS, JavaScript for front-end development
Implemented backend using Node.js and MongoDB for database management
Incorporated user authentication and authorization features
Utilized Agile methodology for project management
Interview Preparation Tips
Duration: 3 hours
Round: Technical + HR Interview
Experience: They asked several questions regarding all the bio data and some computer questions and some hr level questions
Round: Resume Shortlist
Experience: Resume got shortlisted and I got the Job that time I even can't believe that
College Name: ITER BHUBANESWSR
Vardaan Kumar
I appeared for an interview before Jun 2016.
Interview Questionnaire
2 Questions
- Q1. How to start an induction motor?
- Ans.
An induction motor can be started by providing a rotating magnetic field.
Use a three-phase power supply to create a rotating magnetic field
The magnetic field induces a current in the rotor, causing it to rotate
The motor may require a starting capacitor or a starting winding to provide the initial torque
Once the motor reaches its rated speed, the starting mechanism can be switched off
- Q2. Tell me something about yourself?
- Ans.
I am a passionate software engineer with 5 years of experience in developing web applications using various technologies.
Experienced in full stack web development
Proficient in languages like JavaScript, Python, and Java
Familiar with frameworks like React, Node.js, and Spring Boot
Strong problem-solving and analytical skills
Excellent team player with good communication skills
Interview Preparation Tips
Experience: It was a wonderful experience overall. Giving an online test with my batch mates was amazing. I did the test very well and with ease.
Tips: Just enter the exam hall with confidence...
Duration: 1 hour 30 minutes
Total Questions: 90
Round: Technical + HR Interview
Experience: As I was strong in basics so I was able to answer this quest. He asked few related questions and I was able to give right answers.
Tips: Be strong in core subject basics and forget the rest of the subjects completely. They just want to see how much faithful you are with whatever you do. Moreover, just tell your name, state of birth, schooling, hobbies, etc(with free mind). They are just recruiters and not butchers, so stay calm as much as you can.
College Name: Maharaja Agrasen Institute Of Technology, Delhi
I appeared for an interview in Sep 2016.
Interview Questionnaire
3 Questions
- Q1. Tell me about yourself
- Ans.
I am a passionate software developer with experience in Java, Python, and web development.
Experienced in Java, Python, and web development technologies
Strong problem-solving skills and ability to work in a team
Completed multiple projects including a web-based inventory management system
- Q2. Simple coding questions..Basically pattern.
- Q3. And also they will ask about your projects.
Interview Preparation Tips
Experience: 60 multiple choice questions so have to manage time carefully.
Tips: Have to give equal importance to all the sections..So try to do well in all section.
Duration: 1 hour 30 minutes
Total Questions: 60
Round: Technical + HR Interview
Experience: Don't panic...Only write those things that you know in your resume.
Skills: Smart Coding
College Name: Jaypee Institute Of Information Technology, Noida
I appeared for an interview in Mar 2017.
Interview Preparation Tips
I appeared for an interview in Dec 2016.
Interview Questionnaire
1 Question
- Q1. About yourself and technical questions
Interview Preparation Tips
Experience: We had an aptitude test with puzzles and verbal
Tips: Concentrate on aptitude
Duration: 1 hour
Total Questions: 60
Round: Technical + HR Interview
Experience: Formal question are asked and mostly communication is important
College Name: Sri Krishna College Of Engineering And Technology
I appeared for an interview before May 2016.
Interview Questionnaire
3 Questions
- Q1. Why do u want to enter software industry??
- Ans.
Passion for problem-solving and creating innovative solutions drives my interest in software industry.
Passion for problem-solving and creating innovative solutions
Interest in technology and its impact on society
Opportunity for continuous learning and growth
Desire to work on cutting-edge projects and contribute to advancements in the field
- Q2. Why infosys??
- Ans.
Infosys is a global leader in technology services and consulting, known for its innovative solutions and strong company culture.
Infosys has a strong reputation for delivering high-quality technology solutions to clients worldwide.
The company offers a wide range of opportunities for career growth and development.
Infosys has a collaborative and inclusive work culture that values diversity and innovation.
- Q3. Tell something about ur final year project
- Ans.
Developed a web-based project management system for tracking tasks and deadlines
Used HTML, CSS, JavaScript for front-end development
Implemented backend using Node.js and MongoDB for database management
Incorporated user authentication and authorization features
Tested the system for performance and security vulnerabilities
Interview Preparation Tips
Experience: In this round company chooses the resume of candidates they believe are suitable for the job
Round: Test
Experience: This round basically tests your logical reasoning skills and your mathematical ability
Duration: 30 minutes
Total Questions: 60
Round: Technical Interview
Experience: Being a metallurgical engineer and trying to enter in a software industry I was mostly asked as to why I want to enter into this sector and other hr questions. To some extent I was drilled on my final year project in engineering
College Name: NIT Raipur
ITC Infotech Interview FAQs
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
- Senior Warehouse Executive Interview Questions
- Warehouse Officer Interview Questions
- Assistant Manager Warehouse Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
ITC Infotech Data Warehouse Developer Reviews and Ratings
based on 5 reviews
Rating in categories
|
Associate Information Technology Consultant
5.2k
salaries
|  ₹4.2 L/yr - ₹15 L/yr |
|
Lead Consultant
4.5k
salaries
| ₹9 L/yr - ₹35 L/yr |
|
Associate Consultant
886
salaries
| ₹2.5 L/yr - ₹16.5 L/yr |
|
Software Engineer
497
salaries
| ₹4 L/yr - ₹16.5 L/yr |
|
Senior Software Engineer
388
salaries
| ₹6.5 L/yr - ₹27 L/yr |
Wipro
EPAM Systems
L&T Technology Services
Coforge
- Home >
- Interviews >
- ITC Infotech Interview Questions >
- ITC Infotech Data Warehouse Developer Interview Questions
