SMFG India Credit Miro Interview Questions and Answers

An Excel file was given which had 2 sheets, sheet1 with raw data and sheet2 with task. There were 5-6 questions in Task. This tasks can be done by formulas such as CONCAT, Textjoin, Age calculation using Datedif, Vlookup, age band creation eg: 10-30,30-40 based on age I used nested IF, PIVOT Table

Q1. What are your reasons for wanting to switch jobs?
Add your answer

Q1. Self introduction and work experience
Add your answer

Q1. Data analysis , v lookup, H look up
Add your answer

Q1. Introduce yourself ?
Ans. 
I am a detail-oriented MIS Coordinator with a strong background in data analysis and project management.
• Experienced in managing databases and ensuring data accuracy

• Skilled in generating reports and analyzing trends to support decision-making

• Proficient in project coordination and communication with stakeholders

• Familiar with various MIS software and tools such as Excel, SQL, and Tableau
Answered by AI
Add your answer
Q2. Tell me about your district?
Add your answer

Q1. Tell me something about yourself
Ans. 
I am an experienced MIS Executive with a strong background in managing information systems and data analysis.
• I have a Bachelor's degree in Management Information Systems.

• I have worked for 5 years in a multinational company as an MIS Executive.

• I am proficient in using various data analysis tools such as Excel, SQL, and Tableau.

• I have successfully implemented automated reporting systems that improved efficiency and accur...read more
Answered by AI
Add your answer
Q2. Qualifications,Experience, salary Expectations,last salary
Add your answer

Q1. Excel and Sql basic and advanced problems
Add your answer
Q2. How to use Vlookup ?
Ans. 
Vlookup is a function in Excel used to search for a value in a table and return a corresponding value from another column.
• Enter the formula =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) in a cell

• lookup_value is the value to search for in the first column of the table_array

• table_array is the range of cells that contains the data

• col_index_num is the column number in the table_array from which to retr...read more
Answered by AI
Add your answer
Q3. How to use Splitting?
Ans. 
Splitting is a technique used to divide a string into multiple parts based on a specified delimiter.
• Use the split() method in programming languages like Python, JavaScript, or Java to split a string into an array of substrings.

• Specify the delimiter (e.g. space, comma, hyphen) as an argument to the split() method.

• Access the individual parts of the split string using array indexing.

• Combine splitting with other string man...read more
Answered by AI
Add your answer
Q4. How to use pivot ?
Ans. 
Pivot is a function used in data analysis to summarize and reorganize data.
• Pivot can be used to reorganize rows into columns or columns into rows based on a specific variable.

• It is commonly used in Excel or other spreadsheet software to create summary tables or reports.

• Pivot tables can help analyze large datasets and identify trends or patterns.

• Example: In Excel, you can use the PivotTable feature to summarize sales da
Answered by AI
Add your answer
Q5. How to use concatenation?
Ans. 
Concatenation is the process of combining two or more strings together.
• Use the + operator to concatenate strings in most programming languages.

• In SQL, use the CONCAT function to concatenate strings.

• Concatenation can also be done using string interpolation in some languages.
Answered by AI
Add your answer