Upload Button Icon Add office photos
Engaged Employer

i

This company page is being actively managed by Cognizant Team. If you also belong to the team, you can get access from here

Cognizant Verified Tick

Compare button icon Compare button icon Compare

Proud winner of ABECA 2024 - AmbitionBox Employee Choice Awards

zig zag pattern zig zag pattern

Filter interviews by

Cognizant Associate Data Engineer Interview Questions, Process, and Tips

Updated 19 Oct 2021

Top Cognizant Associate Data Engineer Interview Questions and Answers

View all 10 questions

Cognizant Associate Data Engineer Interview Experiences

4 interviews found

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

  • Answered by AI
  • 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.

  • Answered by AI
  • 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

  • Answered by AI
  • 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

Answered by AI

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

  • Answered by AI
  • 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...

  • Answered by AI
  • 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.

  • Answered by AI
  • 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

  • Answered by AI

Skills evaluated in this interview

Associate Data Engineer Interview Questions Asked at Other Companies

asked in Cognizant
Q1. Datastge - How will you remove Header and trailer from Sequential ... read more
asked in Cognizant
Q2. How to delete duplicate rows in Sql
asked in Capgemini
Q3. How would you recommend customer to migrate on cloud
asked in Cognizant
Q4. How to find process id in linux
asked in Cognizant
Q5. Reading Data from a .log file and finding out each column with a ... read more

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

Interview preparation tips for other job seekers - Basics of azure must be very clear also scenario based questions.

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.

  • Answered by AI
  • 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

  • Answered by AI
  • 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

  • Answered by AI
  • 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.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Very easy if you have prev work exp.

Skills evaluated in this interview

Cognizant interview questions for designations

 Associate Data Scientist

 (1)

 Data Engineer

 (31)

 Associate Engineer

 (52)

 Azure Data Engineer

 (7)

 Gcp Data Engineer

 (4)

 Data Center Engineer

 (2)

 Senior Data Engineer

 (2)

 AWS Data Engineer

 (2)

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 in Mar 2020. There was 1 interview round.

Interview Questionnaire 

1 Question

  • Q1. How do you get the second to last element from a SQL table?
  • Ans. 

    To get the second to last element from a SQL table, use the OFFSET-FETCH clause.

    • Use the ORDER BY clause to sort the table in descending order.

    • Use the OFFSET-FETCH clause to skip the last row and fetch the second to last row.

    • Example: SELECT column_name FROM table_name ORDER BY column_name DESC OFFSET 1 ROWS FETCH NEXT 1 ROWS ONLY;

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Practice by building a simple full stack web application.

Skills evaluated in this interview

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

Interview Questionnaire 

1 Question

  • Q1. Basic coding questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be confident , easy to crack

Interview Questionnaire 

1 Question

  • Q1. Mostly related to the technology I applied for. Some coding related questions. Questions related to our expertise to test us.

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

Interview Questionnaire 

1 Question

  • Q1. Tell me something about yourself

Interview Preparation Tips

Interview preparation tips for other job seekers - Be very crisp and to the point in the interview. There is no point beating round the bush

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

Interview Questionnaire 

2 Questions

  • Q1. Basics about .Net and SQl server
  • Q2. What are triggers
  • Ans. 

    Triggers are database objects that automatically execute in response to certain events or changes in data.

    • Triggers are used to enforce business rules or data integrity.

    • They can be used to audit changes to data.

    • Triggers can be set to execute before or after an event, such as an insert, update, or delete operation.

    • They can be defined on tables, views, or schemas.

    • Examples of triggers include sending an email notification ...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Just be honest. They prefer learnability over current knowledge

Skills evaluated in this interview

Cognizant Interview FAQs

What are the top questions asked in Cognizant Associate Data Engineer interview?

Some of the top questions asked at the Cognizant Associate Data Engineer interview -

  1. Datastge - How will you remove Header and trailer from Sequential data f...read more
  2. How to delete duplicate rows in ...read more
  3. How to find process id in lin...read more

Tell us how to improve this page.

Interview Questions from Similar Companies

TCS Interview Questions
3.7
 • 10.5k Interviews
Accenture Interview Questions
3.8
 • 8.2k Interviews
Infosys Interview Questions
3.6
 • 7.6k Interviews
Wipro Interview Questions
3.7
 • 5.6k Interviews
Capgemini Interview Questions
3.7
 • 4.8k Interviews
Tech Mahindra Interview Questions
3.5
 • 3.8k Interviews
HCLTech Interview Questions
3.5
 • 3.8k Interviews
Genpact Interview Questions
3.8
 • 3.1k Interviews
LTIMindtree Interview Questions
3.8
 • 2.9k Interviews
IBM Interview Questions
4.0
 • 2.4k Interviews
View all
Cognizant Associate Data Engineer Salary
based on 102 salaries
₹4.5 L/yr - ₹11.8 L/yr
At par with the average Associate Data Engineer Salary in India
View more details

Cognizant Associate Data Engineer Reviews and Ratings

based on 5 reviews

2.6/5

Rating in categories

2.6

Skill development

2.6

Work-life balance

2.0

Salary

2.7

Job security

2.6

Company culture

2.2

Promotions

2.4

Work satisfaction

Explore 5 Reviews and Ratings
Associate
72.2k salaries
unlock blur

₹5.2 L/yr - ₹16 L/yr

Programmer Analyst
55.6k salaries
unlock blur

₹2.4 L/yr - ₹9.4 L/yr

Senior Associate
49.5k salaries
unlock blur

₹8.9 L/yr - ₹28 L/yr

Senior Processing Executive
29k salaries
unlock blur

₹1.8 L/yr - ₹9 L/yr

Technical Lead
17.6k salaries
unlock blur

₹5.9 L/yr - ₹25 L/yr

Explore more salaries
Compare Cognizant with

TCS

3.7
Compare

Infosys

3.6
Compare

Wipro

3.7
Compare

Accenture

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