We provide IT Staff Augmentation Services!

Sr. Etl Tester Resume

3.00/5 (Submit Your Rating)

OBJECTIVE:

Looking for a challenging environment where I can utilize my technical and analytical skills in Software QA Testing to provide a good software product to the end users.

SUMMARY:

  • As a Sr.QA Analyst / Test Engineer with 7 years of experience in all phases of software lifecycle, developed Test Cases, Test Plan and Automation test scripts using Selenium Webdriver, IDE, Confidential (Mercury) Quick Test Professional (QTP), Confidential UFT and performance testing in Confidential LoadRunner in Client/Server, Windows, UNIX/Linux, Web Services and Web based applications. In depth technical knowledge and understanding of Data Warehousing, Data Validations, SQL, PL/SQL, SQL Server, Oracle, and ETL.
  • Good experience in eCommerce B2C and B2B applications with strong Business and Functional knowledge.
  • Excellent understanding of Software Development life Cycle (SDLC) and importance of QA in
  • Development/ Enhancement and Maintenance of software applications
  • Familiarity with multiple development and testing methodologies like Waterfall, Agile etc.
  • Expertise in Manual, Automated and Web Services Testing.
  • Good experience with developing test plan, test cases and RTM (Requirement traceability Matrix)
  • Experience with preparing test data by executing SQL queries and joins using TOAD and other tools
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • Experience with ETL testing.
  • Practical experience with Quality Centre / Confidential ALM to develop Test plan, test cases, executing test cases in Test lab, and creating and tracking defects in Defects module.
  • Experience with preparing reports to track the execution of Test cases and defects.
  • Good Team player, good analytical skills, problem solving skills, communication skills.
  • Good experience with UNIX / Linux commands, FTP Tools like WinSCP, Filezilla etc.
  • Familiar with Shell script, putty tool, VI editor.
  • Experience with WebServices, SoapUI tool, XML, Validating request and response XML, SOAP and RESTFUL WebService calls.
  • Experience with QTP / Confidential UFT to develop automation scripts in VB Script.
  • Experience with QTP - Object repository, Checkpoints, Actions, Functions, regular expressions, parameterization, transactions, function library
  • Experience with Regression testing, User acceptance testing, (UAT), Functional testing, blackbox testing techniques, System testing, Unit testing, Smoke testing, sanity testing, performance testing, load testing, stress testing, Exploratory testing, browser compatibility testing, integration testing, cross browser testing Experience with data driven testing
  • Experience with Confidential Loadrunner - VUGen, Controller and Analysis tools for performance testing (Non-Functional Testing)

TECHNICAL SKILLS:

Testing tools: Toad, Selenium, Quality Center, ALM, QTP, LoadRunner, SOAPUI

Database: Oracle, SQLPlus

Operating System: Windows, Unix

Languages: SQL, VB, Java, C, .Net, XML, HTML

Tools: Filezilla, Putty, Winscp

Microsoft Tools: MS word, Power point, Excel

Browsers: Internet explorer, Mozilla Firefox, Google Chrome, Safari

PROFESSIONAL EXPERIENCE:

Confidential

Sr. ETL Tester

Responsibilities:

  • Worked on to validate the below data flows:
  • Source system to Stage tables in EDW
  • Stage tables in EDW to Datastore tables in EDW
  • Validated DDL’s (Table Structure), Table Data, and Record Counts to ensure that data has been loaded according to the business approved requirement document.
  • Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
  • Used Toad for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
  • Formulated methods to perform Positive and Negative testing against requirements.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Executed and managed test cases and reported bugs in Quality Center.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.

Confidential

Sr. QA Tester / Web Services Tester

Responsibilities:

  • Worked in Water fall environment, attended daily stand up meetings, business requirements meetings.
  • Developed and executed test cases for unit testing and integration testing by using the individual and business customers as parameters.
  • Developed and executed end to end test cases, KYC KYA record submissions.
  • Uploaded the prepared test cases to the Quality Center.
  • Executed Test cases in Quality Center / ALM - Test Lab.
  • Involved in Web Services Testing using Soap UI tool. Validated request and response XML to validate the captured data from non-deposits to ODS will be stored and retrieved.
  • Executed SQL queries to compare the data in database with the data sent in the UI.
  • Involved in Functional testing, Regression testing after the new requirements, UAT, Smoke Testing after every build.
  • Integration Testing between the CDD Non-Deposits and ODS to IRIS using Soap UI tool.
  • Worked on End to End testing by submitting a complete KYC and KYA and validated the Risk Score in IRIS(Risk Score Engine).

Confidential

Senior QA Engineer/ Mobile QA Lead

Environment: s: Selenium, JIRA (bug tracking software), Web Responsive Design Technologies, CQ, JavaScript, JQuery, HTML5, Java, SVN, Weblogic.

Responsibilities:

  • Review business and functional requirements of the application and create User Stories, comprehensive test plans and test cases for functional, integration and user acceptance testing
  • Initiated and evangelized mobile testing strategy and processes
  • Execute complex test cases and scenarios to ensure that the functionality of the application matched with the Business Requirements and User Stories in agile fashion
  • Perform test case automation using internal automation framework (ATK - Automation toolkit) using Eclipse IDE, Selenium and Web Driver framework
  • Work with development team, project managers and other QA teams to drive all defects and design changes from discovery/inception to resolution
  • Lead Integration Testing ->Understand and test data flow thru dependent systems
  • Report test/release outcomes by collecting, analyzing, interpreting, summarizing and documenting test results
  • Drive release go no go meetings and certify to deploy in production
  • Collaborate with the external Vendor teams and lead the QA team to align and streamline the QA Processes according to Confidential & Confidential Standards
  • Anticipated & Identified Problem areas, have recommended various solutions to ensure more Productive and efficient Release & Go-No Go Process
  • Provided required support on the Testing mobile web sites on new sites and existing sites
  • Reviewed and recommended Test plan and Strategy Solutions to maintain/manage Quality Websites
  • Train/Mentor Junior level/ Sustainment QA team

Confidential, Grand Rapids, MI

Sr. QA Tester / Web Services Tester

Responsibilities:

  • Worked in Agile environment, attended sprint plan meetings, daily standup meetings.
  • Reviewed Requirements documents / User Stories.
  • Tested Customer module, payment module
  • Developed and executed test cases for transfer amount module
  • Executed test cases on payment module, schedule module, add account module
  • Attended daily standup meetings
  • Developed Test plan and test cases for all the user stories.
  • Prepared test data by executing SQL queries and Joins.
  • Executed Test cases in Quality Center / ALM - Test Lab.
  • Created Defects, reported defects and tracked with the team
  • ETL Testing process - Validated source and target database to validate the reports.
  • Extensively used the AutoSys jobs for the entire project.
  • Worked on SQL scripts to load data in the tables.
  • Executed SQL queries to compare the data in database with GUI and webservices.
  • UNIX / Linux commands Executed.
  • Transferred files from UNIX / Linux to Windows using FTP tools like Filezilla / WinScp.
  • Developed RTM to trace the requirement with test case.
  • Involved in WebServices Testing using SoapUI tool. Validated request and response XML.
  • Added assertions to validate the xml in WebServices SOAP and RESTful services.
  • Validated WSDL File for webservices.
  • Involved in Functional testing, Regression testing, UAT, Smoke Testing, Integration testing.
  • Involved in Browser compatibility testing.
  • Generated reports for test case execution and defect status reports.
  • Worked with automation team to identify regression test cases.
  • Executed automation test scripts developed in QTP / UFT validated results.

Environment: Java / J2EE, MySQL, Linux, Apache Tomcat, SQL, Quality Center / ALM, QTP / UFT, Autosys, TOAD, LoadRunner, SoapUI, XML, WebServices.

Confidential, Herndon, VA

QA Test Analyst (Manual/Automation/Performance testing)

Responsibilities:

  • Worked in Agile methodology. Attended Daily standup meetings. Developed Test Plan and Test cases based on the user stories (Functional requirements)
  • Detected Defects, Communicated to the developers using Bug Reporting Tool and Tracking the Defects using Quality Center.
  • Executed manual test cases and identified the test cases to be automated.
  • Extensively used Quality Center for test planning, bug tracking and reporting.
  • Uploaded Business requirements, test scenarios, test cases and defects to QualityCenter
  • Expertise in QA Testing in distributed Unix/Windows Environment and Oracle databases as back end & performed end-to-end testing. Tested WebServices and XML using SoapUI.
  • Developed test plans, test cases, test scenarios using the QualityCenter and prepared test data.
  • Converted manual test scripts to automated test scripts in Quick Test Professional, enhanced the scripts by adding user-defined functions. Worked on Automated test scenarios for GUI, Integration, Database, Security and Regression Testing using Quick Test professional.
  • Hands-On experience in Performance testing tools like Confidential LoadRunner (VUGen, Controller, Analysis).
  • Expertise in executing VUGen scripts in Load Runner for Performance, Load and Stress Testing using Controller in Load Runner.
  • Involved in testing the backend Database retrieved the data from the tables using SQL
  • Prepared test scripts using Quick Test Professional with checkpoints using regular expressions for handling windows with different names.
  • Coordinated with developers to fix the bugs and conducted Functional (Positive and Negative), and Integration Testing.

Environment: Java/J2EE, Quick Test Professional (QTP) Confidential LoadRunner, Quality Center, QC tool, Web Logic application server, UNIX, MS Office, Oracle, TOAD, Web Services, SoapUI, XML.

We'd love your feedback!