Filter interviews by
Clear (1)
I applied via Campus Placement and was interviewed in Sep 2023. There were 2 interview rounds.
Numerical resoaning, Verbal resonaing, logical reasoning
Startups Vs Corporate Jobs
Top trending discussions
I applied via LinkedIn and was interviewed in Feb 2023. There were 4 interview rounds.
Had a online test with questions related to kyc and screening.
I applied via LinkedIn and was interviewed in Jun 2022. There were 4 interview rounds.
Online assessment on behaviour
I applied via LinkedIn and was interviewed in Mar 2022. There was 1 interview round.
Answering questions related to Transaction Monitoring, Sanctions, Risk Assessment, AML, and Russia sanctions.
Transaction Monitoring is the process of monitoring financial transactions to identify suspicious activities.
Sanctioned countries are those that are subject to economic or trade sanctions imposed by governments or international organizations.
Sectoral sanctions are restrictions on specific sectors of a country's ...
General questions on aml and other red flags sanctions
AML transactions monitoring case study
I applied via Naukri.com and was interviewed in Jul 2022. There were 3 interview rounds.
I am proficient in several programming tools and rate myself highly in their usage.
Java - 5
Python - 4
SQL - 4
R - 3
MATLAB - 3
Tableau - 4
Excel - 5
SAS Macro is important for automating repetitive tasks and reducing code redundancy.
SAS Macro allows for parameterization of code, making it more flexible and reusable.
It can be used to automate repetitive tasks, saving time and effort.
Macro variables can be used to store and manipulate data, making code more efficient.
Macro functions can be used to perform complex calculations and data transformations.
SAS Macro can he...
Macro variables can be created using the %LET statement in SAS programming.
Use %LET statement followed by the macro variable name and its value.
Macro variables can be created with or without quotes around the value.
Macro variables can be referenced using & symbol followed by the variable name.
Example: %LET var1 = 10; %LET var2 = 'Hello';
Example: %LET var3 = &var1.;
To get a different dataset from an existing one, you can filter, sort, aggregate, or transform the data.
Filter the data by selecting specific rows or columns based on certain criteria.
Sort the data by arranging it in ascending or descending order based on one or more columns.
Aggregate the data by grouping it based on one or more columns and calculating summary statistics.
Transform the data by applying mathematical or l...
Null values in numeric data types can be removed using various methods.
Use the dropna() function in pandas library to remove null values.
Replace null values with a default value using fillna() function.
Use the interpolate() function to fill null values with interpolated values.
Use the drop() function to remove rows or columns with null values.
Use the notnull() function to filter out null values from the data.
Add function is used to concatenate two or more strings or add numbers, while sum function is used to add numbers only.
Add function can be used to concatenate strings like 'hello' and 'world' to form 'helloworld'
Add function can also be used to add numbers like 2 and 3 to form 5
Sum function is used to add numbers only, like sum(2,3) will return 5
Retain statement is used to store the value of a variable across iterations of a data step.
Retain statement is used to keep the value of a variable from one iteration of a data step to the next.
It is commonly used to calculate running totals or to keep track of previous values.
Retain statement is placed before the SET statement in a data step.
Example: retain total; total + sales; output;
Retain statement can also be use...
Removing duplicate records using first. and last. functions.
Use the first. and last. functions to select the first and last occurrence of each record.
Sort the data by the key field to ensure that the first and last records are selected correctly.
Use the delete statement to remove the duplicate records.
To get cumulative salary from an employee table, you can use SQL aggregate function SUM() along with GROUP BY clause.
Write a SQL query to select the employee ID and the sum of their salaries from the employee table.
Use the SUM() function to calculate the cumulative salary for each employee.
Group the results by employee ID using the GROUP BY clause.
The query should look like: SELECT employee_id, SUM(salary) FROM employe...
Tableau can connect to SAS environment through ODBC or SAS/ACCESS Interface.
Tableau can use ODBC to connect to SAS environment and access data.
SAS/ACCESS Interface can also be used to connect Tableau to SAS environment.
Tableau can directly connect to SAS datasets and tables.
Tableau can also use SAS data connectors to access data from SAS environment.
A calculative field in SAS is a field that is created by performing calculations on existing fields.
Calculative fields are created using SAS functions and expressions.
They can be used to perform complex calculations and transformations on data.
Examples include calculating averages, percentages, and ratios.
Calculative fields can be added to existing datasets or created as part of a data transformation process.
Blending in Tableau is combining data from multiple sources to create a single view.
Blending allows for analysis of data from different sources without the need for merging.
Data sources can be blended based on common fields or dimensions.
Blending can be used to create a single view with data from multiple sources.
Example: Blending sales data from Excel with customer data from a database to analyze customer behavior.
Exa...
Tableau has various filters including dimension filters, measure filters, top N filters, wildcard filters, and context filters.
Dimension filters allow you to filter data based on specific dimensions such as category or region.
Measure filters filter data based on measures like sales or profit.
Top N filters allow you to filter the top or bottom N values based on a measure.
Wildcard filters filter data based on a specific ...
Datamart is a subset of a data warehouse that is designed for a specific business unit or department.
Data warehouse is a centralized repository that stores data from various sources for business intelligence purposes.
Data warehouse is designed for enterprise-wide querying and analysis.
Datamart is a subset of a data warehouse that is designed for a specific business unit or department.
Datamart contains a subset of data ...
We use a multi-step process to cleanse data, including removing duplicates, correcting errors, and standardizing formats.
Identify and remove duplicates
Correct errors such as misspellings and inconsistent data formats
Standardize data formats to ensure consistency
Validate data against external sources
Perform manual review and verification as needed
CSV is a plain text file format while Excel is a binary file format.
CSV files contain data separated by commas while Excel files can contain multiple sheets and complex formatting.
CSV files can be easily opened in any text editor while Excel files require Microsoft Excel or a compatible program.
CSV files are smaller in size compared to Excel files.
CSV files are commonly used for data exchange between different systems ...
I have prepared various dashboards for different purposes.
Sales dashboard for tracking revenue and sales performance
Marketing dashboard for monitoring campaign effectiveness and lead generation
Financial dashboard for analyzing financial data and forecasting
Operational dashboard for tracking operational metrics and KPIs
Customer service dashboard for monitoring customer satisfaction and support metrics
I present my report to my immediate supervisor and other relevant stakeholders.
Reports are presented to the immediate supervisor for review and approval.
Reports may also be presented to other stakeholders such as department heads or clients.
The presentation format may vary depending on the audience and purpose of the report.
Adhoc reports requested by clients vary depending on their needs and objectives.
Client may request reports on sales performance, customer behavior, or market trends.
Reports may be in the form of tables, graphs, or charts.
Clients may also request customized reports based on specific criteria or filters.
Adhoc reports are usually requested on a one-time basis and may not follow a regular schedule.
I was interviewed in Feb 2021.
I was interviewed in Apr 2024.
General cultural fit test
posted on 4 Dec 2016
I applied via Campus Placement and was interviewed in Dec 2016. There were 5 interview rounds.
Yes, I have coded in curriculum. The most complex one was a project on building a web application using React and Node.js.
Built a full-stack web application using React and Node.js
Implemented user authentication and authorization using JSON Web Tokens (JWT)
Used MongoDB as the database and Mongoose as the ODM
Implemented real-time updates using Socket.IO
Deployed the application on Heroku
Handled errors and implemented log
Big data refers to large and complex data sets that cannot be processed using traditional data processing methods.
Big data is characterized by its volume, velocity, and variety
It is used in various industries such as healthcare, finance, and retail
Examples of big data include social media data, sensor data, and transactional data
It is called 'big' because it involves processing massive amounts of data
Big data requires ...
I am passionate about technology and eager to learn new skills in the IT sector.
I have always had a keen interest in technology and enjoy working with computers.
I believe the IT sector offers more opportunities for growth and advancement in my career.
I have seen the impact of technology on various industries and want to be a part of that innovation.
I have taken courses in programming and networking to prepare myself fo
To find the product of all data points using SelectSum(), log(), and exp() functions.
Use the log() function to convert the product into a sum of logarithms
Apply the SelectSum() function to calculate the sum of logarithms
Finally, use the exp() function to convert the sum back into the product
based on 1 interview
Interview experience
based on 1 review
Rating in categories
Assistant Manager
2.6k
salaries
| ₹0 L/yr - ₹0 L/yr |
Manager
2.1k
salaries
| ₹0 L/yr - ₹0 L/yr |
Senior Software Engineer
1.7k
salaries
| ₹0 L/yr - ₹0 L/yr |
Assistant Vice President
1.5k
salaries
| ₹0 L/yr - ₹0 L/yr |
Software Engineer
1.4k
salaries
| ₹0 L/yr - ₹0 L/yr |
Standard Chartered
ICICI Bank
Axis Bank
HDFC Bank