Esec Security Consultant Interview Questions and Answers

Q1. Introduction, Current project overview and your role and responsibilities
Add your answer
Q2. Agile Ceremonies, Role of QA in Agile
Ans. 
Agile ceremonies are key meetings in Agile methodology where QA plays a crucial role in ensuring quality throughout the development process.
• QA participates in Agile ceremonies such as Sprint Planning, Daily Stand-ups, Sprint Review, and Sprint Retrospective to provide input on quality aspects.

• QA helps in defining acceptance criteria for user stories during Sprint Planning to ensure that the team understands the quality...read more
Answered by AI
Add your answer
Q3. Story Estimation Techniques in Agile
Ans. 
Story estimation techniques in Agile involve using relative sizing, planning poker, and t-shirt sizing.
• Relative sizing compares the size of one story to another to estimate effort.

• Planning poker involves team members individually estimating stories and then discussing differences.

• T-shirt sizing categorizes stories into small, medium, large, etc. based on complexity.

• Fibonacci sequence can be used for story points (1, 2,
Answered by AI
Add your answer
Q4. Updating scrum board and its process
Ans. 
Updating the scrum board involves adding, moving, and removing tasks to reflect the current status of the project.
• Regularly update the scrum board with the progress of tasks

• Move tasks from 'To Do' to 'In Progress' to 'Done' columns as they are worked on and completed

• Remove tasks that are no longer relevant or have been completed

• Ensure the team is aware of any changes made to the scrum board
Answered by AI
Add your answer
Q5. Different type of SQL Joins
Ans. 
SQL Joins are used to combine rows from two or more tables based on a related column between them.
• 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 one of the tables
Answered by AI
Add your answer
Q6. Test Plan, test Report in detal
Add your answer
Q7. Testing tools used
Ans. 
I have experience using a variety of testing tools such as Selenium, Jira, and TestRail.
• Selenium

• Jira

• TestRail
Answered by AI
Add your answer
Q8. Years of experience in team leading and challenges faced
Ans. 
Over 5 years of experience leading QA teams, faced challenges in communication, resource allocation, and stakeholder management.
• Managed a team of 10 QA engineers, ensuring timely delivery of high-quality testing.

• Challenges included resolving conflicts within the team, prioritizing tasks based on project deadlines, and effectively communicating with stakeholders.

• Implemented agile methodologies to improve team efficiency...read more
Answered by AI
Add your answer
Q9. Questions on Finance domain like derivatives, equity , Regulatory reports
Add your answer

Basic Financial Accounting concepts
Email Writing
Logical Reasoning

Q1. What goes in the line items of Income Statement?
Ans. 
Line items in an Income Statement include revenues, expenses, gains, and losses.
• Revenue: Sales of goods or services

• Cost of Goods Sold (COGS): Direct costs related to producing goods sold

• Gross Profit: Revenue minus COGS

• Operating Expenses: Costs related to running the business (e.g. salaries, rent)

• Operating Income: Gross profit minus operating expenses

• Interest Expense: Cost of borrowing money

• Net Income: Total profit afte...read more
Answered by AI
Add your answer
Q2. What is Investment Banking?
Ans. 
Investment banking involves providing financial advisory services to corporations, governments, and other institutions for raising capital, mergers and acquisitions, and other financial transactions.
• Helps companies raise capital through issuing stocks or bonds

• Assists in mergers and acquisitions by providing valuation and negotiation services

• Provides financial advisory services for various transactions such as IPOs, deb...read more
Answered by AI
Add your answer
Q3. Explain the impact of share buyback on the 3 financial statements.
Ans. 
Share buybacks impact financial statements by reducing outstanding shares, increasing EPS, and affecting cash flow.
• Share buybacks reduce the number of outstanding shares on the balance sheet.

• This can increase earnings per share (EPS) as the same amount of earnings is distributed among fewer shares.

• On the income statement, share buybacks can lead to higher EPS and potentially higher stock prices.

• Share buybacks can also ...read more
Answered by AI
Add your answer
Q4. Impact of bonus share issue on 3 financial statements.
Ans. 
Bonus share issue impacts financial statements by increasing equity on balance sheet, reducing retained earnings, and affecting earnings per share.
• Increase in equity on balance sheet due to additional shares issued at no cost

• Reduction in retained earnings as company's profits are distributed among more shareholders

• Impact on earnings per share as number of shares outstanding increases
Answered by AI
Add your answer

Q1. GDS Commands
Add your answer
Q2. Airline Terminals and Airport Codes
Add your answer

Sabre Commands to Check Availability

Blocking and Booking Tickets

Commands to Check Fare rules

Checking Availability

Infant and Child title

Q1. About Airport Terminals
Add your answer
Q2. About Encode and Decode in GDS
Add your answer

Q1. What are the assumptions of Linear Regression?
Ans. 
Assumptions of Linear Regression
• Linearity: The relationship between the independent and dependent variables is linear.

• Independence: The residuals are independent of each other.

• Homoscedasticity: The variance of residuals is constant across all levels of the independent variables.

• Normality: The residuals are normally distributed.

• No multicollinearity: The independent variables are not highly correlated with each other.
Answered by AI
Add your answer
Q2. How to evaluate your machine learning model?
Ans. 
Evaluate machine learning model by analyzing metrics like accuracy, precision, recall, F1 score, ROC curve, and confusion matrix.
• Calculate accuracy to measure overall performance of the model.

• Use precision to evaluate the proportion of true positive predictions among all positive predictions.

• Consider recall to assess the proportion of true positive predictions among all actual positives.

• Calculate F1 score as a balance ...read more
Answered by AI
Add your answer

Q1. What is R-Squared and Adjusted R Squared? Also brief about the difference?
Add your answer
Q2. Interpret the coefficients of Linear Regression and Binomial Logistic Regression?
Add your answer

Q1. Median of 2 sorted array
Add your answer
Q2. Linux commands for chmod
Add your answer
Q3. Features of python
Add your answer
Q4. Deepcopy and shallowcopy
Add your answer

Q1. Phone interview
Add your answer

Q1. Project technical questions
Add your answer

Q1. Project technical based question
Add your answer

Q1. Behavioural based questions
Add your answer