We provide IT Staff Augmentation Services!

Etl Tester Resume

0/5 (Submit Your Rating)

Houston, TX

SUMMARY

  • 9 + years of experience in performing Test Planning, Execution and Analysis of teh Application Under Test using standard methodologies like Waterfall and Agile
  • Experience in Software Quality Assurance and Testing, experienced in both manual and automated testing on web based, client server, Data Warehouse applications
  • Experience in creating Detailed Test Plan, Functional Test Plan, Test Scenarios, Test Cases and Status reports
  • Good experience in creating and executing Test Plans, Test Cases, QA Methodologies in both Manual and Automated Testing environments
  • Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability and Validation of End - to-end and User Acceptance Testing.
  • Experienced in Agile Methodology. Proficient in Black Box and Testing methodologies. Possess specific experience performing Regression and Functional Testing using QTP, Rational Service Tester.
  • Performed Automated Testing using QTP for Functional & Regression testing
  • Strong skills in Implementing Quality Assurance Standards, and Testing Methodologies for Large Enterprise GUI, and WEB applications using Use Case Documents, Functional Specifications and Business Requirements
  • Testing skills include Sanity, Black Box, User Acceptance, Smoke, System Integration, Backend Database, Performance, Stress, Regression, End to End, Security, Cross Browsers and Cross Platform Testing
  • Strong experience in designing and developing automated scripts for Functional, Integration and Regression Testing using Selenium.
  • Expert in performing Data Driven Testing to validate teh components displayed on teh website using Selenium Webdriver
  • Experienced in developing Automation Frameworks using Selenium.
  • Has strong experience in using QTP, Quality Center, Rational Quality Manager, Rational Service Tester
  • Experience in handling applications in Ministry, Telecom, Banking and Oil and Gas
  • Excellent interpersonal skills, proven team player with an analytical bent to problem solving and delivering under high stress environment with resource constraints
  • Possess good analytical and troubleshooting skills and has proven ability to work efficiently in both independent and team oriented environments

TECHNICAL SKILLS

Operating Systems: UNIX, Linux, Windows 95/98/2000/XP/7/NT

Languages: VB Script, Java, JavaScript, Shell scripts, J2EE, JUNIT, PL/SQL, HTML, XML, SOAP, RESTful

Database: Oracle, MS SQL Server, DB2, MS Access

Test Tools: QTP/UFT, QC/ALM, Jira, Selenium, Rational Quality Manager, Rational Service Tester, Worksoft Certify

ERP: SAP 4.6C, ECC 6.0, SD, MM

PROFESSIONAL EXPERIENCE

Confidential, Houston TX

ETL Tester

Responsibilities:

  • Worked on all phases of data warehouse testing lifecycle, from gathering requirements, Preparing Test Data, testing, create test reports, support to other Pods including client in teh integration project.
  • Analyzed Business Requirements, Mapping Supplement documents and Identified documents required for system and functional testing efforts for all test scenarios.
  • Provided Continual Process Improvement Initiatives & control project quality/cost by leading & organizing Test Project Plan, Phase Reviews, Code Walkthroughs & lessons-earned sessions.
  • Worked on developing teh data warehouse test strategies, test plans, and test cases.
  • Analyzed & documented teh contents of teh Sparx Enterprise Architect repository.
  • Hands on experience in using SVN version control tool for versioning automation components like automation scripts, environment files etc.
  • Coordinated deployments across multiple Scrum teams and Deployment team for both Front-end and Back-end QA and Release builds to multiple QA environments including execution of Deployment jobs in Jenkins
  • Has good experience in creating TEMPeffective ETL data warehouse test cases and scenarios based on business and user requirements.
  • Heavily used Test / Defect management tools like Rational Quality Manager, Rational Service tester, Rational Functional tester, Rational Clear Quest for managing test cases, executing and storing results and raising defects.
  • Prepared test data for positive and negative test scenarios for Functional Testing as documented in teh test plan.
  • Managed and conducted System testing, Integration testing and Functional testing.
  • Used teh Oracle Data Integrator Operator and its run-time scenarios to schedule teh jobs, validating and debugging its components, and monitoring teh resulting executable versions.
  • Responsible for designingFrameworkand executingautomationscripts using Selenium.
  • Designing and developing testautomationartifacts (scripts, scenarios, processes) for simple to complex automated testing usingSelenium Webdriver
  • Performed End to endtestingstarting from teh source to teh report
  • Strong noledge of SQL, XML and extraction/ transformation/ loading (ETL) process usingSQL, XML scripts.
  • Worked with Data Warehousing developers who extensively used ODI, OSB to design mapping to move data from source to target database using Stages to do teh functionality.
  • Extensive work inETLprocess consisting ofdatatransformation,datasourcing, mapping, conversion and loading and noledge inDataModeling
  • Prepared status summary reports with details of executed, passed and failed test cases
  • Interacted with developers, Business & Management Teams and End Users.
  • ImplementedSQL scripts,stored procedures, triggersandindexes forvarious database operations.
  • Extensively used Oracle Enterprise Manager to monitor teh instances and Payloads of SOA services.
  • Defining defects and carried out test reports using RQM as Defect tracking system.
  • Testing of Web Services using web services client generated using SOAP UI to track request and response SOAP Messages.
  • Responsible for API Testing, Web Service Testing using SOAPUI (Test Suite, Assertions and Mock services)
  • Performed Back end Testing-using SQL queries, generating reports to ensure data integrity and validate teh inserted and updated data.
  • Strong experience in Agile Scrum Methodology, Test Driven Development(TDD), Behavior Driven Development(BDD) and ATDD
  • Performed cross browser and cross platform web testing with Selenium WebDriver.
  • Developed and maintained automated regression test cases inSeleniumusing Java programming language
  • Regularly followed up with Development Team to discuss discrepancies identified during testing and performance tuning.
  • Participated in daily defect resolution status calls to discuss defects with vendors, project management, Developers and Users.
  • Used Tealeaf to view teh customer sessions for teh issues they are encountering during UAT phase.
  • Involved in retesting teh fixed defects and keep track of defects through defect life cycle.
  • Escalated testing issues, risks, dependencies, resources constraints to teh Testing Team leadership.

Confidential

Sr Quality Assurance Analyst

Responsibilities:

  • Involved in testing teh data warehousing process of teh FCC Loan Management System project
  • Organized walkthrough and review session from BA, ETL developers and DBA to understand teh business process
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Data Conversion and Data Migration project
  • Worked with Data Extraction, Transformation and Loading (ETL)
  • Tested teh ETL process for both before data validation and after data validation process and tested teh messages published by ETL tool and data loaded into Oracle databases
  • Created ETL test data for all ETL mapping rules to test teh functionality of teh Informatica Transformation Mapping
  • Written several complex SQL queries for validating Business Objects Reports based on teh data mapping requirements
  • Understood thedatamodelrepresented in logical and physical enterprisedatawarehouse schemas
  • Designed and Developed data validation, load processes and test cases using PL/SQL, SQL
  • Proficient in working with different Databases like Oracle, Teradata, MS SQL Server on tools like Toad, Oracle SQL Developer, SQL*Plus.
  • Hands on experience in DevelopAutomationScripts, Execution and Analysis Test Results using Hybrid, Keyword Driven Framework, Data Driven Framework and Page Object Model Framework in Selenium.
  • Experience in developingSeleniumtests for Javaapplications using IDE's such as Eclipse
  • Developedautomationtestscripts (Java and Vbscript) totestthe database by retrieving teh data from teh tables using HP QTP, Selenium.
  • Developed QA processesautomationtest scripts using Seleniumto test Web based user interfaces for different type of browsers.
  • Responsible for fixing and maintaining regressionautomationtest scripts (Java) for end to end testing using SeleniumWeb Driver
  • Extensively performed Web Servicestesting for REST, SOAP, and WSDL.
  • Involved in testing data mapping and conversion in a server based on Informatica data warehouse
  • Regular monitor and track high Priority defects, write positive and negative test cases, improve traceability, to reduce project risk and increase teh quality of teh application
  • Gathered noledge on Home Loans Point of Sale and Loan Origination system
  • Responsible for testing theFCC Mortgage Point of Sale & Loan Origination system
  • Good experience in performing Asynchronous Web Services Testing using SOAP UI tool
  • Used Quality Center to create Test cases, Map teh test cases to Test Plans and Requirements, create test sets and report defects
  • Good experience in Analysis of Bug Severity, Bug Tracking system and Bug Reporting using Quality Center, ClearQuest.

Confidential

Sr Quality Assurance Analyst

Responsibilities:

  • Worked as QA Analyst in testing CreditAPP application
  • Gathered Project documents and performed gap analysis
  • Organized brainstorming session with teh Business Analyst for teh detail understanding of teh project and teh application
  • Reported gaps to teh authors and ensured to teh closure
  • Identified wat is In-scope and out-scope of teh project based on Project Scope documents
  • Drafted Master test plan after reviewing teh project documents
  • Provided Master test plan for sign off after detailed review sessions
  • Mentored QA teams how to construct TEMPeffective test plans, cases, and test reports
  • Responsible for customizingSeleniumAPI to suit in testing environment.
  • Performed Data driven (TDD) testing to validate teh components displayed on teh website usingSelenium
  • Identified Test scenarios based on teh Business and Functional requirements
  • Created Test Scenarios for Business Rules and Business Process by creating both positive and negative test cases according to teh Business Rules and Business Strategies of teh APPRO application
  • Identified teh test data by organizing multiple test data review meetings and also created test data for specific Test Scenarios and Test Cases using SQL Insert scripts
  • Created test data requirements document based on teh test scenarios and provided to teh DBA for test data purpose
  • Created detailed test cases in Quality center and mapped to teh requirements
  • Mapped teh test data to a specific test case for execution purpose
  • Responsible for creating and executing theseleniumscripts and analyze teh test results.
  • Used Firebug to identify web elements using Xpath and CSS selectors
  • Performed Functional, System-Integration, End to End, Regression testing and User Acceptance Testing
  • Verified teh "fixes" for teh reported defects by performed Regression testing using QTP and provided defect status reports to teh management
  • Regular interaction with developers and business analyst in resolving technical related issues
  • Involved in testing web services of teh application using an Open sourceSoapUI Tool
  • Co-ordinated with teh client BA’s and SME’s forLoad, stresstestingof UI and other functional requirements gathering.
  • Participated in enhancements meeting to distinguish between bugs and enhancements
  • Provided test matrices to teh QA Lead and management on a daily basis

Confidential

Sr Quality Assurance Analyst

Responsibilities:

  • Involved in teh creation of System Test Plan which outlines Scope, Objective, Focus and Approach of teh testing effort for dis particular project
  • Participated in teh Requirements review meeting to better understand teh project
  • Created Test scenarios based on teh SRS and Use Cases in Quality Center
  • Provided teh Test scenarios to teh BA for review and sign off
  • Created detailed Test cases in Quality Center test plan module and mapped teh test cases to teh requirements and ensured teh coverage
  • Carried out End to End testing of Operations and supply chain consisting of MM, SD, FI, PP, APO modules for various scenarios and functionalities concerning teh business flow.
  • Involved in Manual and Automated Testing of Web based, Client/Server and mobile applications(iOS and Android)
  • Responsible for writingautomationtest scripts in QTP for different application features.
  • Coordinated Test Execution & Enterprise-Wide Testing of Quality E2E test environment supporting J2EE/J2ME Applications.
  • Heavily used Test / Defect management tool Quality Center/ALM, QTP for managing test cases, executing and storing results and raising defects
  • Actively involved in SDLC and STLC process and used tools like ALM,SeleniumRC, JMeter, SOAP UI
  • Automated teh regression test cases using theSelenium& TestNG.
  • Automated teh Test Cases usingSeleniumRC, Java Eclipse and JUnit.
  • Identified teh test data based on teh requirements and provided them to teh DBA
  • Executed test cases on teh application for Sanity, Functionality, Integration, Data mapping, Data integrity, Data validation and End to end testing.
  • Having very good experience in using Defect Management tools / Bug Tracking tools like JIRA, QC/ALM, Rational Suite
  • Performed backend testing on teh Oracle database using SQL statements
  • Involved in creating UAT test cases based on teh end users input and performed UAT testing along with teh users
  • Reported defects to teh development team with all teh required details and participated in teh defect triage meetings
  • Provided status reports to teh management for assigned tasks

Confidential

Quality Assurance Tester

Responsibilities:

  • Participated in business requirement, design walk through and analyzed business requirements
  • Reviewed system use cases and functional specs with business and system analysts
  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Data Conversion and Data Migration project
  • Used Quality Center to create Test cases, Map teh test cases to requirements, create test sets and report defects
  • Generated test plan, test case and defect metrics reports and published to teh management on regular intervals
  • Involved in testing teh UI applications by performing field level, cross browser, functionality, system integration and end to end testing
  • Involved in Security testing for different LDAP roles based on Security testing requirements
  • Tested SAP order to cash process.
  • Has very good experience in testing SAP Material Master Data (MM, MD)
  • Involved in Creation of Quotation and Order management, Standard Sales Order.
  • Involved in Pricing, Billing and Contract management.
  • Involved in Functional Testing of teh Sales order management, Third Party Order Processing, checking Availability of teh products, Releasing teh created sales order, Creating teh invoice, creating teh goods receipt
  • Involved in Mobile apps testing which is integrated with SAP CRM (Mobile sales)
  • Experience withMobileapplicationtestingfor iPhone (iOS), Android, Blackberry and featured phones using Simulators like Device anywhere and Perfecto
  • Experienced on MobileAutomation(Android & IOS) using Appium (Selenium)
  • Has good Experience on testing regression suite by Net weaver portals across SAP Modules.
  • Worked with business team to test teh reports developed in Crystal Reports.
  • Used Quality Center to track and report system defects
  • Written several complex SQL queries for validating Crystal Reports based on teh data mapping requirements
  • Provided status and progress reports to teh management on regular intervals

We'd love your feedback!