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 skills Own 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.
Other:
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
9. If the contractors have worked/attended school/lived outside of the US in the last 7 years, an international check of these requirements is a must.