Quality Center
SDLC NOTES
(2)
A Real Software Testing Interview
(1)
Important Manual Testing Interview Questions and Answers
(1)
Interview Questions for QA Tester
(1)
Quality Center Interview Questions.
(1)
Quality Center alm
(1)
STLC
(1)
Tell me about yourself
(1)
Top 5 Software Configuration Management Tools
(1)
Thursday, March 24, 2016
Thursday, March 10, 2016
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
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.
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
Subscribe to:
Posts (Atom)