Infotech Accounts & Finance Manager Interview Questions and Answers

Q1. Accounts & Finance working related
Add your answer

Q1. What is the accounts rules.
Add your answer
Q2. What is depreciation? Explain.
Ans. 
Depreciation is the process of allocating the cost of a fixed asset over its useful life. It represents the decrease in the value of an asset due to wear and tear, usage, or obsolescence. Example: If a company buys a machine for ₹1,00,000 with a lifespan of 10 years, instead of showing the full cost in one year, it spreads ₹10,000 per year as depreciation.
Answered Anonymously
Add your answer
Q3. What are the strength.
Add your answer
Q4. Why did you join this company.
Ans. 
"I want to join Genpact because it is a well-known company that offers great learning opportunities for freshers. It provides a good work environment, career growth, and a chance to improve my skills in accounting. I believe this is the best place to start my career and gain valuable experience."
Answered Anonymously
Add your answer
Q5. Tell me about our company.
Ans. 
"Genpact is a global professional services company that provides digital transformation, finance, and business process management solutions. Founded in 1997, it helps businesses improve efficiency using technology and innovation. Genpact operates in multiple countries and is known for its strong work culture and career growth opportunities."
Answered Anonymously
Add your answer

Online questions were based on scenarios to write SQL queries. Also got few questions on Python as well for which I had only limited knowledge.

Q1. I'm listing some of the questions here which the interviewers (2 panel resources) asked me regarding Informatica ETL, Oracle DB and I might have missed some of them. What types of indexes are used on Orac...read more
Add your answer
Q2. What happens if Treat source row property as "Update" at session level but at target object "Delete" is checked?
Ans. 
The source row will be treated as an update, but the target object will be deleted.
• The session level property 'Treat source row as Update' will be applied to the source row.

• The target object will be deleted regardless of the update status of the source row.

• This can result in data loss if the source row contains important information.
Answered by AI
Add your answer
Q3. What are the different types of dimension tables?
Ans. 
Dimension tables are used in data warehousing to provide descriptive information about the data in fact tables.
• Slowly changing dimensions

• Junk dimensions

• Degenerate dimensions

• Role-playing dimensions

• Bridge dimensions
Answered by AI
Add your answer
Q4. What schema type was used in your previous project? And explain why it was used?
Ans. 
We used a relational schema in our previous project as it was suitable for the data structure and allowed for efficient querying.
• Relational schema was used as it allowed for efficient querying of data

• The data structure was suitable for a relational schema

• We were able to easily join tables to retrieve necessary data

• Examples include using SQL to query a database with multiple tables

• Normalization was used to reduce data r
Answered by AI
Add your answer
Q5. Difference between Joiner and Lookup transformations?
Ans. 
Joiner combines data from multiple sources based on a common key, while Lookup retrieves data from a reference table based on a matching key.
• Joiner is used to combine data from two or more sources based on a common key column.

• Lookup is used to retrieve data from a reference table based on a matching key column.

• Joiner can perform inner, outer, left, and right joins, while Lookup can only perform an inner join.

• Joiner can...read more
Answered by AI
Add your answer
Q6. Scenario: I have records in a flat file ending with ; character at the end of each them. How to load these records into DB based on this character? What property will be used in Informatica?
Add your answer
Q7. How version control happened in your previous project?
Ans. 
We used Git for version control in our previous project.
• We created a Git repository for the project.

• All team members were added as collaborators to the repository.

• We followed the Git flow branching model.

• We used pull requests for code review and merging.

• We used tags to mark important releases.

• We regularly pushed our changes to the remote repository.

• We used Git commands like commit, push, pull, merge, and rebase.

• We used...read more
Answered by AI
Add your answer
Q8. Which SCD type you worked on before and explain on that?
Ans. 
I have worked on SCD Type 2 before.
• SCD Type 2 is used to track historical changes in data.

• It creates a new record for each change and maintains a history of changes.

• It includes start and end dates for each record.

• Example: Tracking changes in employee salary over time.
Answered by AI
Add your answer

Q1. This round was taken by the project manager on a phone call. He asked me few basic fundamental questions related to my skills and the things which I worked on in my previous project. He also told me about ...read more
Add your answer

Q1. Just F2F discussion with HR finalising on the compensation structure, learning opportunities and the organisational benefits as an employee.
Add your answer

Q1. Total Experience asking about feasible interview date and time slot fixing
Ans. Explaining to HR about my over all experience and years of experince..
Answered Anonymously
Add your answer

Q1. Asking questions from core experience
Ans. Answering them about Logistics,Reverse Logistics, Indirect Sourcing,Asset Management,3PL,Vendor and Supplier Management as i am from Supply chain Mangement Vertical
Answered Anonymously
Add your answer

Q1. Asking questions on real time scenario basis
Add your answer

Q1. Asking questions from Management aspect
Add your answer
Q2. Answering all the answers promptly keeping positivity,logical thinking,
Add your answer

Q1. HR related Questions
Add your answer

They had ask the simple question during my interview process, here is the list if all questions:
1) what is df.copy()
2)why we choose inplace = True
3) Tfidf
4) confusion Matrix
5) can we use continuous variables for logistic regression
6)list and tuple diff
7)N grams, bag of words
8)access a column
9)lambda fn
10)method and object oops concepts
11) how to tackle Nan values
12) what is index in SQL
13)what is gini coefficient
14)when will you use linear regression and when you will use Decision Tres.
15) Random forest
16)Oops concepts
17)how to calculate the coefficient
18)PCA
19)SL/USL
20) classification/Regression
21)SVM
22)DT, RF, Hyper parameters in RF
23)how neural network works
24)NlP

Q1. Power bi and Tableau tools- 1) cross filter
Add your answer

Round duration - 75 minutes
Round difficulty - Medium

This was an online coding round where we had 2 questions to solve under 75 minutes. I found both the questions to be of Easy to Medium level of difficulty.

Q1. 
Line Reflection Problem Statement
You are given several sets of points on a 2D plane, each set represented as a list of coordinates. Your task is to determine if there exists a line parallel to the Y-axis...read more
Ans. 
The task is to determine if there exists a line parallel to the Y-axis that reflects given points symmetrically.
• Iterate through each test case and check if a vertical reflection line exists for the given points

• Calculate the midpoint of the x-coordinates and check if it reflects the points symmetrically

• Consider edge cases where points are on the reflection line or have the same x-coordinate
Answered by AI
Add your answer
Q2. 
Number of Islands Problem Statement
You are provided with a 2-dimensional matrix having N rows and M columns, containing only 1s (land) and 0s (water). Your goal is to determine the number of islands in t...read more
Ans. 
Count the number of islands in a 2D matrix of 1s and 0s.
• Iterate through the matrix and perform depth-first search (DFS) to find connected 1s.

• Mark visited cells to avoid redundant traversal.

• Increment island count whenever a new island is encountered.
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

This round had 2 coding questions followed by some questions from DBMS.

Q1. 
Largest Rectangle in Histogram Problem Statement
You are given an array/list HEIGHTS of length N, where each element represents the height of a histogram bar. The width of each bar is considered to be 1.
...read more
Ans. 
Find the area of the largest rectangle that can be formed within the bounds of a given histogram.
• Iterate through the histogram bars and calculate the area of the largest rectangle that can be formed using each bar as the height.

• Use a stack to keep track of the indices of the bars in non-decreasing order of height.

• Pop elements from the stack and calculate the area until a smaller height bar is encountered.

• Update the max...read more
Answered by AI
Add your answer
Q2. 
Valid Parentheses Problem Statement
Given a string 'STR' consisting solely of the characters “{”, “}”, “(”, “)”, “[” and “]”, determine if the parentheses are balanced.
Input:
The first line contains an...read more
Ans. 
The task is to determine if a given string consisting of parentheses is balanced or not.
• Iterate through the characters of the string and use a stack to keep track of opening parentheses.

• If an opening parenthesis is encountered, push it onto the stack.

• If a closing parenthesis is encountered, check if it matches the top of the stack. If it does, pop the stack, else the string is not balanced.

• At the end, if the stack is e...read more
Answered by AI
Add your answer
Q3. Can you explain the concept of ACID properties in DBMS?
Ans. 
ACID properties in DBMS ensure data integrity and consistency in transactions.
• Atomicity: All operations in a transaction are completed successfully or none at all.

• Consistency: Data is always in a valid state before and after a transaction.

• Isolation: Transactions are isolated from each other to prevent interference.

• Durability: Once a transaction is committed, changes are permanent and survive system failures.

• Example: If...read more
Answered by AI
Add your answer
Q4. Can you explain the different levels of data abstraction in a DBMS?
Ans. 
Levels of data abstraction in a DBMS refer to the different views of data provided to users and applications.
• Physical level: Deals with how data is stored on the storage media. Example: data blocks, pages, indexes.

• Logical level: Focuses on how data is represented to users. Example: tables, views, constraints.

• View level: Provides a customized view of the database for specific users or applications. Example: queries, rep
Answered by AI
Add your answer

Round duration - 60 minutes
Round difficulty - Medium

Standard DS/Algo round with 2 coding questions followed by 2 interesting puzzles.

Q1. 
Cycle Detection in Undirected Graph Problem Statement
You are provided with an undirected graph containing 'N' vertices and 'M' edges. The vertices are numbered from 1 to 'N'. Your objective is to determi...read more
Ans. 
Detect if an undirected graph contains a cycle by exploring all possible paths.
• Use Depth First Search (DFS) algorithm to traverse the graph and detect cycles.

• Maintain a visited set to keep track of visited vertices and a parent pointer to avoid visiting the same vertex twice.

• If a visited vertex is encountered that is not the parent of the current vertex, a cycle is present.

• Consider edge cases like disconnected graphs a
Answered by AI
Add your answer
Q2. 
Maximum 1s in a Row Problem
Given a matrix ARR with dimensions N * M, consisting only of 0s and 1s where each row is sorted, determine the index of the row that contains the highest number of 1s. If multi...read more
Ans. 
Find the row with the maximum number of 1s in a sorted matrix.
• Iterate through each row of the matrix and count the number of 1s in each row

• Keep track of the row index with the maximum number of 1s

• Return the index of the row with the highest count of 1s
Answered by AI
Add your answer
Q3. You have two wires of different lengths, each taking different amounts of time to burn completely. How can you use these wires to measure a specific duration of time?
Ans. 
By lighting both wires at the same time, the shorter wire will burn out first, allowing you to measure a specific duration of time.
• Light both wires at the same time

• Measure the time it takes for the shorter wire to burn out completely

• The remaining length of the longer wire will indicate the specific duration of time
Answered by AI
Add your answer
Q4. You have 3 ants located at the corners of a triangle. The challenge is to determine the movement pattern of the ants if they all start moving towards each other. What will be the outcome?
Add your answer