Infosys Senior SQL Developer Interview Questions and Answers

Q1. Questions related to the current and past projects.
Add your answer
Q2. Aws related questions.
Add your answer
Q3. Data warehousing basics
Add your answer

Q1. Explain about the roles and responsibilities.
Add your answer
Q2. Discussion about the role in Genpact.
Add your answer

Q1. Asked about expectated salary
Add your answer
Q2. Why are you switching
Add your answer

Q1. Window function coding test
Ans. 
Window function coding test involves using window functions in SQL to perform calculations within a specified window of rows.
• Understand the syntax and usage of window functions in SQL

• Use window functions like ROW_NUMBER(), RANK(), DENSE_RANK(), etc. to perform calculations

• Specify the window frame using PARTITION BY and ORDER BY clauses

• Practice writing queries with window functions to get comfortable with their usage
Answered by AI
Add your answer
Q2. Explain azure data factory
Ans. 
Azure Data Factory is a cloud-based data integration service that allows you to create, schedule, and manage data pipelines.
• Azure Data Factory is used to move and transform data from various sources to destinations.

• It supports data integration processes like ETL (Extract, Transform, Load) and ELT (Extract, Load, Transform).

• You can create data pipelines using a visual interface in Azure Data Factory.

• It can connect to on...read more
Answered by AI
Add your answer

Q1. What is data vault
Ans. 
Data Vault is a modeling methodology for designing highly scalable and flexible data warehouses.
• Data Vault focuses on long-term historical data storage

• It consists of three main components: Hubs, Links, and Satellites

• Hubs represent business entities, Links represent relationships between entities, and Satellites store attributes of entities

• Data Vault allows for easy scalability and adaptability to changing business requ
Answered by AI
Add your answer
Q2. What is lambda architecture
Ans. 
Lambda architecture is a data processing architecture designed to handle massive quantities of data by using both batch and stream processing methods.
• Combines batch processing layer, speed layer, and serving layer

• Batch layer processes historical data in large batches

• Speed layer processes real-time data

• Serving layer merges results from batch and speed layers for querying

• Example: Apache Hadoop for batch processing, Apach
Answered by AI
Add your answer

Q1. Whether have onsite exposure
Ans. 
Yes, I have onsite exposure in previous roles.
• I have worked onsite at various client locations to gather requirements and implement solutions.

• I have experience collaborating with cross-functional teams in person.

• I have conducted onsite training sessions for end users on data architecture best practices.

• I have participated in onsite data migration projects.

• I have worked onsite to troubleshoot and resolve data-related is
Answered by AI
Add your answer

Q1. Tell about your self
Add your answer
Q2. Interested Technology
Add your answer

Q1. What is SQL where it use
Ans. 
SQL is a programming language used for managing and manipulating relational databases.
• SQL stands for Structured Query Language

• It is used to communicate with databases to perform tasks such as querying data, updating records, and creating tables

• Examples of SQL commands include SELECT, INSERT, UPDATE, DELETE
Answered by AI
Add your answer
Q2. What is Join and Procedure
Ans. 
Join is used to combine rows from two or more tables based on a related column, while Procedure is a set of SQL statements that perform a specific task.
• Join is used to retrieve data from multiple tables based on a related column

• Types of joins include INNER JOIN, LEFT JOIN, RIGHT JOIN, and FULL JOIN

• Procedure is a set of SQL statements stored in the database and executed when called

• Procedures can accept input parameters
Answered by AI
Add your answer

Q1. Architecture of sql
Ans. 
SQL architecture refers to the structure and components of a SQL database system.
• SQL architecture includes components like storage engine, query processor, and buffer manager.

• The storage engine manages data storage and retrieval, while the query processor processes SQL queries.

• The buffer manager handles caching and memory management to optimize performance.

• Examples of SQL architectures include MySQL, Oracle, and SQL Se
Answered by AI
Add your answer
Q2. Recovery models
Add your answer

Q1. Which version of talend you are using
Ans. 
I am using Talend version 7.3.1 for ETL development.
• I am currently using Talend version 7.3.1 for ETL development.

• The specific version of Talend being used is 7.3.1.

• Talend 7.3.1 offers various features and improvements for ETL processes.
Answered by AI
Add your answer

Sql queries on top clause

Q1. Why u want to join
Ans. 
I am passionate about database management and eager to contribute my skills to your team.
• I have a strong background in database administration

• I am excited about the opportunity to work with a reputable company like yours

• I am eager to learn and grow in my career as a SQL DBA
Answered by AI
Add your answer
Q2. What is the salary expectation
Ans. 
I am looking for a competitive salary based on my experience, skills, and the responsibilities of the role.
• Research the average salary range for MS SQL DBAs in your location and industry

• Consider your years of experience and any specialized skills or certifications you have

• Be prepared to negotiate based on the specific responsibilities and requirements of the role
Answered by AI
Add your answer

Performance tunning and sql profiler

Q1. Sql questions based on fundamental
Add your answer