40+ Associate Analyst Interview Questions and Answers for Freshers

Logic to find duplicate numbers in an array of 6 numbers

• Iterate through the array and compare each element with the rest of the elements

• If a match is found, print the duplicate number

• Use nested loops to compare all elements

• Alternatively, use a hash table to keep track of seen elements

Questions related to KYC, money laundering, CDD, EDD, and finance were asked for the Associate Analyst position.

• KYC stands for Know Your Customer and is the process of verifying the identity of a customer.

• KYC is important to prevent fraud, money laundering, and terrorist financing.

• Money laundering is the process of making illegally obtained money appear legitimate.

• The stages of money laundering include placement, layering, and integration.

• CDD stands for Customer Due Diligence...read more

Answering questions related to KYC, money laundering, and finance

• KYC stands for Know Your Customer and is the process of verifying the identity of a customer or client

• KYC is important to prevent fraud, money laundering, and terrorist financing

• Money laundering is the process of making illegally obtained money appear legitimate

• The stages of money laundering include placement, layering, and integration

• CDD stands for Customer Due Diligence and is the process of verifying the iden...read more

Joins are used to combine data from two or more tables based on a related column.

• Joins are used in SQL to retrieve data from multiple tables.

• Common types of joins include inner join, left join, right join, and full outer join.

• One case where I applied joins was when I needed to retrieve customer information and their corresponding orders from two separate tables.

• Another example is when I needed to combine data from a table of employees and a table of departments to determine w...read more

Google Shopping is an online marketplace that allows users to search for and compare products from various retailers.

• Google Shopping displays product listings from different retailers in one place

• Users can search for products and compare prices and features

• Retailers can list their products on Google Shopping to increase visibility and sales

• Google Shopping also offers features like product reviews and ratings

• Google Shopping is available on both desktop and mobile devices

Google Sheets offers collaborative, cloud-based spreadsheet functionalities with real-time editing and data analysis tools.

• Real-time collaboration: Multiple users can edit simultaneously, enhancing teamwork.

• Cloud storage: Access your sheets from any device with internet, ensuring flexibility.

• Data analysis tools: Functions like VLOOKUP and pivot tables help in complex data analysis.

• Integration with other G Suite tools: Easily import data from Google Forms or visualize it in Go...read more

Private companies are owned by individuals or a small group, while public companies are owned by shareholders.

• Private companies have fewer regulatory requirements than public companies.

• Public companies have to disclose financial information to the public.

• Private companies are not traded on stock exchanges, while public companies are.

• Ownership in private companies is not easily transferable, while public companies can be bought and sold easily.

• Examples of private companies inc...read more

I am proficient in SQL and have experience in writing complex queries.

• Proficient in writing complex queries

• Experience in working with large databases

• Familiarity with various SQL functions and operators

• Ability to optimize queries for better performance

I bring analytical skills, a collaborative mindset, and a passion for problem-solving, making me a strong fit for Deloitte's Associate Analyst role.

• Strong analytical skills: I excel in data analysis, demonstrated by my project where I improved efficiency by 20% through data-driven insights.

• Team collaboration: I thrive in team settings, as shown in my internship where I worked with cross-functional teams to deliver a successful project.

• Passion for problem-solving: I enjoy tack...read more

Red flags in AML refer to suspicious activities or behaviors that may indicate money laundering or terrorist financing.

• Unusual transactions or patterns, such as frequent large cash deposits or withdrawals

• Lack of a logical business explanation for transactions

• Use of shell companies or nominee accounts to obscure the true source of funds

• Customer reluctance to provide identification or other required information

• Transactions involving high-risk countries or politically exposed pe...read more

E-commerce has revolutionized the way we shop and do business.

• E-commerce has made shopping more convenient and accessible.

• It has opened up new markets and opportunities for businesses.

• E-commerce has also led to the rise of online payment systems and digital currencies.

• However, it has also raised concerns about privacy and security.

• Overall, e-commerce has had a significant impact on the global economy.

The 3 Golden Rules of Accounting guide how to record financial transactions accurately.

• 1. Debit the receiver, credit the giver: When a person or entity receives value, they are debited, while the giver is credited. Example: If a company sells goods for cash, cash (the receiver) is debited, and sales revenue (the giver) is credited.

• 2. Debit what comes in, credit what goes out: This rule applies to assets. When an asset comes into the business, it is debited, and when it goes o...read more

OpenCV project uses various libraries depending on the requirements.

• OpenCV core library

• OpenCV highgui library

• OpenCV imgproc library

• OpenCV video library

• OpenCV features2d library

• OpenCV objdetect library

• OpenCV ml library

• OpenCV calib3d library

• OpenCV stitching library

• OpenCV dnn library

Demonstrations in India are a common form of protest and expression of public opinion.

• Demonstrations in India are often organized by various groups to raise awareness about social, political, or economic issues.

• They can range from peaceful marches and rallies to more disruptive forms of protest like strikes and sit-ins.

• Demonstrations in India have played a significant role in shaping public discourse and influencing government policies.

• Some notable demonstrations in India inc...read more

Retrieve data from two tables using SQL JOIN to combine related records.

• Use INNER JOIN to get records that have matching values in both tables.

• Example: SELECT a.column1, b.column2 FROM tableA a INNER JOIN tableB b ON a.id = b.a_id;

• Use LEFT JOIN to get all records from the first table and matched records from the second.

• Example: SELECT a.column1, b.column2 FROM tableA a LEFT JOIN tableB b ON a.id = b.a_id;

• Ensure to specify the correct join condition to avoid Cartesian products...read more

Runtime polymorphism occurs at runtime, while static polymorphism is resolved at compile time, affecting method resolution.

• Definition: Runtime polymorphism (dynamic binding) allows method overriding, while static polymorphism (compile-time binding) allows method overloading.

• Example of Runtime: In Java, a subclass can override a method of its superclass, and the method called is determined at runtime.

• Example of Static: In Java, multiple methods can have the same name but diffe...read more

Corporate action refers to events initiated by a public company that impact its shareholders and securities.

• Types of corporate actions include dividends, stock splits, mergers and acquisitions, rights issues, and bonus issues.

• Dividends are payments made to shareholders from a company's profits.

• Stock splits involve dividing existing shares into multiple shares to lower the share price.

• Mergers and acquisitions are when two companies combine or one company takes over another.

• Rig...read more

Primary research involves collecting data directly from original sources, while secondary research involves analyzing existing data collected by others.

• Primary research is conducted by the researcher themselves, while secondary research involves using data collected by others.

• Primary research is time-consuming and expensive, while secondary research is quicker and more cost-effective.

• Examples of primary research include surveys, interviews, and experiments, while secondary re...read more

ESG stands for Environmental, Social, and Governance. CSR stands for Corporate Social Responsibility.

• ESG refers to the three central factors in measuring the sustainability and ethical impact of an investment in a company or business.

• CSR is a company's initiative to take responsibility for the environmental and social wellbeing of the communities around them.

• ESG and CSR are both important factors in evaluating a company's impact on society and the environment.

• Examples of ESG ...read more

I faced various challenges in technical projects, including time constraints, resource limitations, and technical complexities.

• Time Management: During a project, I had to deliver a complex data analysis report within a week, which required prioritizing tasks effectively.

• Resource Limitations: I worked on a project where the team was short-staffed, leading to increased workloads and necessitating collaboration and delegation.

• Technical Complexities: In a software development pro...read more

Private companies are owned by a small group of individuals and do not trade shares publicly, while public companies are owned by shareholders and trade shares on the stock market.

• Private companies have fewer regulatory requirements compared to public companies.

• Public companies have more transparency as they are required to disclose financial information to the public.

• Private companies have more flexibility in decision-making as they are not accountable to shareholders.

• Exampl...read more

SQL commands are used to interact with databases, while DSA questions test problem-solving skills.

• SQL commands include SELECT, INSERT, UPDATE, DELETE for querying and modifying data in databases

• Basic DSA questions may involve sorting algorithms, data structures like arrays, linked lists, trees

• Understanding of time complexity, space complexity, and problem-solving strategies is important

Wipro has faced challenges in terms of stability due to changes in leadership, market competition, and industry trends.

• Wipro has experienced frequent changes in leadership which can impact stability.

• The IT industry is highly competitive, leading to challenges in maintaining stability.

• Shifts in technology and industry trends can also affect Wipro's stability.

• Despite these challenges, Wipro has a strong track record and continues to adapt to market dynamics.

VLOOKUP is a function in Excel used to search for a value in a table and return a corresponding value from another column.

• VLOOKUP stands for 'vertical lookup'

• It is commonly used to search for a value in the leftmost column of a table and return a value in the same row from a specified column

• Syntax: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup])

• Example: =VLOOKUP(A2, B2:D10, 3, FALSE) - searches for the value in cell A2 in the range B2:D10 and returns the va...read more

Drag is the force that opposes motion through a fluid. There are two types of drag: parasitic and induced.

• Parasitic drag is caused by friction between the fluid and the surface of an object moving through it.

• Induced drag is caused by the creation of lift, which results in vortices trailing behind the object.

• Examples of parasitic drag include skin friction drag and pressure drag.

• Examples of induced drag include wingtip vortices and wake turbulence.

Yes, I am comfortable with rotational shifts.

• I have previous experience working in rotational shifts and have adapted well to the schedule.

• I understand the importance of flexibility in the workplace and am willing to adjust my schedule as needed.

• I have good time management skills which allow me to effectively plan my day regardless of the shift timing.

I plan to work here long-term, contributing to the team's success and growing my skills in the process.

• I see this role as a stepping stone in my career, where I can develop my analytical skills.

• I aim to build strong relationships with my colleagues and contribute to team projects.

• I am committed to continuous learning and hope to take on more responsibilities over time.

• I envision myself growing within the company and possibly taking on leadership roles in the future.