Sr.etl Tester Resume
Richmond, VA
SUMMARY
- Over 6 years of diversified experience in the field of Software Quality Assurance and Software Testing/Analyst.
- Excellent working knowledge of System Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC) and Defect Life Cycle.
- Extensively worked on end - user requirements, analysis, systems study and implementation.
- Specialized in user requirement analysis, documenting test plans, execution of test cases.
- Experience in Automated and Manual testing.
- Experience in preparing Master Test Plan, Test Procedures, Test Strategies, Test Scenarios, Test suite, Test environments and Test data setup.
- Expertise in writing, executing and maintaining Test Cases and Test Scripts.
- Excellent experience working with HP Quality Center as Test Management Tool.
- Excellent skills in understanding and writing complex SQL queries for data validations and back end testing.
- Extensive experience in working with SQL Server, Oracle 9i and DB2 Databases.
- Experience performing backend testing using TOAD.
- Hands on experience in UNIX shell scripting for scheduling the Informatica workflows.
- Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica.
- Strong Property and CasualtyInsurance domain knowledge
- Experience generation VB scripts in using QTP.
- Expertise in Black Box, Sanity/Smoke, Integration Regression, System and Functional Testing.
- Experience in Health Care, Financial and Insurance Domain.
- Strong experience in Quality Assurance of multi-tier systems, Client/server systems and Web Applications/Sites including testing large enterprise software applications.
- Have experience in Data base validation; Initial and Incremental loads of ETL mappings.
- Expertise includes writing Test Cases, generating Test Reports validating Data Warehouses created from Different ETL tools.
- Extensive experience Troubleshooting/Debugging Informatica mappings.
- Performed Functional and Performance Testing on Property and CasualtyModules
- Experience in testing complex reports generated by Cognos, Business Objects including dashboards, summary reports, master detailed, drill down and score cards.
- Experience in QTP and JTAF for Regression testing
- Involved in preparation of Requirement Traceability Matrix (RTM), Defect Report, Weekly Status Reports, Test Summary Reports and Test Readiness Review documents.
- Executed automated test scripts developed in QTP.
- Proficiency in Defect Management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center, Clear Quest.
- Working experience in ETL tools (Informatica, Data Integrator) and Business Intelligent tools (Business Objects, Cognos)
- Having Excellent experience working withHIPAA EDI (837I/P/D, 270/ 271, 276/ 277, 277CA, 278, 820,834,835) X12 Transactions for Both versions (4010A1 & 5010)
- Excellent team player with strong written, communication, interpersonal and analytical skills.
TECHNICAL SKILLS
Testing Tools: QualityCenter9.4 QTP9.4. Rational Robot, Rational Clear Quest, SQA Manager, Clear Quest
Operating Systems: Windows XP, Unix (Solaris).
Languages: Java, C++,J2EE, SQL, PL/SQL, COBOL
Database: Oracle 11i, DB2, SQL Server & Microsoft Access.
GUI, ETL Tools: Informatica, SQL*Loader, TOAD 7.5.2, Abinitio, Data Profiler Visual Basic 6.0, Developer 2000, Crystal reports
App. Servers: Web Sphere 5.0/6.0
Scripting Languages: Java Script, VB Script and TSL.
Web Browsers: Netscape Navigator 3.1,Internet Explorer 6.0/7, Mozilla Fire fox 1.5
EDI Standards: ANSI X12, HIPAA, Spec Builder 6.2/7.0
Office Suits: MS-Excel, MS-PowerPoint, MS-Access, and MS-Word.
PROFESSIONAL EXPERIENCE
Confidential, Richmond, VA
Sr.ETL Tester
Responsibilities:
- Responsible in gathering requirements, creating detailed Timelines, Test Plans and Test Strategies.
- Analyzing test Conditions and develop Test scripts for new Functionality test cases.
- Developed SQL Queries for Back-End Testing in SQL Assistant.
- Build complex SQL queries using Teradata SQL assistant for data validation for verifying the Informatica mappings and business Rules
- Logging, tracking and generating Defect Status Reports using Rational CQ
- Coordinated defect management calls between various teams (dev, support, management) and participated in defect review calls with the development team.
- Perform detailed test results analysis after each test execution cycle and maintained Test results.
- Assisted with UAT(User Acceptance Testing) activities and execute connectivity tests with interfacing applications along with the end users.
- Perform and coordinate Unit testing, System testing and UAT
- Track testing bugs through application developers to closure
- Created detailed test plans based on analysis of requirements and design documents
- Verify the implemented ETL code against the corresponding mapping document
- Analyze data using SQL, Excel, Unix and data testing tools
- Wrote test case scripts; executed and documented detailed results and summary reports
- Coordinated Testing Tasks with Off-Shore Team
Technology: IBM Rational Clear Quest Web, Linux/Unix, PL/SQL, SQL, Teradata SQL Assistant, Teradata Client 13.0, Informatica 9.1, Putty
Confidential, Stamford CT
Sr. QA Analyst
Responsibilities:
- Analyzed system specifications and involved in the development of Business Specification Documents (BSD), Requirement Specification Documents (RSD), and Design Specification Documents (DSD)
- Involved in developing Test Strategy, Test Plan, Test Cases and Test Scripts using Quality Center for Functional, Navigational and Regression Testing in the conversion project.
- Performed extensive manual testing on critical functionalities of the application.
- Involved Manual testing, Functional Testing, Regression testing, System testing, Integration testing and end-end testing, User Interface testing and Data Driven Testing.
- Developed test cases in Excel and Qwac.
- Reviewed the App Def Document (Requirement Document) and prepared the test Plan and test cases.
- Coordinated with off-shore team on a daily basis to resolve issues.
- Created Test input requirements and prepared the test data for data driven testing.
- Testing on applications for major fraud, credit, debit, and collections applications for financial banks around the world.
- Testing Property&casualty Assessment Web Application for, Farm, Commercial and Industrial
- Executed automated test scripts using QTP for Regression testing.andtested application in PC domain
- Created Test Scenarios to Validate Data ETL Loads and Front end.
- Executed Data mapping and valadation for testing purposes on various projects utilizing Informatica.
- Developed automated scripts using QTP AND JTAF to perform functional and regression testing
- Logged tickets in Jira for issues found.
- Used Quality Center as defect tracking and bug fixing tool Prepared change requests for the bugs in the application and helped developers to track and resolve the problems.
- Generated Bug Reports and Test case coverage reports for status meeting and involved in resource planning for test cases coverage
- Performing regression testing in various stages of Software Testing Life Cycle (STLC).
- Tested web pages, database connections, forms used in the web pages for submitting data to database and links to open reports from the web pages.
- Used Quality Center as test management tool to manage/execute the test cases and test cycles.
- Wrote SQL scripts to compare results with front end screen and ETL data mappings.
- Conducted data integration, data mining, data quality, OLAP, OLTP, data analysis, warehousing with ETL - Informatica.
- Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
- Executed queries in MySQL to verify the validity of the data
- Written several complex SQL queries for validating Business Objects Reports.
- Validated Database Integrity testing by executing SQL statements
- Involved in testing the UI applications
- Performed end to end testing by dropping the files and generating the output file
- Testing Various strategies for each application through Appedit.
Environment: Java 6.0, J2EE 1.4, Windows XP, Weblogic 10.3, SQL Server 2005, Informatica,Web Service(JAX-WS, Axis 2), Agile/Scrum project methodologies,OLAP,HTML,XHTML, XML, Quality Center, QTP, QWAC, DB2, MySQL, SQL,TOAD, JIRA, ETL, Business Objects, Flat Files
Confidential, Chicago, IL
Sr. QA Analyst
Responsibilities:
- Involved in meetings withBusiness Analysts and End Users to review functional/technical requirements and responsible to translate business requirements into quality assurance test cases.
- Used Quality Center as test management tool to manage/execute the test cases and test cycles.
- Involved in reviewing test scenarios, test cases and test results for data warehouse/ETL testing.
- Preparation of test cases for Functional, Regression, Integration and System testing.
- Used Informatica as an ETL Tool for Developing the Data Warehouse.
- Prepared Requirements Traceability Metrics (RTM), positive and negative test scenarios, detailed oriented Test Scripts, Test Kickoff documents, Test Scorecard for test progress status, Test Results, Release Check list, Lessons Learned documents and Regression Test Suite for future use. worked with an offshore team also to improve process in the QA environment
- In between Production implementation, execution of Back End testing and data retrieval for another project utilizing Informatica.
- Identified the bugs and interacted with the team lead and developers to resolve them.
- Testing and Reporting the Bugs in product releases and performed the Root Cause Analysis for the Defects raised.
- Extensively usedRational Clear Questto track defects and managed them.
- Performing automated regression testing using QTP and as well as manual testing
- Automated the functionality and interface testing of application using QTP
- Conducteduser acceptance testing (UAT)to validate that the developed application meets the business requirements and executed/monitored AutoSys jobs
- Executed automated test scripts using QTP for credit check application.
- Validated ETL DW load statistics and Data mart Loads on an Ongoing Basis
- Collaborated with Informatica Admin in process of InformaticaUpgradation from PowerCenter 8.6 to PowerCenter 9.0.
- Validated the DB2 data against the ODS.
- Generated detailed test scripts while recording by configuring the events recorded for web objects in QTP
- Mocked test data to test all the scenarios and test cases planned.
- Conduct backend testing by querying databases to synchronize testing databases and check for data integrity and proper routing based on specifications.
- Run the scheduling jobs to load ACBS data from Legacy (Mainframe) System to staging tables.
- Run ETL Jobs to load ACBS data from staging tables to ODS.
- Validated that all newly required ACBS data loaded into Oracle via an initial drop &load.
- Validated that all newly required ACBS data changes are incrementally loaded into Oracle via the incremental processing.
- Used TOAD to develop and execute test scripts in SQL, to validate the test cases.
- Created Test Scenarios to Validate Data ETL Loads and Front end
- Written several complex SQL queries for data verification and data quality checks.
- Preparing and analyzing Weekly and Monthly status reports. Analyzing root cause investigation for the broken links.
Environment: UNIX, FTP client, JIRA, Java, TOAD, Oracle 11g,ETL,DWH,Ms Office, Informatica,Text pad, Quality center, QTP, Business Objects, ETL, Autosys, Agile/Scrum project methodologies, TSO/IPF, DB2, SQL,MAINFRAME, MVS COBOL, JCL, CICS and File-Aid
Confidential, Hartford,CT
Sr. QA Analyst
Responsibilities:
- Experienced in requirements gathering, including reviewing and analyzing documentation.
- Created test cases, scenarios, and procedures using Quality Center.
- Developed, maintained and continually improved test plans, test cases and test matrixes.
- Responsible for Manual Testing, GUI Testing, Interface Testing and System Testing
- Performed System, Functional and Black-box Testing.
- Developed test data depends on the Test Scenarios as per the functionality of the application
- Used the SPUFI/QMF to run DB2 SQL queries
- Used Internal Web service test page tool to check the response of the application by sending XML format request to the server.
- Identified, verified, reported defects using Quality center.
- Participated in Team meetings for daily and weekly QA Testing reviews.
- Involved in Reviews and Coordinated work with offshore testing team
Environment: UNIX, FTP client, Clear case, Clear Quest, Java, JCAPS (Java Composite Application Platform Suite), TOAD, Oracle 11g, Ms Office, Text pad, Spec builder 7.0, Quality center, QTP,ETL, Load Runner, Cognos, ETL, Autosys, Agile/Scrum project methodologies, Quality Center, SQL, ASP.net, SOAP-UI, XML, Main frames, DB2
Confidential - Stamford, CT
Sr. QA Analyst
Responsibilities:
- Define and implement test suites for various aspects of software testing (e.g. things like functional, System, UAT, Regression etc
- Collaborate with other team members (both Tech and non-Tech) to clarify business requirements, define acceptance criteria, and create test cases.
- Conduct white-box and black-box testing of web applications to verify functional and non-functional requirements.
- Verify, reproduce and document defects; assist in defect triage and root-cause analysis.
- Improve testing strategy and practices throughout the entire organization.
- Educate, teach, and mentor other team members on testing practices and tools.
- Help define and measure metrics for tracking the quality of our application code base.
- Documented errors and implemented their resolutions.
- Involved in analyzing and designing manual test cases.
- To interface with development and operation’s team to ensure the quality of software to user expectation and also Communicate with release coordinator for patch release when needed
- Work with release coordinator to get code based on a staging environment so it can be tested and ready for release
- Involved in Data Driven testing using parameterization in QTP to test the application with different sets of data.
- Created various checkpoints to verify the expected behavior of the AUT.
- Involved in Key word driven automation framework using functional testing tool QTP.
- Extensively involved in manual testing and Automated testing
Environment: Oracle 8, QTP, Quality Center, Java, J2E, GUI, HTML and SQLOracle, TOAD, JAVA, Informatica, .Net WPF, XML Spy, C#, ETLWinForm Client, eDocs, Quality Center, QTP, Load Runner, Cognos, Informatica, Datastage, Microstrategy