Filter interviews by
I applied via Referral and was interviewed in Apr 2021. There were 3 interview rounds.
Live vs Extract in Tableau and why Extract is faster
Live connection directly queries the data source while Extract creates a static snapshot of the data
Extracts are faster because they reduce the amount of data transferred over the network
Extracts can be scheduled to refresh at specific intervals
Extracts can be compressed to reduce file size and improve performance
Yes, it is possible to update data in Tableau Extract.
Tableau Extracts can be refreshed to update data
Data can be added, removed or modified in the data source and then refreshed in Tableau
Extracts can be set to refresh automatically or manually
Relationships are used to connect tables in Tableau Prep while Joins are used to combine tables in Tableau Desktop.
Relationships are used in Tableau Prep to connect tables based on common fields.
Joins are used in Tableau Desktop to combine tables based on common fields.
Relationships are used to create a flow of data between tables in Tableau Prep.
Joins are used to create a single table from multiple tables in Tableau D...
Dashboard Actions are interactive elements that allow users to interact with the data on a dashboard.
Dashboard Actions are used to filter, highlight, or navigate to other dashboards or web pages.
Steps to apply Dashboard Actions include selecting the element to apply the action to, choosing the type of action, and configuring the action settings.
Examples of Dashboard Actions include clicking on a chart to filter the dat...
Use a parameter to filter data and create two separate tables, then combine them using a union.
Create a parameter to select the number of top and bottom rankings to display
Create a table for the top rankings using the parameter and the RANKX function
Create a table for the bottom rankings using the parameter and the RANKX function
Combine the two tables using a union
Add a column to differentiate between top and bottom ra
Sets are a collection of unique values while groups are a collection of related values.
Sets contain only unique values while groups can have repeated values.
Sets are used for filtering data while groups are used for aggregating data.
Sets are used in Tableau for creating custom fields while groups are used for creating hierarchies.
Example of a set: a set of customers who have made a purchase in the last month.
Example of...
Optimize data source, reduce number of rows/columns, use extracts, optimize queries, use filters.
Optimize data source by removing unnecessary columns and rows
Reduce number of rows and columns to only necessary data
Use extracts instead of live connections
Optimize queries by using custom SQL or aggregating data
Use filters to limit the amount of data being extracted
Large data extracts in Tableau are handled by optimizing data sources, using filters, and aggregating data.
Optimize data sources by removing unnecessary columns and filtering data before extracting.
Use filters to limit the amount of data extracted.
Aggregate data to reduce the number of rows and columns.
Consider using Tableau's data engine to improve performance.
Use incremental extracts to only extract new or updated da...
Top trending discussions
I appeared for an interview before Dec 2020.
Round duration - 60 Minutes
Round difficulty - Medium
This round focused more on the Operating Systems part followed by some questions from Microservices Architecture.
Bootstrap program is the initial code that runs when a computer is powered on, loading the operating system into memory.
Bootstrap program is stored in ROM or firmware.
It initializes the system hardware and loads the operating system kernel into memory.
Examples include BIOS in PCs and UEFI in modern systems.
Memory protection in operating systems is a feature that prevents a process from accessing memory that has not been allocated to it.
Memory protection helps prevent one process from interfering with the memory of another process.
It ensures that each process can only access memory that has been allocated to it.
Examples of memory protection mechanisms include segmentation and paging.
Segmentation divides memory into segmen...
Four necessary and sufficient conditions for deadlock
Mutual exclusion: Resources cannot be shared between processes. Example: Process A holding Resource 1 and waiting for Resource 2, while Process B holding Resource 2 and waiting for Resource 1.
Hold and wait: Processes hold resources while waiting for others. Example: Process A holding Resource 1 and waiting for Resource 2, while Process B holding Resource 2 and waitin...
Microservices design is characterized by modularity, independence, scalability, and resilience.
Modularity: Microservices are designed as independent modules that can be developed, deployed, and scaled separately.
Independence: Each microservice operates independently and communicates with other services through APIs.
Scalability: Microservices allow for scaling specific components of an application based on demand.
Resili...
Different strategies for deploying microservices include blue-green deployment, canary deployment, rolling deployment, and feature flagging.
Blue-green deployment involves running two identical production environments, with one serving as the active environment while the other is on standby. Traffic is switched from one environment to the other once the new version is deemed stable.
Canary deployment gradually rolls out ...
Round duration - 60 Minutes
Round difficulty - Medium
This round was preety much mixed and contained questions from DBMS, Java and more importantly Spring Boot.
Normalization is needed in a database to reduce data redundancy, improve data integrity, and optimize database performance.
Eliminates data redundancy by breaking down data into smaller tables
Reduces update anomalies and inconsistencies in data
Improves data integrity by enforcing relationships between tables
Optimizes database performance by reducing storage space and improving query efficiency
Views in SQL are virtual tables that are generated based on the result set of a SELECT query.
Views are not stored physically in the database, but are dynamically generated when queried.
They can be used to simplify complex queries by encapsulating logic and joining multiple tables.
Views can also be used to restrict access to certain columns or rows of a table.
Example: CREATE VIEW vw_employee AS SELECT emp_id, emp_name F
Dependency injection is a design pattern where components are given their dependencies rather than creating them internally.
Allows for easier testing by providing mock dependencies
Promotes loose coupling between components
Improves code reusability and maintainability
Examples: Constructor injection, Setter injection, Interface injection
Profiles in Spring Boot allow for different configurations to be applied based on the environment or specific needs.
Profiles can be used to define different sets of configurations for different environments such as development, testing, and production.
By using profiles, you can easily switch between configurations without changing the code.
Profiles are typically defined in application.properties or application.yml file...
Access specifiers in Java control the visibility of classes, methods, and variables.
There are four access specifiers in Java: public, protected, default (no specifier), and private.
Public: accessible from any other class.
Protected: accessible within the same package or subclasses.
Default: accessible only within the same package.
Private: accessible only within the same class.
JIT compiler stands for Just-In-Time compiler, which compiles code during runtime instead of ahead of time.
JIT compiler translates bytecode into machine code on the fly
Improves performance by optimizing frequently executed code
Examples include Java HotSpot, .NET CLR's JIT compiler
Round duration - 30 Minutes
Round difficulty - Easy
This is a cultural fitment testing round .HR was very frank and asked standard questions. Then we discussed about my role.
Tip 1 : Must do Previously asked Interview as well as Online Test Questions.
Tip 2 : Go through all the previous interview experiences from Codestudio and Leetcode.
Tip 3 : Do at-least 2 good projects and you must know every bit of them.
Tip 1 : Have at-least 2 good projects explained in short with all important points covered.
Tip 2 : Every skill must be mentioned.
Tip 3 : Focus on skills, projects and experiences more.
I applied via Naukri.com and was interviewed in Sep 2020. There were 3 interview rounds.
posted on 14 Mar 2021
posted on 29 Jan 2021
I applied via Naukri.com and was interviewed in Jul 2020. There were 4 interview rounds.
posted on 2 Oct 2018
I applied via Recruitment Consulltant and was interviewed before Mar 2021. There were 2 interview rounds.
I applied via Walk-in and was interviewed before Oct 2020. There were 3 interview rounds.
posted on 10 Feb 2022
I applied via Naukri.com and was interviewed before Feb 2021. There were 2 interview rounds.
I applied via Campus Placement and was interviewed in Jul 2020. There was 1 interview round.
Some of the top questions asked at the Barclays Global Service Centre Senior Business Intelligence Analyst interview -
Assistant Vice President
726
salaries
| ₹14.5 L/yr - ₹42.2 L/yr |
Process Advisor
404
salaries
| ₹1 L/yr - ₹7.5 L/yr |
Senior Analyst
362
salaries
| ₹3.5 L/yr - ₹11.8 L/yr |
Assistant Manager
264
salaries
| ₹6.5 L/yr - ₹24 L/yr |
Vice President
186
salaries
| ₹27 L/yr - ₹74.7 L/yr |
DXC Technology
Mphasis
Sutherland Global Services
Optum Global Solutions