IG International Accounts cum Admin Executive Interview Questions and Answers for Experienced

Q1. Tell me about yourself.
Add your answer

Q1. 1.Question to identify communication level
Add your answer
Q2. 2. Where did you work before
Add your answer

Q1. Why are looking to switch
Ans. 
Seeking new challenges and opportunities for growth
• Desire for new challenges and learning opportunities

• Current role lacks growth potential

• Interested in working with cutting-edge technologies

• Seeking better work-life balance
Answered by AI
Add your answer

Q1. Architecture of current project
Ans. 
The current project follows a microservices architecture with Docker containers and Kubernetes for orchestration.
• Microservices architecture is used to break down the application into smaller, independent services that can be developed, deployed, and scaled independently.

• Docker containers are used to package the application and its dependencies into a standardized unit for development, shipment, and deployment.

• Kubernete...read more
Answered by AI
Add your answer
Q2. How you decide ttl in redis
Ans. 
TTL in Redis is decided based on the desired expiration time for the data stored in the cache.
• Consider the nature of the data and how frequently it needs to be updated

• Take into account the memory constraints and performance requirements of the application

• Use a combination of default TTL values and custom TTL settings for different types of data

• Monitor the cache usage and adjust TTL values based on usage patterns
Answered by AI
Add your answer
Q3. Explain internals of LINQ
Ans. 
LINQ (Language Integrated Query) is a feature in C# that allows querying data from different data sources using a uniform syntax.
• LINQ allows querying data from collections, databases, XML, and other data sources using a common syntax.

• It provides a set of standard query operators like Where, Select, OrderBy, GroupBy, etc.

• LINQ queries are written in C# and are translated into equivalent SQL queries when querying database...read more
Answered by AI
Add your answer
Q4. ACID properties of relational DB
Ans. 
ACID properties ensure data integrity in relational databases.
• Atomicity: All transactions are either fully completed or fully aborted.

• Consistency: Data remains consistent before and after transactions.

• Isolation: Transactions are isolated from each other until they are completed.

• Durability: Once a transaction is committed, changes are permanent.

• Example: If a bank transfer fails midway, the entire transaction is rolled b...read more
Answered by AI
Add your answer

Q1. It was 1 hr technical round for iOS Developer role. Questions related to project I am working, iOS Development questions like (process of publishing app, push notifications and its uses, Delegates how to u...read more
Add your answer

Q1. It was 30 min managerial round with one of the technical manager of MRI. Asked technical questions based on my projects. And then tricky questions like why you want to join, why we should hire you, where d...read more
Add your answer

There were many questions to be solved within an hour, but the expectation was to solve maximum you can.

1 DSA based and 2 SQL coding questions with 5/6 DSA based MCQs

Q1. Write a python code to find missing element ranging from 0 to 100. Write a SQL query to fetch data from multiple tables. Questions based on types on Joins in SQL, Stored Procedures, Views and importance o...read more
Ans. 
Python code to find missing element and SQL query for fetching data from multiple tables.
• Python code to find missing element: Use set difference to find missing elements in range 0 to 100.

• SQL query for fetching data from multiple tables: Use JOINs like INNER JOIN, LEFT JOIN, or CROSS JOIN to combine data from multiple tables.

• Types of Joins in SQL: INNER JOIN, LEFT JOIN, RIGHT JOIN, FULL JOIN.

• Stored Procedures: Precompi...read more
Answered by AI
Add your answer

Q1. Explain Object-oriented Programming
Ans. 
Object-oriented programming is a programming paradigm that uses objects to represent and manipulate data.
• Encapsulation: bundling data and methods that operate on that data within one unit

• Inheritance: creating new classes from existing ones

• Polymorphism: ability of objects to take on many forms

• Examples: Java, C++, Python, Ruby
Answered by AI
Add your answer
Q2. Explain your projects.
Add your answer