Upload Button Icon Add office photos

Citicorp

Compare button icon Compare button icon Compare

Filter interviews by

Citicorp IT Operations Lead Interview Questions and Answers

Updated 10 Sep 2023

Citicorp IT Operations Lead Interview Experiences

1 interview found

Interview experience
3
Average
Difficulty level
Moderate
Process Duration
-
Result
-

I applied via Company Website and was interviewed in Mar 2023. There was 1 interview round.

Round 1 - Technical 

(2 Questions)

  • Q1. Difference between table and view
  • Ans. 

    A table is a collection of data stored in rows and columns, while a view is a virtual table created by a query.

    • Tables store actual data, while views display data from one or more tables based on a query

    • Tables can be modified directly, while views are read-only

    • Views can simplify complex queries by pre-defining joins and filters

    • Views can also provide security by restricting access to certain columns or rows

  • Answered by AI
  • Q2. A table is structured with rows and columns while view is derived from table
  • Ans. 

    A table is a structured collection of data organized in rows and columns, while a view is a virtual table derived from one or more tables.

    • Tables store data in a structured format with rows and columns, while views are virtual tables that display data from one or more tables based on a query.

    • Views do not store data themselves but instead display data from the underlying tables.

    • Views can be used to simplify complex queri...

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - prepare sql cocncepts thoroghly

Skills evaluated in this interview

Interview questions from similar companies

Interview Questionnaire 

8 Questions

  • Q1. Find a number which occurs odd number of times and all number occurs even number of times
  • Ans. 

    Find an odd occurring number among even occurring numbers.

    • Use XOR operation to cancel out even occurring numbers and get the odd occurring number.

    • Iterate through the array and XOR each element with the result variable.

    • The final result will be the odd occurring number.

  • Answered by AI
  • Q2. Some discussion about my minor project
  • Q3. Spiral order of binary tree and mattrix, print it
  • Ans. 

    Print the spiral order of a binary tree and matrix.

    • For binary tree, use level order traversal and alternate direction for each level.

    • For matrix, use four pointers to traverse in spiral order.

    • Example for binary tree: 1 -> 2 -> 3 -> 4 -> 5 -> 6 -> 7 -> 8 -> 9

    • Example for matrix: 1 2 3 4 -> 8 7 6 5 -> 9 10 11 12 -> 16 15 14 13

  • Answered by AI
  • Q4. Some question about os,dbms
  • Q5. Find pair which have a given sum in a given array
  • Ans. 

    Finding pairs in an array with a given sum.

    • Iterate through the array and for each element, check if the difference between the given sum and the element exists in the array.

    • Use a hash table to store the elements of the array and their indices for faster lookup.

    • If there are multiple pairs with the same sum, return any one of them.

    • If no pair is found, return null or an empty array.

  • Answered by AI
  • Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
  • Ans. 

    Find total number of k element with given avg in an array in minimum time complexity.

    • Use sliding window technique to traverse the array in O(n) time complexity.

    • Maintain a sum variable to keep track of the sum of elements in the window.

    • If the sum of elements in the window is equal to k times the given avg, increment the count.

    • Move the window by subtracting the first element and adding the next element in the array.

  • Answered by AI
  • Q7. Print all elements which in not boundary element in a given binary tree
  • Ans. 

    Printing non-boundary elements of a binary tree

    • Traverse the tree in any order (preorder, inorder, postorder)

    • Check if the current node is not a boundary node (not the first or last node in its level)

    • If it is not a boundary node, print its value

    • Recursively traverse its left and right subtrees

  • Answered by AI
  • Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question

Interview Preparation Tips

Round: Test
Experience: practice codes on paper
Tips:

Round: Technical Interview
Experience: very good
Tips: please try to explain each and every question in detail

Round: Technical Interview
Experience: my hr round is not taken by them,and some of face 3rd round ,which is HR
Tips: please prepare all types of problem from geeksforgeeks

Skill Tips: please try to understand every problem from geeksforgeeks
Skills: ds
College Name: NIT Bhopal
Motivation: best work culture,and a lots of learning opportunity in this company,and in every 6 month there is a appraisal

Skills evaluated in this interview

I applied via Naukri.com and was interviewed before Apr 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. 1. Explain SCD Type 2 Implementation in Informatica
  • Ans. 

    SCD Type 2 is a technique used to track historical changes in data over time in a data warehouse.

    • SCD Type 2 maintains a separate row for each change in data, with a start and end date.

    • It requires a surrogate key to uniquely identify each row.

    • Informatica provides a built-in SCD Type 2 transformation to implement this technique.

    • Example: tracking changes in customer addresses over time.

  • Answered by AI

Interview Preparation Tips

Interview preparation tips for other job seekers - Kindly focus on basic BI terminologies, common to trivial scenarios and introductory information on latest trending tools and technologies.

Skills evaluated in this interview

I applied via Campus Placement and was interviewed before Nov 2021. There were 3 interview rounds.

Round 1 - Resume Shortlist 
Pro Tip by AmbitionBox:
Keep your resume crisp and to the point. A recruiter looks at your resume for an average of 6 seconds, make sure to leave the best impression.
View all tips
Round 2 - Aptitude Test 

Moderate level aptitude with basics

Round 3 - Coding Test 

Moderate level data structure questions

Interview Preparation Tips

Interview preparation tips for other job seekers - Be confident and what what u speak because that is most important

Interview Questionnaire 

2 Questions

  • Q1. Basic javascript.. closures,hoisting, es6 features etc
  • Q2. Prototype in JavaScript
  • Ans. 

    Prototyping in JavaScript allows for quick and easy creation of new objects and functions.

    • Prototyping allows for inheritance and sharing of properties and methods.

    • New objects can be created using the 'new' keyword and the prototype of an existing object.

    • Functions can also be prototyped to add new methods or properties.

    • Example: function Person(name) { this.name = name; } Person.prototype.greet = function() { console.log...

  • Answered by AI

Skills evaluated in this interview

I applied via LinkedIn and was interviewed before Aug 2020. There were 3 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. All microsoft technologies related

Interview Preparation Tips

Interview preparation tips for other job seekers - Nothing

Interview Questionnaire 

1 Question

  • Q1. Questions on angular framework,.net core , dependency injection,legacy .net, session management , agile ceremonies.

I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.

Interview Preparation Tips

Interview preparation tips for other job seekers - Please be 100% technical in java here they will not be any support u need to dig deep lot of complex modules which we cannot understand in depth

I applied via Campus Placement and was interviewed before Sep 2020. There were 5 interview rounds.

Interview Questionnaire 

1 Question

  • Q1. Few DSA questions, questions about my projects and my resume. Also, since I specialise in python, if I could create an API using it. HR questions, hobbies, leadership experience...

Interview Preparation Tips

Interview preparation tips for other job seekers - Understanding the culture of J.P. Morgan Chase played a big role in passing the interview. The coding questions were easy/medium level. The interviewers were very friendly.

Interview Questionnaire 

1 Question

  • Q1. Frequency of each word ina sentence
  • Ans. 

    To find the frequency of each word in a sentence.

    • Split the sentence into words

    • Create a dictionary to store word frequency

    • Iterate through the words and update the dictionary

    • Return the dictionary

  • Answered by AI

Skills evaluated in this interview

Citicorp Interview FAQs

How many rounds are there in Citicorp IT Operations Lead interview?
Citicorp interview process usually has 2 rounds. The most common rounds in the Citicorp interview process are Resume Shortlist and Technical.
What are the top questions asked in Citicorp IT Operations Lead interview?

Some of the top questions asked at the Citicorp IT Operations Lead interview -

  1. A table is structured with rows and columns while view is derived from ta...read more
  2. Difference between table and v...read more

Tell us how to improve this page.

Citicorp IT Operations Lead Interview Process

based on 1 interview

Interview experience

3
  
Average
View more

Interview Questions from Similar Companies

Wells Fargo Interview Questions
3.8
 • 570 Interviews
HSBC Group Interview Questions
3.9
 • 487 Interviews
American Express Interview Questions
4.2
 • 364 Interviews
BNY Interview Questions
3.9
 • 346 Interviews
UBS Interview Questions
3.9
 • 338 Interviews
Morgan Stanley Interview Questions
3.7
 • 292 Interviews
FactSet Interview Questions
3.9
 • 208 Interviews
View all
Assistant Vice President
4.8k salaries
unlock blur

₹17 L/yr - ₹48.5 L/yr

Assistant Manager
3.3k salaries
unlock blur

₹6.1 L/yr - ₹20.7 L/yr

Officer
2.9k salaries
unlock blur

₹10.7 L/yr - ₹35.5 L/yr

Vice President
2.6k salaries
unlock blur

₹21 L/yr - ₹70 L/yr

Manager
2.3k salaries
unlock blur

₹11.5 L/yr - ₹38 L/yr

Explore more salaries
Compare Citicorp with

Wells Fargo

3.8
Compare

JPMorgan Chase & Co.

3.9
Compare

HSBC Group

3.9
Compare

Cholamandalam Investment & Finance

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