A Real Software Testing Interview with Bank of America in New York

Congratulations on your phone interview with Bank of America! Below are the details you will need for your interview:

Interview Date: 07/27/2015

Interview Time: 4PM EST

Interview Method: Phone (Luisa Cassanello will call you at

Interviewers: Luisa Cassanello

Interviewer’s LinkedIn Profile:   https://www.linkedin.com/in/luisalight

Resume:  Attached – please be prepared to reference this during the interview.  

I will call you 5-10 minutes prior to the interview to make sure everything is good to go. Please take the call in a quiet place with good service.

Feel free to research the client web site – www.bankofamerica.com/‎

Description:

Credit Risk Technology is responsible for implementing and supporting systems that calculate and manage counterparty level exposures. A substantial work is underway within Credit Risk to i) Expand and improve system functionality in support of business objectives and regulatory requirements, and ii) Migrate applications to the Banks strategic platform for trade workflow, analytics and data management across all asset classes. The individual QA/Data Analyst must understand testing practices, tools, and reporting with a 5-7 years of work experience.

Job Function:

·  The Technology QA/Data Analyst professional will be responsible for analyzing the output/results from integration system testing, user acceptance, and production release changes.

·  This position partners with project managers, software developers, business users and management across the Credit Risk technology and business organizations for successfully delivering and reporting results.

·  This position requires the ability to follow, design and execute test plans and procedures for acceptance testing of new or modified applications, computing environments, and software/hardware technology and tools, etc. Analyze, design, and/or document new or modified procedures and standards.

·  Perform requirement analysis, create standard tests plans and test scripts, test case execution/review, defect tracking and management. Provide sound analysis and root cause for data defects.

·  Assist in the development and implementation of metrics for assessing the quality of delivered applications and information systems.

·  Automate testing scripts and tools for procedural or standard changes.

Required Technical Skills:

·  Apply all aspects of business analysis and data quality assurance processes and testing standards

·  Communicate testing/project status completely and effectively

·  Poses knowledge of system development life cycle methodologies (waterfall and agile)

·  Experience with Enterprise Change Management Systems/Process

·  Plan and prepare status reporting for team/client meetings

·  Have knowledge of SQL language, EXCEL or data access and analysis tools

·  Working experience in Solaris, Unix/Linux environments and Sybase database.

Desired Skills:

·  Working knowledge of Python object oriented programming, Sandra object database, and Hugs/Bob scheduler.

·  Investment Bank and/or Credit Risk business knowledge

·  Ability to work with distributed teams

Tools/Technology Knowledge Requirements:

·  Programming language - Python, VBscript, .Net

·  DB Artisan 8.6/Toad for Analysts

·  DB clients - Sybase, SQL

·  MS Office

·  MS Project/OpenProj/JIRA

·  Quality Center or equivalent test tracking tool

Phone interview with Bank of America:

The interview lasted

omShe first called and introduced herself

Data analytics group.

Credit Risk technology Group.

We are called the data analytics team. The application credit risk technology. The application performs exposure calculation current and potential apr on the trading data that we received from different industry.

We perform exposure calculation counterpart 11 deliver the data back to the industry back downstream. The role data analytics group Processing the data, analyzing the data based on the requirement. As well as how the profile is generated provide different support to the user group. Complex SQl analysis has to be done using the SQl query.  Pulling the data from database and analyzing the data further. We have some few application moving to python platform we have to use python to pull the data center database object oriented database.

Python is additional is plus.

Analyze

Different support to different group

Center database

Scripting.

She asked tell me about your self:

What was your function in QA lead?

We ensure

We performing SIT how is it going?

XML Update

Screen prepared filing

Data manipulation

Web accessibility testing

Please tell me about your current roles and responsibilities in your current project.

Question: In what point in your project have you performed data analysis using SQL?

Question 2: Can you please give me scenario where you used SQL in your current project?

Question 3: Are you performing database testing. Are you mainly performing scenario

Customer date. Running joining to see

Question 4: How would you rate yourself in SQl.

Question 5: What are the common queries you’re using in your day to day validation.

Q5 .Let’s assume you’re given two tables having the same column it’s just number of records

Some table has more record some table has less record. What would you use to pull additional record?

Table A and Table table B

Table A has 123

Table B has 234

Whats the output will you be saying.

If you do a join table 1

What would inner join do.

What would left outer join show.

What would right join show.

Table 1 has ID 1, ID 2, ID 3 Record

Table 2 has ID 2 ID3 ID4 Record

If we do right outer join what will be our output? Or if we do right outer join what will be our output?

What will be the result of the left join.

For right join

Can we use any join to pull the additional record.

Inner join.

Lets assume we have two table one having ID Colum and another having product column.

Can we use any join to pull missing additional record.

Table

Can you give me simple way to pull the data ID having single ID pull the product.

Can you please give me the where condition. Where are products are different

Whats the different between union and unionall?

If you want to get different count you have over 100 different product in the record

If you want to get count of the products what would you do.

For the particular record by product I want the counts

The project is completely  data driven  

Missing data driven

Do you have any experience python