We provide IT Staff Augmentation Services!

Etl Tester Resume

Providence, RI

SUMMARY:

  • 7 years of experience as Quality Analyst in Healthcare, Banking & Insurance. Vast knowledge of Software Development Life Cycle & its methodologies, expert in Quality Assurance testing of Web Based. Client/Server, ETL and BI applications.
  • Expert in using the Agile/Scrum and Waterfall testing lifecycle Methodologies
  • Experienced in developing, Reviewing, and Executing Test Strategy, Test Plans, Test Scenarios, and Test Cases/Script.
  • Experience in creating Test Readiness Review (TRR), Requirement Traceability Matrix (RTM) documents.
  • Experience in both manual and automation testing process and in creating automation environment using Quick Test Pro (QTP), Test Director, Quality Center.
  • Expertise in test strategy design based on the various types of testing including integration, function, system, End to End, load, stress and performance testing,Bakend(Database) Testing.
  • Interact with clients for Quality discussions and responsible for the QA deliverables.
  • Expertise in Microsoft office (Word, Excel, Power Point, Outlook & Visio)
  • Proficient in SQL query and testing RDBMS such as Oracle, MySql, SQL Server for data validation.
  • Proficient in using SQL Queries using TOAD & SQL Plus to ensure data consistency of front - end and raw feed by developing and executed complex SQL queries for data base.
  • Strong experience in testing ETL applications and BI reports.
  • Sound Knowledge and experience in Star schema/Snowflake schema.
  • Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
  • Strong working experience in Windows NT/2000/XP and UNIX environments
  • Strong testing experience in UNIX platform.
  • Expert in reviewing/reporting, tracking, & maintaining Defects with high level of detail, accuracy and informative recreation steps using Quality Center, Clear QUEST, Bugzilla, and Email (outlook)
  • Ability to learn and adapt to new tools and technologies very quickly
  • Excellent Communication and interpersonal skills with clear understanding of business processes and ability to work as part of team or individually.

TECHNICAL SKILLS:

Functional Testing Tool: QTP 8.0/8.2/9.2/9.5/10.0

Defect Tracking Tools: HP ALM 11/ HP Quality Center 10/9.0/9.2, IBM Clear Quest 9.0

ETL Tools: Informatica 9.0, Ab Initio 1.15, IBM Info sphere DataStage 8.6BI/Reporting Tools: Business Objects XIR4, Crystal Reports XIR4, Cognos 8.4

Operating System: Windows 98/XP/2000,UNIX, Linux

Methodologies: Agile/Scrum

Programming Languages: SQL, PL/SQL, XML, java, C

RDBMS/ Database: Oracle 9i/10g, IBM DB2, Teradata 12.0, SQL Server 2008/2005

GUI Tools: TOAD, Oracle SQL Developer, SQL* Plus, SQL server Managements

PROFESSIONAL EXPERIENCE:

Confidential, Providence, RI

ETL Tester

Responsibilities:

  • Analyzed the existing system and process gaps in context of new conversion of Flagstar and RBCB bank changes.
  • Conducted JAD sessions with management, SME’s, Business users and other stakeholders for open and pending issues to develop specifications.
  • Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
  • Prepared test cases in Test Plan tab execute in Test Lab and logged defects using Application Management Life Cycle QC 11.
  • Written SQL queries manually and also built SQL queries using TOAD to validate the Customers ' addresses and accounts level data .
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Ensured that migrated data is complete, accurate and correct from Oracle database.
  • Used TOAD Software for Querying ORACLE.
  • Performed Data Verification, data Validation, and Data Transformations on the Input data (Text files, XML files) before loading into target database
  • Performed manual back end testing while retrieving the data from the Oracle database for financial applications like DDA, SVG, IRA, CDS, and DCA.
  • Test Business Objects reports for data validations and compare results with TOAD.
  • Tested reports using Business Objects functionality like Queries, Slice and Dice, Drilldown,Header,Drill up etc
  • Extensively used MS Office and MS Word data sheets to import positive and negative results in QC 11.
  • Followed up with standard application testing process to perform different types of testing phase for the FLAGSTAR and RBCB projects.
  • Involved in developing UNIX Shell wrappers to run various SQL Scripts.
  • Co-ordinate with business and technical people regarding test run results.
  • Used IBM Lotus note and Clarity for documentation.
  • Weekly meeting with the Project Management team and share the Status Report on the weekly basis

Environment:: SQL, TOAD 7.o, Quality Center 11, MS Office 2007, Windows XP/2003,, Oracle 10g, Informatica 9,Business Objects XIR4

Confidential, Mclean, VA

ETL Tester

Responsibilities:

  • Analyzed the Business Requirements and Rules and worked with business Analysts and Business Users in preparing Test Plans
  • Developed Test cases, Test scripts from the data mapping documents, functional Specification documents and mapped the test cases with the requirements for generating the Requirement Traceability Matrix (RTM).
  • Closely went through and worked on all the stages of SDLC for this project and designed and executed Functional, Integration, Regression and System (End to End), UI Testing, Browser Compatibility, Backend (Database) Testing.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Used TOAD Software for Querying ORACLE. And Used SQL Server Management studio for Querying SQL server
  • Performed Data Verification, data Validation, and Data Transformations on the Input data (Text files, XML files) before loading into target database
  • Monitored the session logs/log files in Informatica Workflow Monitor.
  • Analyzed and tested Informatica Mappings with OLTP source data, staging and target data
  • Manually performed Back-End testing by writing SQL queries and validating the database using Complex SQL Joins and Functions.
  • Used HP Quality Center as test management and defect management tool.
  • Prioritized the test cases based on the projected metrics and project deadlines.
  • Worked with Developers on Defects until the test case is passed.
  • Extensively written SQL to confirm the data transfer from source to target.
  • Involved in testing the UI screens, reports which was used by the internal business team.
  • Prepared Test Scenarios by creating Mock data based on the different test cases.
  • Test Cognos reports for data validations and compare results with TOAD.
  • Used Quality Center for Bug Reports and Defect Tracking.
  • Tested summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
  • Extensively tested several Cognos reports for data quality, fonts, headers and cosmetic
  • Tested the list, cross tab, repeater and Drill-through reports in different formats like PDF and HTML.
  • Attended Bi-Weekly Defect Review and Defect Status meetings.
  • Provided updates To the Team Lead on testing activities

Environment: HP Quality Center 10, Informatica 8.6, Sql server 2008, Oracle 10g, TOAD, SQL, SQL*Plus, Cognos, UNIX, Flat files, XML,, XML Spy 2010, Windows NT/2000

Confidential, Madison,WI

ETL/BI Tester

Responsibilities:

  • Involved in analyzing system design specifications and developed Test Plans, Test Scenarios and Test Cases to cover overall quality assurance testing.
  • Tested all the ETL process that were developed to fetch the data from various feeds into the data warehouse.
  • Written SQL scripts for validating the data loaded by the ETL processes.
  • Tested the reports developed using Business Objects.
  • Perform manual testing and created various test results to track the testing results.
  • Export requirement, test cases into the Quality Center, run manual and automation test cases from test lab and log defects from defects module.
  • Followed up with standard software testing life cycle (STLC) to perform different types of testing for the projects.
  • Participated in peer review meeting for created Test plan, test cases and analyzing various testing documents and process of testing life cycle.
  • Create standard testing life cycle flow diagram for projects and presented to test team to follow testing process.
  • Participated to create Test Analysis reports (TAR) and stored them into the Quality Center.
  • Updated RTM in daily, send status report and daily tracking report to test manager.
  • Performed UAT testing in the UAT environment prior to notify to the customer to start performing UAT testing.
  • Developed SQL Queries to retrieve or create test data from different Oracle Test databases.
  • Met with client to present future functionality of the application, gather information from them to know about their need and send this information to test manager.
  • Worked closely with the application development and design and testing team to resolve technical issues and interacted with them to ensure overall quality of the software.

Environment:: Quality Center 9.2, Web Services/Web methods, XML, HTML Oracle, SQL, TOAD, Windows 2003/2007, UNIX, DataStage, Business Objects

Confidential, Arlington Heights, IL

QA Consultant

Responsibilities:

  • Responsible for providing the testing team with the required business data, rules and logistics from the business, architecture and development teams and to inspect final scripts and confirm to laid down standards.
  • Developed, modified and executed test cases and scripts using Test Director and WinRunner for Assembly, Functionality and Regression testing.
  • Directly used backend servers, like AS400, Mainframes, DB2 and SQL Server for Backend Testing and other validations.
  • Involved in designing and developing validation and test plan documentation.
  • Prepared detailed reports of Bugs and Defects, pass/fail reports and comparison analysis, and interacted with the development teams, application and data architecture teams, migration and build teams and the DBA team to report and correct defects.
  • Interacted with the Business Requirement and Client Advocate teams to understand, test and compare old and new business rules.

Environment:: Java (J2EE), ASP.NET, SQL Server 2005, Win Runner 8.0, Quick Test Pro 9.0, Load Runner 8.1, VB Script, Quality Center 8.2.,Bugzilla, MS Visio, MS Project, MS Windows 2003

Confidential, Baltimore, MD

Quality Analyst/ Software Tester

Responsibilities:

  • Created scenarios based on business conditions and functions.
  • Comparing/analyzing mainframe test data with the front end.
  • Running SQL queries on the mainframe servers to retrieve test data.
  • Creating and running automated scripts through Mercury Win runner.
  • Reviewed Functional and Integration requirements.
  • Develop Functional and integration test cases and review Test Cases wrote by peers.
  • Created Test Cases, and got reviewed those by peers
  • Discuss issues/defects with the business and development teams.
  • Testing/Verifying/logging defects.
  • Performed application setup in test environment and enhancing the documentation.
  • Worked with internal and external developers/quality assurance staff to understand and resolve issues.

Environment:: Win Runner 7.5/7.6,Mercury suite QTP 6.5/8.0/8.2, Load Runner 7.8, Quality Center, Windows, Linux, Java, C, HTML, Oracle10g, SQL 2000/2005.

Hire Now