We provide IT Staff Augmentation Services!

Etl Tester  Resume

VA

SUMMARY:

  • Experienced Quality Assurance Analyst with 7+ years of experience in the Information Technology industry, involving analysis, both Manual and Automated testing of Client Server and Web applications.
  • Possess specific experience in the Telecom, Banking, and Financial Domains.
  • Proficient in writing Test Strategies, Test Plans, Test Cases, Test Scripts, Test Scenarios and Test Summary Reports for both Manual and Automated Testing.
  • Hands on expertise in Data ware housing concepts and tools. Involved in the ETL processes where in the organizations were using Datastage, Informatica, Ab initio and Autosys tools.
  • Possess specific experience performing testing including Backend, Frontend, Regression, Functional, System, Interface, Usability, Black box, Integration Verification and Validation End - to-end and User Acceptance Testing.
  • Experienced in Agile Methodology.
  • Proficient in Black Box and White Box Testing methodologies. Possess specific experience performing Regression and Functional Testing using Quick Test Professional
  • Proficient in Mercury s Test Director and Quality Center for Test Designing, Requirement Mapping, Reports, Test Execution and Defect Tracking.
  • Proficient in Rational Clear Quest and Quality Center for Defect Tracking
  • Defined and Implemented Processes and Procedures for QA Departments
  • Ability to work independently or in a team environment or in a rapid pace environment.
  • Possess strong interpersonal skills, communication and presentation skills with the ability to interact with people at all levels.

TECHNICAL SKILLS:

ETL /BI TOOLS: INFORMATICA, DATASTAGE, ABINITIO, TOAD, AUTOSYS

DATABASES /TOOLS: ORACLE 11i, SQL SERVER 2005, TOAD, SQL DEVELOPER

AUTOMATED TOOLS: QTP, QUALITY CENTER, RATIONAL CLEAR QUEST

WEBSERVICES TOOLS: SOAPUI

ENVIRONMENT: S WORKED ON: J2EE, XML, WEB 2.0, and AJAX

PROFESSIONAL EXPERIENCE:

Confidential, VA

ETL Tester

Responsibilities:

  • Developed Test Plans, Test Cases, and Test Scripts for SIT and support for UAT tests.
  • Used DATASTAGE as an ETL Tool for Developing the Data Warehouse.
  • Created Test Cases and developed Tractability Matrix and Test Coverage reports.
  • Managed and conducted System testing, Integration testing and Functional testing.
  • Extensively used the AutoSys jobs for the entire project.
  • Used the Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
  • Worked on SQL scripts to load data in the tables.
  • Extensively worked with DS (Designer, Director and Manager).
  • Used the DATA STAGE Director and its run-time engine to schedule the jobs, validating and debugging its components, and monitoring the resulting executable versions.
  • Tracked the defects using Clear Quest tool and generated defect summary reports.
  • Worked on Mainframe files.
  • Used Mainframes for the daily data from the production to SIT environments.
  • Experience testing on XML documents.
  • Experience working with Rational ClearCase for Version controlling and ClearQuest for defect tracking tool.
  • Validated the data movement and transformations are done correctly for MISMO.
  • Worked with Data Warehousing developers who extensively used DATASTAGE, to design mapping to move data from source to target database using Stages to do the functionality.
  • 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 ClearCase, Rational Clear Quest, XML, XQuery, XPath, XML SPY tool for XML, IBM CDC, DB2 9.5, PL/SQL, Unix Shell scripting, UNIX AIX 5.3, Autosys 4.0, Rapid SQL Navigator, Windows XP, DataStage 7.5.3, Mainframes OS.

Confidential, Chicago, IL

Sr. 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, Kansas City

Sr. ETL Tester

Responsibilities:

  • Performed the Product testing for checking the functionality of the application.
  • Handled order management system (OMS) such functions as order entry, sales analysis, inventory planning, and accounting, among others.
  • Queried databases with SQL to obtain sample data for billing verification.
  • Prepared Functional Requirements Documents to redesign two IDMS legacy systems into a DATACOM DB environment.
  • Developed a smooth handoff scheme in Mobile IP to decrease the handoff time between networks together with a LINUX based implementation
  • Defining defects and carried out test reports using Test Director 7.2 as Defect tracking system.
  • Responsible for client side validations using VB Script.
  • Executed test cases manually in Rational Test Manager and identified the mismatches and logged defects through Test director
  • Worked with the components of Data Warehousing like components model, ETL tools.
  • Web configuration portal database (Oracle) verification using QTP.
  • Development of Actuate Reports/ SQL Server Stored Procedures.
  • Identify the source tables from which the Data Warehouse extracts data.
  • Followed the Software Development Life Cycle in all stages of the project.
  • Prepared test data for positive and negative test scenarios for Functional Testing as documented in the test plan.

Environment: WinRunner 7.6, Test Director 7.8, ASP.NET, VB.NET, ADO.NET, JavaScript, IIS, VSS 6.0, web logic 8.1,SQL Server 2000, Web Services, JavaScript, HTML, Oracle 8i, Windows NT, Abinitio, Autosys.

Confidential, NJ

QA Tester

Responsibilities:

  • Analyzed Business Requirements and Identified documents required for system and functional testing efforts for all test scenarios.
  • Developed all the necessary documents for QA Testing like Test Strategies, Test Plan which includes all test items & Test Cases, and User Documents etc.
  • Validated the daily and monthly reports in against the data in Oracle databases
  • Worked in brokerage operations processing new accounts and general securities transaction process.
  • Reviewed manual testing methods and created and implemented an automated test strategy and generated automation scripts.
  • Participated in the development of data from the existing systems to the Oracle Financial Applications
  • Worked closely with users and Application developers to ensure that application development meets to user s expectations.
  • Maintained client database, working closely with team to relationship-manage customers and maximize referrals and sales opportunities .
  • Developed TSL scripts and GUI maps for all the test cases to be tested manually and automation using WinRunner for functionality, integration and regression testing.
  • Created WinRunner scripts that were used by other testers for regression testing.
  • Created automated scripts using WinRunner for checking functionality and rules defined in CORBA server using test driver programs.
  • Enhanced test scripts by inserting synchronization and checkpoints.
  • Gained familiarity with the use of Actions and Transactions. Parameterized the test script to run with different sets of data.

Environment: WinRunner 7.0, Test Director 7.0, C, Java 2.0, CORBA, Oracle and Windows 2000, Oracle 8.1.6/9i.

Hire Now