Corecard Software Analyst Interview Questions and Answers

Write SAR report explaining the Source of funds and typologies

Q1. Explain the Money laundering risks in charity
Ans. 
Charities can be used as a front for money laundering activities due to lack of transparency and oversight.
• Donors may use charities to disguise the source of illicit funds.

• Charities may unknowingly accept donations from criminal organizations.

• Funds raised for charitable purposes may be diverted for personal gain by individuals within the organization.

• Lack of proper due diligence on donors and beneficiaries increases th...read more
Answered by AI
Add your answer

General audit parameters

Q1. General excel formula
Add your answer
Q2. Why we do rca
Add your answer
Q3. How we calculate variancein calibration
Add your answer
Q4. Why we use dollar sign in excel
Add your answer

Q1. Types of Window Function
Ans. 
Window functions are used in SQL to perform calculations across a set of table rows related to the current row.
• Types include ROW_NUMBER(), RANK(), DENSE_RANK(), NTILE(), LAG(), LEAD(), FIRST_VALUE(), LAST_VALUE(), etc.

• They allow for calculations to be performed on a specific subset of rows within a query result set.

• Window functions are commonly used for running totals, moving averages, and ranking data.
Answered by AI
Add your answer
Q2. Difference between Joins with examples
Ans. 
Joins are used to combine rows from two or more tables based on a related column between them.
• Inner Join: Returns rows when there is a match in both tables.

• Left Join: Returns all rows from the left table and the matched rows from the right table.

• Right Join: Returns all rows from the right table and the matched rows from the left table.

• Full Outer Join: Returns rows when there is a match in one of the tables.

• Cross Join:
Answered by AI
Add your answer

Q1. Tell me brief about your self
Ans. 
I am a data analyst with a strong background in statistics and data visualization.
• Experienced in analyzing large datasets using SQL, Python, and R

• Skilled in creating insightful reports and dashboards using Tableau and Power BI

• Strong communication skills to present findings to stakeholders

• Certified in data analysis and machine learning techniques
Answered by AI
Add your answer
Q2. What are youre strenth and weekness
Ans. 
My strength lies in my analytical skills and attention to detail, while my weakness is sometimes getting too caught up in the details.
• Strength: Strong analytical skills

• Strength: Attention to detail

• Weakness: Getting caught up in details (provide example)
Answered by AI
Add your answer

Q1. Basic sql question were asked.
Add your answer

The aptitude test consisted of a few questions related to the company profile, such as what CIBIL is and the differences between secured and unsecured loans. The duration was half an hour. The test and the further process were transparent and smooth.

Q1. During the other interviews, as self-introductions began, the HR asked similar questions. Along with the self-introduction, the HR inquired about the organization, salary expectations, qualifications, and ...read more
Add your answer