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
