BriefCase
BriefCase

Etl- Database Testing - Emerging Lead Job in State Street

Etl- Database Testing - Emerging Lead

State Street 2 weeks ago
Apply Now
Job Summary Role Description As a QA tester, He/she should would be a team player that can perform end to end testing. This candidate should have a strong understanding of the SDLC and defect life cycle. The candidate would be able to perform analysis of requirements, document a test plan, write and execute manual and automated test cases, and analyze test results. Expected to perform manual and ETL testing in validating data sources, extraction of data, applying transformation logic, and loading data into target tables, working closely with data engineering functions to ensure a sustainable test approach. 5+ years experience in ETL, DWH, Axiom & Manual testing. Well versed with all stages of Software Development Life Cycle (SDLC) and Software Test Life Cycle (STLC). Experience in SQL scripting Create ETL Test data for all ETL mapping rules to test the functionality of the Axiom logic. Experience in creating Test Readiness Review(TRR) and Requirement Traceability Matrix (RTM) documents Experience in preparing the Test plan, Detailed Test cases, writing Test Scripts by decomposing Business Requirements and developing Test Scenarios to support quality deliverables. Responsible for checking the accuracy and completeness of the ETL process. They authenticate the data sources, check the precision of data extraction, apply the transformation logic, and load data in the data warehouse. Participate in meetings with business on requirements and functional specifications reviews early in the software development life cycle process. Execute software testing to include functional testing, system testing, regression testing, and, security and performance testing. Review and inspect the team member's work artifacts deliverables. Support the day to day work support and provide training and coaching if needed. Document software defects in an issue tracking system and proactively communicate issues with developers and other project team members. Prepare test scripts and data sets; configure testing tools and develop complete, automated regression suites. Record and maintain automated test script libraries for functional regression testing for assigned applications. Generate effective status and progress reports to the QA Manager and project team members. Prepare daily/weekly/monthly reports, present information to management. Working closely with multiple business and technology teams, on a fairly independent basis and maintain ongoing relationships with business and IT teams. Core/Must have skills SQL Understanding of Data ware house, Data Migration, ETL concepts Good knowledge on one Automation tool either selenium/TOSCA Understanding of Test case design, Test data preparation, Test execution, Data validation and Evidence capturing. Understanding of Quality Assurance procedure Understanding of project end to end process. Knowledge on test management tool (Ex : Jira) Good to have skills Axiom Learn how ETL tool (like Informatica, Datastage, etc ) works. Bigdata, Hadoop, Scoop, Hive, Spark, AWS, Databricks, PLSQL Work Schedule Hybrid
Experience Required :

Minimum 5 Years

Vacancy :

2 - 4 Hires

Similar Jobs for you

See more recommended jobs