Zensar Technologies Software Developer Interview Questions, Process, and Tips

Simple aptitude college level

Mostly just to see proper communication

Q1. Technical interview based on technical skills written in the resume
Add your answer
Q2. SQL joins and types plus code situation examples
Ans. 
Understanding SQL joins and types with code examples
• Types of SQL joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• INNER JOIN returns rows when there is at least one 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 JOIN returns rows when there is a match in...read more
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

This round mainly revolved around concepts from Data Warehouse and Big Data.

Q1. Can you explain the ETL process in a data warehouse?
Ans. 
ETL process involves extracting data from various sources, transforming it to fit the data warehouse schema, and loading it into the warehouse.
• Extract: Data is extracted from multiple sources such as databases, files, APIs, etc.

• Transform: Data is cleaned, filtered, aggregated, and transformed to match the data warehouse schema.

• Load: Transformed data is loaded into the data warehouse for analysis and reporting.

• Example: ...read more
Answered by AI
Add your answer
Q2. What are the different types of data marts in the context of data warehousing?
Ans. 
Data marts are subsets of data warehouses that focus on specific business areas or departments.
• Types of data marts include dependent data marts, independent data marts, and hybrid data marts.

• Dependent data marts rely on the data warehouse for data, while independent data marts do not.

• Hybrid data marts combine elements of both dependent and independent data marts.

• Examples of data marts include sales data mart, marketing
Answered by AI
Add your answer
Q3. What is the difference between a Fact Table and a Dimension Table in a Data Warehouse?
Ans. 
Fact Table contains quantitative data and measures, while Dimension Table contains descriptive attributes.
• Fact Table contains numerical data that can be aggregated (e.g. sales revenue, quantity sold)

• Dimension Table contains descriptive attributes for analysis (e.g. product name, customer details)

• Fact Table typically has a larger number of rows compared to Dimension Table

• Fact Table is usually normalized, while Dimension...read more
Answered by AI
Add your answer
Q4. Can you explain what outliers are in the context of big data?
Ans. 
Outliers are data points that significantly differ from the rest of the data in a dataset.
• Outliers can skew statistical analysis and machine learning models.

• They can be caused by errors in data collection, measurement errors, or genuine anomalies.

• For example, in a dataset of employee salaries, a CEO's salary may be an outlier compared to the rest of the employees' salaries.
Answered by AI
Add your answer
Q5. How do you deploy a Big Data model? Please mention the key steps involved.
Ans. 
Deploying a Big Data model involves several key steps to ensure successful implementation.
• Prepare the data for deployment by cleaning and transforming it as needed.

• Choose the appropriate deployment environment, such as on-premises or cloud-based.

• Implement the model using a suitable technology stack, such as Hadoop or Spark.

• Test the deployed model to ensure accuracy and efficiency.

• Monitor the performance of the deployed...read more
Answered by AI
Add your answer

Round duration - 60 Minutes
Round difficulty - Medium

In this round, the interviewer asked me questions mainly from Tableau and Power BI.

Q1. What are the different types of joins in Tableau?
Ans. 
Different types of joins in Tableau include Inner Join, Left Join, Right Join, and Full Outer Join.
• Inner Join: Returns only the rows that have matching values 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 all rows when there is a match in either l
Answered by AI
Add your answer
Q2. How do you generally perform load testing in Tableau?
Ans. 
Load testing in Tableau involves using tools like TabJolt or custom scripts to simulate user activity and measure performance.
• Use TabJolt, a free load testing tool provided by Tableau, to simulate user activity and measure performance.

• Create custom scripts using tools like JMeter or Selenium to simulate user interactions and test performance under different load conditions.

• Monitor server performance metrics during load...read more
Answered by AI
Add your answer
Q3. What are the various types of filters in Tableau?
Ans. 
Various types of filters in Tableau include extract filters, context filters, data source filters, and quick filters.
• Extract filters: Filters data directly from the extract before it is loaded into Tableau.

• Context filters: Filters data based on the order of operations in Tableau, allowing for more control over filtering.

• Data source filters: Filters data at the data source level before it is loaded into Tableau.

• Quick fi...read more
Answered by AI
Add your answer
Q4. What are the building blocks of Power BI?
Ans. 
The building blocks of Power BI include datasets, reports, dashboards, and workspaces.
• Datasets - the foundation of Power BI, containing the raw data for analysis

• Reports - visual representations of data from datasets

• Dashboards - a collection of visuals from reports for monitoring key metrics

• Workspaces - collaborative environments for sharing and managing Power BI content
Answered by AI
Add your answer
Q5. What is the comprehensive working system of Power BI?
Ans. 
Power BI is a business analytics tool that provides interactive visualizations and business intelligence capabilities.
• Power BI allows users to connect to a wide variety of data sources and create interactive reports and dashboards.

• Users can easily share their insights with others by publishing their reports to the Power BI service.

• Power BI also offers AI capabilities for data analysis and visualization, such as natural...read more
Answered by AI
Add your answer
Q6. What is the difference between Power BI and Tableau?
Ans. 
Power BI is a Microsoft business analytics tool while Tableau is a data visualization tool with more advanced features.
• Power BI is more user-friendly and integrates well with other Microsoft products.

• Tableau has more advanced visualization capabilities and is preferred for complex data analysis.

• Power BI is better suited for organizations already using Microsoft products, while Tableau is more popular among data analyst...read more
Answered by AI
Add your answer
Q7. What is the difference between OLAP and OLTP?
Ans. 
OLAP is used for analyzing historical data while OLTP is used for managing real-time transactional data.
• OLAP stands for Online Analytical Processing, used for data analysis and reporting.

• OLTP stands for Online Transaction Processing, used for managing real-time transactional data.

• OLAP is optimized for read-heavy workloads, while OLTP is optimized for write-heavy workloads.

• OLAP databases are typically denormalized for f...read more
Answered by AI
Add your answer

Round duration - 30 Minutes
Round difficulty - Easy

This was a typical HR round with some standard Behavioral questions.

Q1. Can you tell me something about yourself?
Add your answer

1 question of middle difficulty

Q1. Concepts of oops and ds.
Add your answer
Q2. Classes and objects, inheritance, operator overloading etc.
Add your answer

Q1. What are your strengths and weaknesses?
Add your answer
Q2. Tell me about yourself.
Add your answer
Q3. Tell me about social websites to check verbal abilities?
Ans. 
Social websites like Twitter and Reddit can help improve verbal abilities through discussions and debates.
• Twitter allows users to engage in conversations and debates with people from all over the world.

• Reddit has various subreddits dedicated to discussions on different topics, which can help improve vocabulary and communication skills.

• Quora is another platform where users can ask and answer questions, which can help im
Answered by AI
Add your answer