AmbitionBox
Interview Questions
- Reviews
- Salaries
- Interview Questions
- About Company
- Benefits
- Jobs
- Office Photos
- Community
Add office photos
Filter interviews by
Citicorp IT Operations Lead Interview Questions and Answers
Citicorp IT Operations Lead Interview Experiences
1 interview found
Anonymous
I applied via Company Website and was interviewed in Mar 2023. There was 1 interview round.
(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
- 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...
Interview Preparation Tips
Skills evaluated in this interview
Interview questions from similar companies
Interview Preparation Tips
Experience: The written test was quite similar to the typical CAT pattern. It contained sections on Reading Comprehension, Data Interpretation and Mathematics.
Round: Technical + HR Interview
Experience: There were 2 interviewers in the first interview, one was a technical guy and the other was from HR. They asked me a few very simple puzzles, a few basic programming questions (swapping the value of two variables etc.), questions related to the development cycle of software products. The HR guy asked stuff like what do you want to achieve in life? Strengths, weaknesses etc.
Round: Case Study Interview
Experience: The third interview was the most important one (and I guess that was the deciding interview). The interviewer started with questions like why finance? Which companies are you sitting for? Then he gave me a case study:
Interview Questionnaire
2 Questions
- Q1. Oops, os, dbms, project
- Q2. Why hsbc, why should I hire you.
- Ans.
I have a strong background in software engineering and a passion for innovation, making me a valuable asset to HSBC.
I have a proven track record of successfully delivering high-quality software solutions in previous roles.
I am highly skilled in various programming languages and technologies, including Java, Python, and SQL.
I have experience working in agile development environments, allowing me to adapt quickly to chan...
Interview Preparation Tips
Experience: 4 sections, 15 questions each. Sections on apti, english, programming, technical.
Tips: Time management, complete english and technical first
Duration: 1 hour
Total Questions: 60
Round: Group Discussion
Experience: We were asked which super hero would you like to be. Shared the information. Always present the positives and negatives and emphasize that despite of being negatives
Tips: Think everything through before speaking
Duration: 40 minutes
Round: Technical Interview
Experience: Prepare well, anything can be asked on the things written on your resume
Round: HR Interview
Experience: Sell yourself. Tell them why you would be the best candidate.
Tips: Tell your advantages of being a fresher that you would be comfortable in any technology
College Name: Acropolis institute of technology and research
SONELAL GUPTA
Interview Questionnaire
8 Questions
- Q1. Find a number which occurs odd number of times and all number occurs even number of times
- Q2. Some discussion about my minor project
- Q3. Spiral order of binary tree and mattrix, print it
- Q4. Some question about os,dbms
- Q5. Find pair which have a given sum in a given array
- Q6. Find total number of k element which have a given avg in a given array in minimum time complexity
- Q7. Print all elements which in not boundary element in a given binary tree
- Q8. Then some question about process synchronisation,error vs exception,and then 2-3 hr question
Interview Preparation Tips
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
What people are saying about Citicorp
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.
Interview Preparation Tips
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
I applied via Recruitment Consultant and was interviewed in Dec 2020. There was 1 interview round.
Interview Preparation Tips
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
Skills evaluated in this interview
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 May 2021. There was 1 interview round.
Interview Questionnaire
1 Question
- Q1. Core Java Thread Garbage collection hackerrank string anagrams springboot microservices
Interview Preparation Tips
Leetcode medium questions
Microservices scenario based questions related to scaling caching
Citicorp Interview FAQs
Tell us how to improve this page.
Citicorp Interviews By Designations
- Citicorp Analyst Interview Questions
- Citicorp Assistant Manager Interview Questions
- Citicorp Associate Vice President Interview Questions
- Citicorp Business Analyst Interview Questions
- Citicorp Officer Interview Questions
- Citicorp AVP Interview Questions
- Citicorp Software Developer Interview Questions
- Citicorp Assistant Vice President Interview Questions
- Show more
Interview Questions for Popular Designations
Overall Interview Experience Rating
based on 1 interview experience
Difficulty level
Interview Questions from Similar Companies
|
Assistant Vice President
5.2k
salaries
|  ₹28 L/yr - ₹45 L/yr |
|
Assistant Manager
3.2k
salaries
| ₹10.6 L/yr - ₹19 L/yr |
|
Officer
3k
salaries
| ₹17.6 L/yr - ₹31.5 L/yr |
|
Vice President
2.7k
salaries
| ₹39.3 L/yr - ₹65 L/yr |
|
Manager
2.3k
salaries
| ₹17 L/yr - ₹30 L/yr |
Wells Fargo
JPMorgan Chase & Co.
HSBC Group
Cholamandalam Investment & Finance
- Home >
- Interviews >
- Citicorp Interview Questions
