Citicorp Senior Data Engineer Interview Questions and Answers

Aptitude was very basic.

Q1. What is constant?
Ans. 
A constant is a value that does not change during the execution of a program.
• Constants are used to store values that remain the same throughout the program.

• They are declared using the 'const' keyword in many programming languages.

• Examples include mathematical constants like pi (3.14159) or physical constants like the speed of light (299,792,458 m/s).
Answered by AI
Add your answer
Q2. What is object oriented programming?
Ans. 
Object oriented programming is a programming paradigm based on the concept of objects, which can contain data and code.
• Objects are instances of classes, which define the structure and behavior of the objects.

• Encapsulation, inheritance, and polymorphism are key principles of object oriented programming.

• Example: Inheritance allows a subclass to inherit attributes and methods from a superclass.
Answered by AI
Add your answer

Q1. Salary Negotiation
Add your answer
Q2. Work culture description
Ans. 
Our work culture is collaborative, innovative, and focused on continuous learning and growth.
• Encourages teamwork and open communication

• Emphasizes creativity and problem-solving

• Provides opportunities for professional development

• Values diversity and inclusion

• Promotes a healthy work-life balance
Answered by AI
Add your answer

Basic aptitude test like distance problem , age etc

Q1. Explain error handling in PySpark
Ans. 
Error handling in PySpark involves using try-except blocks and logging to handle exceptions and errors.
• Use try-except blocks to catch and handle exceptions in PySpark code

• Utilize logging to record errors and exceptions for debugging purposes

• Consider using the .option('mode', 'PERMISSIVE') method to handle corrupt records in data processing
Answered by AI
Add your answer

Q1. Data Warehousing related questions
Add your answer

Q1. Data Modelling related questions
Add your answer

Quant Topics: Interests, Sequence and Series along with Missing items, Time and Distance/Work,
Verbal Topics: Comprehension, Corrections, Grammar etc
CS Core Subjects: DSA, OOPS, DBMS, OS

Overall Test Difficulty was Easy-Medium

System asked to choose one of the programming languages from C, C++ or Java. (Note: You can't change the language once confirmed!)
There were 7 different coding questions along with code. You just need to debug the code to get the correct output.
DSA: Graphs (Basics), Linked Lists, Conditional Statements, and Arrays (Stack and Queue)

Overall Difficulty was Medium (tbh, it depends on the practice you have done!)

Q1. 1. Tell me about yourself 2. What tech stack(s) you have worked on? Why? Why not others? 3. SQL queries based on joins, nesting and aggregations 4. Logical reasoning questions 5. Previous internships exper...read more
Add your answer

Q1. 1. Tell me about yourself 2. Why you do seek to join this company? 3. Are you comfortable working in shifts? If yes, how will you manage your time? 4. SQL queries 5. Logical question: Total number of squar...read more
Add your answer

Q1. 1. Tell me about your day. Walk me through it. 2. If given a coding problem, what is your preferred language? Why? 3. Walk me through your best project in your resume. Why/How/When did you make it? 4. Tell...read more
Add your answer

Q1. Create own list without using java collections
Ans. 
Create a custom list using arrays in Java
• Declare an array of strings to store the elements of the list

• Implement methods like add, remove, get, and size to manipulate the list

• Use a counter variable to keep track of the number of elements in the list
Answered by AI
Add your answer

7 sql questions of easy to medium , 2 python questions, 1 pyspark question

Q1. Scenatio based, project questions
Add your answer

Asked questions from python and SQL

Q1. What are tupples
Ans. 
Tuples are ordered collections of elements, similar to lists but immutable.
• Tuples are created using parentheses ()

• Elements in a tuple can be of different data types

• Tuples are immutable, meaning their elements cannot be changed once created
Answered by AI
Add your answer
Q2. What is credit risk
Ans. 
Credit risk refers to the potential loss that a lender may incur due to a borrower's failure to repay a loan or meet their financial obligations.
• Credit risk is the risk of default on a debt that may arise from a borrower failing to make required payments.

• It is a key consideration for banks and financial institutions when lending money.

• Factors that contribute to credit risk include the borrower's credit history, financi...read more
Answered by AI
Add your answer