We provide IT Staff Augmentation Services!

Etl Tester Resume

Rochester, MN

SUMMARY:

  • Experience: 8+ years of Global IT Industry working Experience
  • Self - Motivated, Flexible to adapt to changing priorities and deadlines. Systematic and organized approach.
  • Believe in Commitment to Excellence and Team Spirit. Multi-tasking projects Handling Capabilities.
  • Excellent Presentation, Communication, Writing & Interpersonal skills.
  • Over 8+ years of experience in Software Quality Assurance Testing in ETL, Informatica, Manual & Automation.
  • Good knowledge in Banking, Insurance, Mortgage, Health Care applications
  • Experience in testing mainframe/internet/intranet/client-server/stand-alone applications using ASP, VB, XML, HTML, DHTML, Java, J2EE and .Net applications.
  • Conversant with all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC) in Req. gathering, Analysis, Design, Development, Implementation, Testing, Methods like Waterfall and AGILE.
  • Experience in Web/GUI functional testing and worked and tested SOA environments
  • Skilled in creating test traceability matrix, test plan, test design, use cases, test cases, test procedures, test log, automated test scripts and defect reporting.
  • Extensive experience in use of Mercury Interactive Suite like Test Track Pro, Win Runner, Quick Test Professional, Test Director, and Load Runner
  • Worked with large Databases in Testing and Production environments, Data warehousing and ETL process using Abinitio.
  • Developed and designed Mappings using Abinitio ETL tools for testing the data flow from Data Warehouse to data marts to compare the totals at summary level.
  • Experience in Rational Suite-Rational Robot, Test Manager, Clear Quest, Clear Case, Requisite Pro, Rational Rose.
  • Test Automation: Developed and implemented test suites, which includes features like synchronization points, Data Driven, Database Checks, Batch and Functions etc.
  • Experienced in Equivalence Partitioning (ECP) and Boundary Value Analysis (BVA).
  • Expertise in RDBMS backend testing for data validation and data integrity using SQL.
  • Experience in using the verification points and Data pools for Data Driven Tests in projects with Rational Robot and Test Manager
  • Extremely Dedicated self-motivated Proactive and willing to assume responsibility.
  • Good experience on Team Management for different projects.
  • Personal skills include Excellent Communication, strong sense of Organization and Effective Time Management and have the Ability to work in a team as well as independently.
  • Executed negative and positive test cases to test application functionality against user requirements.

TECHNICAL SKILLS:

Test Tools: Quick Test Pro, Win Runner and Test Director and Rational Test Suite

Languages: C/C++, .Net -ASP. Net, VB.Net, JAVA, XML PL/SQL, & HTML

Databases: ORACLE 8i/9i, DB2, MS SQL, SQL Explorer and MS - Access.

Tracking Tools: Test Director 8, GNATS and Bugzilla

Utilities: Visio, SQL Load, FTP, Telnet, Rational Clear Case, All Fusion.

Operating Systems: Sun Solaris, Citrix, HP-UX, UNIX, DOS, Windows

Miscellaneous: MS DOS, Word, Excel, Power Point, VSS and All Fusion (Harvest).

PROFESSIONAL EXPERIENCE:

Confidential, Rochester, MN

ETL Tester

Responsibilities:

  • Involved in gathering requirements and analysis for applications.
  • Developed Test Plans, Test Cases, Test Scripts for UAT test s
  • Used Informatica as an ETL Tool for Developing the Data Warehouse.
  • Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in Req Pro.
  • Developed Tractability Matrix and Test Coverage reports.
  • Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
  • Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
  • Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing.
  • Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
  • Used Shell scripts extensively for automation of file manipulation and data loading procedures.
  • Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
  • Execute batch processing and verify the jobs status and data in database tables
  • Responsible for designing Framework and executing automation scripts using QTP.
  • Tracked the defects using Clear Quest and Quality Center and generated defect summary reports
  • Modified Configuration file according to space constraints
  • Created checkpoints and synchronization points for functional testing using Quick Test Pro (QTP).
  • Wrote shell scripts to run PL/SQL programs and job scheduling.
  • Prepared status summary reports with details of executed, passed and failed test cases
  • Interacted with developers, Business & Management Teams and End Users
  • Participated in regular project status meetings related to testing

Environment: Rational Test Manager, Rational Clear Quest, QTP, Quality Center, Java, J2EE, XML, Flex, Oracle 10G, TOAD, PL/SQL, DB2, Unix Shell scripting MS-Project, SQL Navigator, Windows XP, Ascential, INFORMATICA

Confidential, Richmond VA

ETL Tester

Responsibilities:

  • Participated in Business Analysis, Technical Requirements and High level System Design Document Reviews.
  • Validated the source to target transformation mappings (ETL transformations ) for various projects which extracts and loads from different and multiple sources and targets like Oracle, Sybase, SQL server databases and flat files.
  • Involved in writing SQL queries with joins and filters to validate the Referential integrity and Data integrity between different related tables in the Data ware house.
  • Used Teradata to write the SQL queries.
  • Involved in mocking and manipulating the source data to validate complex ETL transformations to do negative testing scenarios and to validate the data quality checks.
  • Validated the data in the Analytical reports with the back-end data in the database for different user permission levels.
  • Worked with serial and multi file system(mfs)
  • Created System and Integration Test plans (BAS) and Test scenarios based on the System Requirements and the High-level design documents.
  • Participated in reviewing and validating the Source to Target (S2T) transformations mapping document.
  • Created System Test cases in Quality Center based on the System Requirements and the detail design documents and Source to target mapping documents.
  • Requirement Traceability Matrix (RTM) is created to trace all the system requirements to the test cases. The tracing of requirements to the test cases was done in Quality Center.
  • Involved in doing the System testing, Regression testing and Integration testing forvarious projects which involve ETL Validations in the Data ware house.
  • Coordinated with various upstream and downstream systems to do integration and end to end testing for different projects.
  • Conducting test case review meeting with Tech Lead, Developer.
  • Supported and participated in UAT (User acceptance testing) by loading the data into the data warehouse for the users to do UAT and to clarify the technical related questions during the UAT.
  • Worked with SQL queries for cross verification of data.
  • Used Quality center as defect tracking tool.
  • Involved in generating reports from Quality center regarding the defect and testing status updates and send to the teams at the time of system and integration testing .

Environment: Abinitio (ETL), UNIX, Teradata 13.0, Quality Center 10.00, Service Manager, SQL,DB2 PL/SQL, TOAD, Windows XP

Confidential, OH

ETL Tester

Responsibilities:

  • Actively involved in performing the requirement analysis, prepared test scripts, regression tests.
  • Performed all kinds of process audits like Requirements Audit, Design and Coding Audit, Project Initiation and Planning audit etc.
  • Experience creating and consuming web services including experience with technologies such as SOAP, WSDL, and XML
  • Validated XML Schema and WSDL files using XML spy, tested web services using SOAP Scope testing tool.
  • Reviewing business requirements, functional specifications and flow diagrams.
  • Executing test cases for all the replication jobs, using web application, client server applications, and Green screens.
  • Using Quality center for defects logging, tracking and issue resolution.
  • Reviewed business requirements, functional specifications and flow diagrams.
  • Extensively interacted with user and Involved in requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Integration test plan, Release notes etc.
  • Created Test cases and Test plans for functional testing, black box testing, grey box testing. weekly Status Reports to the team manager & participated in weekly status meeting with Team members, Business analysts & Development team
  • Created weekly status reports for defects, issues, conducted status meetings for project deliverables.
  • Manually and automatically tested the application for Regression Test on each new build of application.
  • Arranged, conducted Review meetings and submitted Test reports with QA recommendations. Actively participated in review meetings with business analysts developers and other team members.
  • Actively participated in various review meetings with the development team and users and assessed the test requirements and defined the required test procedures

Environment: Mercury Quality Center 9.0,SOAP UI,XML, Oracle 9i, DB2, SQL server 2003, HTML, XML, JAVA, J2EE, MS Office, UNIX.

Confidential

ETL Tester

Responsibilities:

  • Actively involved in performing the requirement analysis, prepared test scripts, regression tests.
  • Performed all kinds of process audits like Requirements Audit, Design and Coding Audit, Project Initiation and Planning audit etc.
  • Ensured that the test scripts were completed before the SIT cycle in testing starts. Keying has been done for the accounts that are tested before the day of batch process.
  • Generated weekly Status Reports to the team manager & participated in weekly status meeting with Team members, Business analysts & Development team.
  • Using Bug tracker for defects logging, tracking and issue resolution.
  • Using Share point to version control all the QA documentation.
  • Reviewed business requirements, functional specifications and flow diagrams.
  • Created Test cases and Test plans for functional testing, black box testing, grey box testing.
  • Implemented mappings using SSIS for Extracting, Transforming and Loading (ETL) data into various layers of the data warehouse.
  • Tuned data warehouse load process and report run times using various performance tuning tools and techniques.
  • Performed database testing, Suggested performance tuning techniques for ETL.
  • Divided the QTP test scripts in multiple actions to reduce the complexity
  • Used Quality Center for defect tracking and versioning documents.
  • Tested Retail Banking products with respect to Point of sale, Touch point Teller and Touch point Sales & Services.

Environment: DB2, SQL server 2003, HTML,QTP, DHTML, Java, Web logic, Clear Case, Selenium, Rational Clear Quest, DOORS, Test Manager, IBM Rational Functional Tester, Mercury Quality Center 9.0

Confidential

ETL Tester

Responsibility:

  • Successfully tested and deployed new Uverse E2E Product Lines (IPDSLAM, IPTV, VOIP and ADSL). Frontend testing using OPUS and PDC2.
  • Involved in preparation of the Test Data to meet the client requirements.
  • Performed Sanity Testing, System Testing, Integrated System Testing and Regression Testing. Execute testing in a fully integrated production like environment.
  • Validate code against Business Use Cases (BUC's). Concentrate on testing integration touch points
  • Pass real data between applications and Validate that data in downstream applications. Verify entire end user experience (i.e. Provision, Activation, usage, Billing, Care processes) meets expectations.
  • Used automation tests for Regression scenarios.
  • Performed Back End testing by validating the Transactions in the UNIX server.
  • Executed Test Cases and generate the Test Matrices using Test Director
  • Actively managed the in Daily Defect Calls to resolve the defects in efficient and in a timely manner. Updated the Project and Business Managers on the status of the testing.

Environment: Quality Center, Jack Track, WIN CVS,WINSCP, Web Logic, Windows NT, UNIX, CMM, JAVA,J2EE, HTML, DHTML, Web Services, XMLSPY,SOAP,XML,WSDL, TOAD, Uverse (PDC2 & OPUS), Oracle

Confidential

ETL Tester

Responsibilities:

  • Perform various testing methods like Functional Testing, System Testing, Stress Testing, Regression Testing and Installation Testing.
  • Front end screen validation is using Java Script
  • Analyzed Functional Requirement and Business Requirement Documents to get a better understanding of the system on both functional and business perspectives.
  • Analyzed the user requirements by interacting with system architect, developers and business analysts.
  • Involved maintaining requirements and maintained the traceability matrix between the requirements and Test cases.
  • Involved in Test Cases Review.
  • Development of SQL Queries for checking Data Transaction and Database Integrity.
  • Execution of defined test cases on each build.
  • Used Client’s Bug Tracking system to Reporting and track the bugs to closure.
  • Participated in Walk through and Defect report meetings periodically with client.
  • Communicated with development team to resolve the issues, performed regression testing to verify that bug fixes did not break some other functionality.

Environment: Win Runner, Test Director, Java, Web logic, Java Script,.net, UNIX, SQL Server 2000 and Windows NT

Hire Now