QA Analyst - ETL Testing Resume - Hire IT People

SUMMARY

Proficient in ETL & Database testing, SIT, UAT, End - to-end, Regression, Black box testing, Agile Methodologies and Defect management.
7 years of experience in software testing including ETL, Manual test and some hands-on experience with automation testing.
ETL/DWH Tester, SQL Server Integration Services (SSIS), TOAD data point, Database, Oracle & SQL.
Proficient in Requirements Gathering (BRD and SRD), Developing Project Plan, and Developing Test Plans.
Hands on experience in Test management tools like HP ALM and Jira.
Expertise in Capital Market domain precisely in Corporate Actions, Fund Accounting and Fund Administration covering various financial instruments like Equities, Derivatives, MF, Debt and Money market.
Worked on MT 540-MT 548 Swift files for different trades like payment confirmation, settlement status and processing advice.
Worked on MT 564-MT 568 swift messages for Corporate Actions notifications, instructions and confirmation’s.
Experience with the Equity trade lifecycle.
Excellent working knowledge of System Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle.
Excellent knowledge and working experience in test planning, test strategy, test case execution and test results analyses.
Flexible to learn advancements in the IT industry, Quick learner, Team Player, willing to learn new technologies.

TECHNICAL SKILLS

Networking: TCP/IP, ISO/OSI Layers, SQL, Ethernet, Token Ring, VPN, SSH, Wireshark

Security Testing: Running NESSUS tool and analyzing the vulnerability.

Web Technology: HTML, XML and CSS.

System tool: Microsoft office Systems and Microsoft Project.

PROFESSIONAL EXPERIENCE

Confidential

QA Analyst - ETL Testing

Responsibilities:

Perform Database, ETL, and web services testing as applicable for the application functionality
Perform SIT testing once the developers in the environment have deployed the code.
Data/Record count validation, data structure and data value check by using SQL queries.
ETL/DWH Tester, SQL Server Integration Services (SSIS), TOAD data point, Database, Oracle & SQL.
Coordinating with business analyst, getting the transformation logic requirements, and applying filters accordingly while validating the data.
Work with test management team to assist on developing test strategy, test plans.
Perform software test design activities to create test scenarios, test cases, associated test data.
Performing complete E2E test with all Autosys jobs running in sequence and do a regression check
Support test management team to create exit reports for software test phases as needed for test signoffs

Confidential

QA Analyst

Responsibilities:

Worked on MT 540-MT 548 Swift files for different trades like payment confirmation, settlement status and processing advice.
Worked on MT 564-MT 568 swift messages for Corporate Actions notifications, instructions and confirmation’s.
Used Maven for building the WebDriver project, Integrated with Continuous Integration tools Jenkins for running test on nightly basis automatically.
Building Cucumber BDD framework with selenium web driver and create feature file, step definition files and Test Runner class using JUnit and cucumber options.
Used automated scripts and performed functionality testing during the various phases of the application development using Selenium.
Analyzing of the FRD (Functional Required Document) provided by the customer and preparing the test plan, and test cases.
End to end testing of the GTAS application along with the ETL testing of the data migration at the back end.
Validating the database operational report generated after the deployment with the automated report generated by GTAS UI.
Also testing the record counts and the integrity of data in the reports
Interacting with client for better knowledge of requirements.
Execution of test cases in HP Quality Center.
Defect Management & organizing the Defect Management call.