AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
i
Cognizant
Compare
Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards
Filter interviews by
Clear (1)
Cognizant Associate Data Engineer Interview Questions, Process, and Tips
Top Cognizant Associate Data Engineer Interview Questions and Answers
- Q1. Datastge - How will you remove Header and trailer from Sequential data file
- Q2. How to delete duplicate rows in Sql
- Q3. How to find process id in linux
Cognizant Associate Data Engineer Interview Experiences
4 interviews found
Anonymous
Interview Questionnaire
5 Questions
- Q1. How to find 3rd Highest salary in Sql.
- Q2. How to delete duplicate rows in Sql
- Ans.
Deleting duplicate rows in SQL
Use the DISTINCT keyword in SELECT statement to retrieve unique rows
Use GROUP BY clause to group rows with same values and then use aggregate functions to select one row
Use the ROW_NUMBER() function to assign a unique number to each row and then delete the rows with duplicate numbers
- Q3. Datastge - How will you remove Header and trailer from Sequential data file
- Ans.
To remove header and trailer from a sequential data file in Datastage.
Use Sequential File stage in Datastage.
Set the 'Skip Rows' property to the number of header rows to be skipped.
Set the 'Trailer Rows' property to the number of trailer rows to be skipped.
Use a Transformer stage to remove any remaining header or trailer rows.
Use the 'Remove' function in the Transformer stage to remove the rows.
- Q4. How would you kill any job in Datastage
- Ans.
To kill a job in Datastage
Stop the job manually from the Director client
Terminate the job from the command line using the dsjob command
Kill the job process from the operating system level
Delete the job from the Datastage repository
- Q5. How to find process id in linux
- Ans.
To find process id in Linux, use the command 'ps -aux | grep
' Open the terminal
Type 'ps -aux' to list all running processes
Use 'grep
' to filter the process you are looking for The process id (PID) will be listed in the second column
Interview Questionnaire
6 Questions
- Q1. Basics of HIVE AND SPARK
- Q2. SQL QUERIES WITH WINDOW FUNCTION
- Ans.
SQL queries with window functions
Window functions perform calculations across a set of rows that are related to the current row
Common window functions include ROW_NUMBER, RANK, DENSE_RANK, and NTILE
Window functions are used with the OVER() clause to define the window or subset of rows to perform the calculation on
- Q3. SORT BY ORDER BY CLUSTER BY DISTRIBUTE BY
- Ans.
SORT BY, ORDER BY, CLUSTER BY, and DISTRIBUTE BY are SQL clauses used for data sorting and partitioning.
SORT BY is used to sort the result set in ascending or descending order based on one or more columns.
ORDER BY is used to sort the result set in ascending or descending order based on one or more columns. It is similar to SORT BY but can be used with other clauses like LIMIT and OFFSET.
CLUSTER BY is used to group data...
- Q4. SPARK OOM ISSUE
- Q5. SMALL FILE PROBLEM
- Ans.
Small file problem refers to the issue of having a large number of small files in a storage system.
Small files can cause inefficiencies in storage and processing.
Solutions include consolidating small files into larger ones or using a different storage system.
Examples include Hadoop's SequenceFile format and Amazon S3's object size optimization.
- Q6. RDS VA DF VS DS
- Ans.
RDS, VA, DF, VS, and DS are all acronyms related to data engineering.
RDS stands for Relational Database Service, a managed database service by AWS.
VA stands for Virtual Assistant, a software program that can assist with tasks.
DF stands for Dataflow, a managed service by Google Cloud for data processing.
VS stands for Virtual Server, a server that runs on a virtual machine.
DS stands for Datastore, a NoSQL document databa
Skills evaluated in this interview
I applied via Recruitment Consultant and was interviewed in Sep 2021. There were 3 interview rounds.
Interview Questionnaire
2 Questions
- Q1. Azure activities
- Q2. Project experience
Interview Preparation Tips
What people are saying about Cognizant
I applied via Recruitment Consultant and was interviewed before Jun 2020. There were 4 interview rounds.
Interview Questionnaire
6 Questions
- Q1. Reading Data from a .log file and finding out each column with a specific regex.
- Ans.
Reading data from a .log file and extracting columns with a specific regex.
Use Python's built-in 're' module to define the regex pattern.
Open the .log file using Python's 'open' function.
Iterate through each line of the file and extract the desired columns using the regex pattern.
Store the extracted data in a data structure such as a list or dictionary.
- Q2. Asked to find count and profit from the data for last 4 years
- Q3. Optimizations I can use
- Ans.
Optimizations for data engineering
Use indexing to speed up queries
Partition data to improve query performance
Use caching to reduce data retrieval time
Optimize data storage format for faster processing
Use parallel processing to speed up data processing
Optimize network bandwidth usage
Use compression to reduce storage and network usage
- Q4. Python JSON reading
- Ans.
Answering how to read JSON in Python.
Use the json module to load and parse JSON data
Use the json.loads() method to load JSON data from a string
Use the json.load() method to load JSON data from a file
Access JSON data using keys or indexes
Use the json.dumps() method to convert Python objects to JSON strings
- Q5. Array, List - Python scenarios
- Q6. Pyspark configs
- Ans.
Pyspark configs
Pyspark configs are used to configure the behavior of a Pyspark application.
They can be set using SparkConf object or spark-submit command.
Examples include setting the number of executors, memory allocation, and log level.
Interview Preparation Tips
Skills evaluated in this interview
Cognizant interview questions for designations
Interview questions from similar companies
Apoorva Ramkumar
Interview Preparation Tips
Interview Questionnaire
11 Questions
- Q1. Hobbies: Drawing. Asked about drawing and pencil shading. Draw in next 5 mins something great to impress me else rejected
- Q2. Sketch my face
- Q3. If you are told to do a job of a peon for the company will you?
- Q4. Remove all the pcs from the lab and keep in other lab RIGHT NOW?
- Ans.
Yes, I can remove all the pcs from the lab and keep them in another lab right now.
Ensure all the necessary equipment and tools are available for the move
Coordinate with the lab staff to ensure a smooth transition
Label and document each PC for easy identification and setup in the new lab
Ensure proper packaging and handling to prevent any damage during the move
- Q5. Impress me with your talents
- Q6. If a person asks you on a construction site to pick up bricks will you?
- Q7. How crazy are you?
- Q8. Show me how crazy are you in next 5 mins?
- Q9. Write down Fibonacci series and also explain pseudo code for it?
- Ans.
Fibonacci series is a sequence of numbers where each number is the sum of the two preceding ones.
The first two numbers of the series are always 0 and 1
The next number is the sum of the previous two numbers
The series goes on infinitely: 0, 1, 1, 2, 3, 5, 8, 13, 21, 34, 55, 89, 144, ...
Pseudo code: 1. Initialize variables a=0, b=1, c=0 2. Print a and b 3. Repeat steps 4-6 until desired number of terms 4. c=a+b 5. Pr
- Q10. Write algorithm for matrix multiplication?
- Ans.
Algorithm for matrix multiplication
Create a result matrix with dimensions of the two input matrices
Iterate through each row and column of the result matrix
For each element in the result matrix, multiply corresponding row in first matrix with corresponding column in second matrix
Add the products obtained in the previous step to get the final value for the element
- Q11. Explain your project and which algorithm you used in it. Why that algorithm?
- Ans.
I worked on a project that involved sentiment analysis of customer reviews using Naive Bayes algorithm.
The project involved collecting customer reviews from various sources.
Preprocessing the data by removing stop words, stemming, and tokenizing.
Used Naive Bayes algorithm for sentiment analysis.
The algorithm was chosen because of its simplicity and effectiveness in text classification tasks.
The accuracy of the model was
Interview Preparation Tips
Experience: Confused
If they say do you have any questions?
NEVER ASK about your performance in that round.
Round: Technical Interview
Experience: Good
Tips: Interview depends on your basic knowledge
Skills: Presence Of Mind, Technical Skills, Analytical Skills
College Name: Vidyalankar Institute Of Technology
Motivation: Got rejected for TCS aptitude.
Funny Moments: Whole HR interview
Skills evaluated in this interview
Shruti Nair
Interview Questionnaire
9 Questions
- Q1. Talk about your BE project?
- Ans.
Developed a web-based project management system for a construction company.
Used PHP and MySQL for backend development
Implemented user authentication and authorization
Designed a responsive UI using Bootstrap
Integrated Google Maps API for location tracking
Enabled file uploads and downloads for project documents
- Q2. If you belong to EXTC, then why IT?
- Ans.
EXTC and IT are not mutually exclusive fields. My knowledge in EXTC complements my skills in IT.
My knowledge in EXTC gives me a strong foundation in electronics and communication, which are essential in the IT industry.
I have also gained programming skills through my coursework and projects in EXTC.
IT is a rapidly growing field with a lot of opportunities, and I believe my skills and knowledge make me a strong candidat...
- Q3. Are you ok with relocation?
- Ans.
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for a position that aligns with my career goals
I am excited about the prospect of exploring a new city and culture
I am flexible and adaptable to new environments
- Q4. Which languages are you familiar with?
- Ans.
I am familiar with several programming languages.
Java
Python
C++
JavaScript
SQL
- Q5. BE project members and your guide
- Q6. What/s the diffrencebetween leader and a manager
- Ans.
A leader inspires and motivates while a manager plans and organizes.
Leaders focus on the big picture while managers focus on details
Leaders lead by example while managers delegate tasks
Leaders inspire and motivate while managers enforce rules and policies
Leaders are visionaries while managers are implementers
Examples of leaders: Steve Jobs, Martin Luther King Jr. Examples of managers: Tim Cook, COO of Apple
- Q7. Are you okay with relocation?
- Ans.
Yes, I am open to relocation for the right opportunity.
I am willing to relocate for the right job opportunity
I am open to exploring new places and cultures
I understand that relocation may come with challenges, but I am prepared to face them
I am excited about the prospect of starting fresh in a new location
- Q8. What's the name of the person who took your technical interview?
- Ans.
I'm sorry, I don't have that information.
N/A
- Q9. How was the TCS aptitude test?
- Ans.
The TCS aptitude test was challenging but fair.
The test covered a wide range of topics including math, logic, and English.
The questions were designed to test problem-solving skills and critical thinking.
Time management was crucial as there were many questions to answer in a limited time.
Overall, the test was a good indicator of one's aptitude for software engineering.
Interview Preparation Tips
Experience: pretty decent and interactive
Tips: be true, be yourself
General Tips: Do not fake a personality, be original. Avoid an answer if you have to, but , in an affirmative way.
Skills: Ability To Justify, Ability To Be Involved In Hands On Work, Ability To Deal Diplomatically, Ability To Convince
College Name: Vidyalankar Institute Of Technology
Funny Moments: The HR interviewer asked me the name of my tech interviewer.
Interview Questionnaire
7 Questions
- Q1. Introduce Yourself
- Ans.
I am a software engineer with 5 years of experience in developing web applications using Java, Spring Boot, and Angular.
5 years of experience in software development
Proficient in Java, Spring Boot, and Angular
Strong problem-solving skills
- Q2. About Your Family
- Q3. About MindTree
- Q4. Why MindTree?
- Ans.
MindTree's focus on innovation, culture of learning, and diverse opportunities make it an ideal fit for my career growth.
Strong focus on innovation and cutting-edge technologies
Culture of continuous learning and development
Diverse opportunities for growth and career advancement
- Q5. Plans for Higher Study
- Ans.
I am currently focusing on gaining practical experience in the software engineering field, but I may consider pursuing higher studies in the future.
Currently focusing on gaining practical experience in software engineering
Open to considering higher studies in the future
Higher studies could include a Master's degree in Computer Science or related field
- Q6. About Relocation
- Q7. Any Question?
Interview Preparation Tips
Experience: First round was aptitude test organised by our college through AMCAT
It had 4 section –
1. English – 25 questions (25 minutes)
2. Quantitative – 25 questions (35 minutes)
3. Technical – 25 questions (35 minutes)
4. Logical – 24 questions (35 minutes)
Practice previous Amcat papers. Technical was mostly from data structure and algorithm. There were very basic questions from Operating System and SQL. Each section had individual cut off . It was adaptive test so you can not go back to your previous answer.
Tips: If you are good in basics then you can easily score well in AMCAT.There is no negative marking in AMCAT.You have to manage time as some of the questions are lengthy.Follow R.S.Aggarwal book.
Topics to concentrate for Quantative:
· Time and Work
· Pipes and Cisterns
· Problems on Trains
· Boats and Streams
· Calendar and Clocks
· Probability
· Ratios and Percentage
· Number systems
Logical Ability
Analogy Pattern Recognition
Classification Pattern Recognition
Coding Pattern Recognition
Number Series Pattern Recognition
Direction sense, Blood relations, CDL
Puzzles, Logical word sequence
Selection decision table
Data sufficiency
Objective reasoning
English:
Synonyms/Antonyms/Word Meaning (Vocabulary)
Complete the Sentence (Grammar)
Spot error/Correct sentence (Grammar/sentence construction)
Sentence Ordering (Comprehension skills)
Questions based on passage (Comprehension skills)
Duration: 130 minutes
Total Questions: 99
Round: Resume Shortlist
Experience: Eligibility Criteria:
10th and 12th percentage - 65%
Aggregate of 60% in Engineering (BE / B.Tech/MCA only)
Please note the percentage calculation in case of CGPA:
Total marks obtained from in all the subjects from the first to last semester divided by total of maximum marks in all the subjects from first to last semester.
Candidates need to clear all exams before joining & should come with Degree Certificates
At the time of recruitment, Mindtree allow candidates to appear for the selection/interview process if they have less than 2 backlogs
Only Students from circuit branches can take part in the Mindtree selection process (branches mentioned below) :-
Computer Science and Engineering
Electronics
Electronics and Electricals
Electronics & Communication Engineering
Electronics & Instrumentation
Electronics and telecommunication Engineering
Information Science
Information Technology
Instrumentation Engineering
Telecommunication
MCA
Round: Test
Experience: This round is elimination round and your programs will be considered for technical round. There were 2 C/C++/Java programming questions and you need to type the program, compile and submit. Some hints will be on the screen. This test is conducted by Aspiring Minds. You have to focus on basics programming. There were two questions.One question from pattern printing and other one from array/pointer/String.
Tips: Focus on basic programming
Duration: 20 minutes
Total Questions: 2
Round: Technical Interview
Experience: Thorough discussion about the projects. My major work was on Advance Java, so the interviewer kept on grilling me. Questions on the database, challenges faced, control flow were asked. She even asked me about the implementation of my project. The interview ended with some questions on OOPs concepts.
Tips: Prepare both the programs which have been asked in Programming test. You are surely going to face this question. Prepare well with Logics.Apart from that you need to focus on C/Data Structure/DBMS/Basics of Operating System/Basics of OOPS.
C- Pointer/Array/Strings/Structure/Union
Data Structure : Linked List/Stack/Tree/Sorting/Traversal/SEaching
Round: HR Interview
Experience: This was end of d interview, thankfully I was able to answer all of them. I was the first candidate to enter .
I hope all that I shared above could help you in your preparation. Be confident and give your best.
Tips: In HR round, questions are of fixed type. in every Interview So preparee it from Indiabix.
General Tips: Focus on basics. The "basic" is most difficult to cover :D So Prepare well and be Confident
Skill Tips: Confidence is the key in all interview
Skills: Smartness, Ability To Think Of Creative Solutions, Technical Skill, Confidence
College Name: B P Poddar Institute of management and technology
Advait Karulkar
I applied via Campus Placement
Interview Questionnaire
4 Questions
- Q1. Tell me about a time when you have worked on a group project
- Ans.
Worked on a group project to develop a mobile app for a charity organization
Collaborated with team members to define project scope and requirements
Assigned tasks and set deadlines to ensure timely completion
Conducted regular meetings to discuss progress and address any issues
Implemented agile methodology to adapt to changing requirements
Delivered a functional and user-friendly app within the given timeframe
- Q2. How will you write a program to
. For example, create a calculator - Ans.
To create a calculator program, use a GUI framework and implement basic arithmetic operations.
Choose a programming language and a GUI framework such as JavaFX or Tkinter.
Implement the basic arithmetic operations such as addition, subtraction, multiplication, and division.
Add functionality for decimal points, clear button, and negative numbers.
Test the program thoroughly to ensure accuracy and usability.
- Q3. Why do you want to work for this organisation?
- Ans.
I am excited to work for this organisation because of its reputation for innovation and commitment to employee growth.
I am impressed by the company's track record of developing cutting-edge technology
I appreciate the emphasis on professional development and growth opportunities for employees
I am drawn to the company's culture of collaboration and teamwork
I am excited about the potential to work on projects that have a
- Q4. Where do you see yourself in 5 years?
- Ans.
In 5 years, I see myself as a senior software engineer leading a team of developers to create innovative solutions.
Leading a team of developers to create innovative solutions
Continuing to learn and stay up-to-date with the latest technologies
Contributing to the growth and success of the company
Mentoring and coaching junior developers
Taking on more responsibilities and challenges
Interview Preparation Tips
Experience: I responded with a description of my third year engineering project. The interviewer was interested in knowing more about
a. how did we come up with the project idea
b. how was the work divided between the team members
c. what challenges did we face and how we overcame them
d. what was the final outcome. was the deliverable as per specifications
Tips: In my experience, interviewers are trying to understand how one works in a group / team. Provide examples instead of generic responses - these will serve as evidences to your claims. Try to include following pointers in your responses
a. what was your personal contribution (this is the most technical part of the response)
b. how did you assist other members
c. how did you seek help from other members
d. how did you take accountability of something outside your personal tasks.
e. how did you keep focus on the bigger picture
Round: Technical Interview
Experience: I responded with a flowchart of a standard calculator. It was a simple design. The interviewer was more interested in knowing
a. how did I come up with a design
b. how did I make sure the design was correct
c. what are the limitations of the design?
d. what enhancements can I make to the design
Tips: In my experience, the interviewers are trying to understand your analytical skills.
a. how do you understand the problem statement
b. why do you decide on one particular design. are there any alternatives.
c. how do you break down the problem statement to smaller tasks
d. how thoroughly do you understand your design, with limitations.
e. does it fulfill your client's purpose.
Round: HR Interview
Experience: I had undertaken thorough research about the organisation, which enabled me to map my ambitions and expectations to the organisational values and purpose.
Tips: I highly recommend doing a background research on the organisation. It also helps to be clear on your expectations.
For example, 'I want to work here because the company believes in taking a client centric approach to deliver solutions, while maintaining high ethical standards. This way of work aligns with my idea of undertaking challenging tasks in an environment which provides developmental platforms for employees.'
Round: HR Interview
Experience: I responded with my professional ambitions in the industry. The interviewer is more interested in understanding what your objective is and your plan to get there.
Tips: Study the career opportunities and pathways available in the industry. Decide which one suits your goals the best. It is alright not to have a completely confirmed plan. You can also demonstrate that you are flexible with your plan and will select the best available option at a future point in time.
General Tips: Learn from the experience. If you do not get selected, there is always a next opportunity. Understand what the recruiters are looking for. Try to refrain from repeating your mistakes.
Skills: Leadership Skills, Teamwork, Ability To Improvise, Basic Mathematics, Ability To Deal Diplomatically, Activeness Of Candidate, Analytical Skills, Object Oriented Programming (OOP) Basics, Programming
College Name: Vidyalankar Institute Of Technology
Funny Moments: The HR rep complimented me on having a unique name and asked me what it means. To which I had no answer. Quite embarrassing!
Skills evaluated in this interview
anjan
Interview Questionnaire
4 Questions
- Q1. Are u willing to relocate to different centers for training?
- Ans.
Yes, I am willing to relocate to different centers for training.
I am open to the opportunity of relocating for training purposes.
I understand that training may be conducted in different centers and I am willing to adapt.
Relocating for training can provide valuable learning experiences and exposure to different environments.
I am flexible and willing to make the necessary arrangements to relocate if required.
- Q2. Tell me something about yourself?
- Ans.
I am a software engineer with 5 years of experience in developing web applications using Java and JavaScript.
I have a strong knowledge of object-oriented programming and design patterns.
I am proficient in Java, JavaScript, HTML, and CSS.
I have experience working with frameworks like Spring and Angular.
I have worked on projects involving database management and RESTful APIs.
I am a quick learner and enjoy staying updated...
- Q3. What are your qualities ?
- Ans.
I am a highly skilled and dedicated software engineer with a strong problem-solving ability.
Strong programming skills in languages like Java, C++, and Python
Excellent problem-solving and analytical skills
Ability to work well in a team and collaborate effectively
Strong attention to detail and ability to write clean and efficient code
Experience with software development methodologies like Agile
Good communication skills t...
- Q4. Would you be able to cope up with IT being extc engg?
Interview Preparation Tips
Experience: answers to the above questions
ans 1)If you want to get campus placement blindly say yes I am able to relocate.
ans 2)Give the details about you which are not there in resume.
ans 3)give details about your strength.
ans 4)blindly say yes
Tips: Be confident and answer with full beleif in yourself.
General Tips: prepare aptitude wholly and basics about your project and strong subjects.
Skill Tips: clear the basics and be familiar with quantz and verbal ability
Skills: Aptitude, attitude, Confidence
College Name: Vidyalankar Institute Of Technology
Motivation: Its quality of services and brand value .
Funny Moments: none
Cognizant Interview FAQs
Recently Viewed
INTERVIEWS
Capgemini
No Interviews
SALARIES
BNP Paribas India Solutions
SALARIES
BNP Paribas India Solutions
SALARIES
BNP Paribas India Solutions
SALARIES
BNP Paribas India Solutions
SALARIES
BNP Paribas India Solutions
SALARIES
Philips Innovation Campus
SALARIES
Bridge Group Solutions
SALARIES
Barclays Global Service Centre
INTERVIEWS
Celebal Technologies
No Interviews
Tell us how to improve this page.
Cognizant Interviews By Designations
- Cognizant Programmer Analyst Interview Questions
- Cognizant Programmer Analyst Trainee Interview Questions
- Cognizant Associate Interview Questions
- Cognizant Senior Associate Interview Questions
- Cognizant Processing Executive Interview Questions
- Cognizant Software Engineer Interview Questions
- Cognizant Senior Processing Executive Interview Questions
- Cognizant Project Associate Interview Questions
- Show more
Interview Questions for Popular Designations
- Data Analyst Interview Questions
- Data Engineer Interview Questions
- Data Scientist Interview Questions
- Data Entry Operator Interview Questions
- Associate Data Scientist Interview Questions
- Data Associate Interview Questions
- Associate Data Analyst Interview Questions
- Senior Data Engineer Interview Questions
- Show more
Interview Questions from Similar Companies
Fast track your campus placements
Cognizant Associate Data Engineer Reviews and Ratings
based on 3 reviews
Rating in categories
|
Associate
72.1k
salaries
|   Unlock₹0 L/yr - ₹0 L/yr |
|
Programmer Analyst
55.5k
salaries
| Unlock ₹0 L/yr - ₹0 L/yr |
|
Senior Associate
48.9k
salaries
| Unlock ₹0 L/yr - ₹0 L/yr |
|
Senior Processing Executive
28.9k
salaries
| Unlock ₹0 L/yr - ₹0 L/yr |
|
Technical Lead
17.5k
salaries
| Unlock ₹0 L/yr - ₹0 L/yr |
TCS
Infosys
Wipro
Accenture
- Home >
- Interviews >
- Cognizant Interview Questions >
- Cognizant Associate Data Engineer Interview Questions
