• Us Citizen

• Green Card

• Corp-Corp

• Consulting/Contract

• UG :- - Not Required

• PG :- - Not Required

• No of position :- ( 1 )

• Post :- 24th Nov 2020

JOB DESCRIPTION

 

Interview Mode-Skype VISA-USC/GC INITIAL REMOTE ONSITE LATER

Till December it will be remote. Starting next year, team might have to attend office twice or alternate days in a week.  So I would prefer local candidates with GC or Citizens.

Standard Skill Requirements

Batch Testing (Back end Testing includes Databases & ETL testing, Authoring Store Procedures) 5+ years experience required

QA Concepts & Standards 5+ years experience required

Test Methodologies (Agile: Squad, SCRUM, TDD and BDD) 5+ years experience required

Questions:

 Extensive knowledge on Authoring test cases, executing test cases and reporting the results to the required Stakeholders?

 Hands Knowledge on Authoring MS SQL queries Joining tables?

 Good Knowledge on Finance domain - Banking, Mortgage, Loans processing, Escrow?

 Extensive knowledge on Agile methodologies is Mandatory.

 Should posses Green Card or Citizenship

Description of Services

5+ years of experience in testing application

2+ years of experience in Banking and financial domain

Experience in loans will be a value add

knowledge of Azure DevOps, Excellent understanding of operating systems such as Windows and VMware.

2-4 years with analytical and research skills necessary to compile and analyze relevant data and present performance or capacity impact of business requirements.

Represents team in major collaborative efforts and on key IT and Company objectives.

Excellent understand of the SDLC process and familiar with the various testing methodologies (eg: SCRUM, Kanban, TDD, BDD and Squad Models).

Excellent verbal and written communication skills

Must adhere to corporate/team etiquette

Deliverables:

The ETL tester works with the Project Lead, Solution Architect, Business Analyst and Quality Assurance Testing Team in the software testing life cycle and defect management. This role acts as a ETL Test Analyst in the creation, preparation, review, development and execution of test cases.

Reviews application requirements/ User Stories and project documentation and asks follow-up questions as needed in order to gain a full understanding of requirements/Feature/Epic

Ability to work with the Scrum Master, participate in ceremonies and represent the Quality Assurance team. Prioritize test conditions by working closely with the project team to determine priorities

Document and maintain functional and non-functional test cases and other test artifacts such as Test cases, Test Data, Data validations and test environments and associate them to the User Stories in AzDO

Execute the Test cases, track the results and demo them to business as needed.

Strong experience in MS SQL server

Experience in end-to-end data lifecycle: source data ingestion, batch data, data transformation

Review and understand Business Requirements Document (BRD), Data Models, Source to Target Mappings and Design documents

Extensive experience in developing SQL queries based on source to target mapping document

Strong experience in developing test scripts based on source to target mapping document

Hands on experience in creating database objects and views

Understand existing SSIS packages and stored procedure

Deploy and Execute ETL workflows in QA environment

Identify, mitigate and communicate testing and QA risks to project leadership on a timely basis

Should have working experience in SCRUM environment

Great team player with strong interpersonal and verbal and written communication skillsOwn all aspects of a program from a QA perspective including but not limited to manual testing, functional testing, database testing, and regression testing.

Analyze and review the test results, share them with teams and business

Ensures QA standards are maintained and followed across the projects and phases.

Ensures the client's QA processes are followed throughout the test cycle.

Provides feedback to project team and other internal customers on the production readiness

Responsible for creating high level, mid-level and low-level planning documents for team as needed

Identifies and analyses the Risk at an early stage of the project and come up with mitigation plans as needed

Be flexible and creative in handling multiple activities and contentions in priorities. Takes initiative to resolve issues and tackle roadblocks.

Maintain an advanced level of knowledge and expertise on Test management tools and quality assurance concepts and methodologies (Agile, Waterfall, Iterative methodologies

 

Acceptance Criteria:

Should be a functional and ETL tester, capable of writing Queries, Extract & Transform data. Good analytical skills to understand data flow. Excellent data analysis and problem-solving skills are a must, Good knowledge in authoring ETL master test plan, should have working knowledge in AzDO.

 

EXTENSIVE BACKGROUND CHECK PROCESS FOR THIS CLIENT.  MAKE SURE YOUR CANDIDATE IS AWARE THAT IF CHOSEN, THE BACKGROUND PROCESS MAY TAKE UP TO 4 WEEKS TO COMPLETE.  YOU AS THE SUPPLIER WILL BE RESPONSIBLE FOR THE EXTRA COST OF ANY OF THE CHECKS LISTED BELOW THAT AREN'T ALREADY RAN IN OUR STANDARD PROCESS:

1.    SSN Trace  

2.    Previous Employment Verification/Reference (7 years)  

3.    Education confirmation (degrees only) - Optional

4.    County criminal - 7-year search (all AKAs that appear on SSN Trace/Credit report)  

5.    Federal criminal – 7-year search (all AKAs that appear on SSN Trace/Credit report)  

6.    National Criminal Database Search  

7.    Homeland Security Search – OFAC + 100 other lists (terrorist, fugitive, individuals excluded from federal procurement, non-procurement, and reciprocal programs)  

8.    Federal Sanctions and Exclusions – includes GSA Excluded Parties List System and OIG List of Excluded Individuals/Entities