We provide IT Staff Augmentation Services!

Etl/qa Tester Resume

5.00/5 (Submit Your Rating)

Edgewood, PA

SUMMARY

  • 4 years of Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
  • Manual & ETL testing experience using Informatica (Power Center) (Designer, Workflow Manager, Workflow Monitor and Server Manager).
  • 3 years of strong data base experience inOracle, SQL Server 2010.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Experience in ETL BACKEND TESTING.
  • Knowledge in UNIX Shell Scripting.
  • Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
  • Expertise in handling Onsite - Offshore model, client handling and continues business process.
  • Front-End Web Testing usingQuality Center.
  • Extensively worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.
  • Application Data warehousing experience in Banking, and Healthcare.
  • Performed Integration and System Testing.
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica. Strong Knowledge of relational database design.
  • One Year Experience in Manual Testing on windows and client server based application.
  • Strong Experience in System Testing, Functional Testing, Regression Testing, Performance Testing, Build Verification Testing, and User Acceptance Testing.
  • Highly experienced on Manual Test Environment.
  • Experience in developing Test Cases, Test Plans and various reports.
  • Strong understanding of SDLC, STLC and Agile Methodologies.
  • Involved in various stages of Software Development Life Cycle (SDLC) implementing Waterfall, V-Model, and Agile, Iteration, Scrum methodologies.
  • Versatile team player with excellent analytical, presentation and interpersonal skills with an aptitude to learn new technologies.
  • Solid time management and multitasking skills, which halp in conducting project meetings, reviews, walkthroughs, and customer interviews according to teh varied needs of teh people involved.
  • Excellent written and oral communication skills and a team-player with a results-oriented attitude.

TECHNICAL SKILLS

Operating Systems: Windows XP/ 2000 Professional /98/NT, UNIX

Languages: PL/SQL, Shell Scripting, Java, SQL

Database: ORACLE, SQL Server, DB2 and MS Access, OLTP, LAP

Testing Tools: PVCS, Rational Clear Quest, Test Director, Quality Center

Test Automation: Quick Test Professional, Load Runner

ETL Tools: Informatica, Datastage

PROFESSIONAL EXPERIENCE

Confidential, Edgewood, PA

ETL/QA Tester

Responsibilities:

  • Member of teh warehouse design team, assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Extensively used Informatica power center for ETL process. Preparation of ETL mapping specifications.
  • Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplet Designer and Transformation Developer. Designed mappings for dimensions and facts.
  • Extensively used various types of transformations such as Expression, Joiner, Update strategy, Look up, filter for developing mappings
  • Development of mappings as per teh technical specifications approved by teh client.
  • Created reusable transformations and mapplets to use in multiple mappings.
  • Implemented performance tuning logic on targets, sources, mappings, sessions to provide maximum efficiency and performance.
  • Implemented Error handling logic to capture teh invalid data.
  • Created sessions and workflows to run with teh logic embedded in teh mappings using Power center Designer.
  • Involved in extensiveDATAvalidation using SQL queries and back-end testing.
  • Used workflow manager for session management, database connection management and scheduling of jobs.
  • Creating teh catalogs and analyzing teh joins.
  • Maintained various versions of teh documents generated during teh project using Rational Clear Case.
  • Logged bugs dat would enhance teh usability of teh application using Rational Clear Quest.
  • Designed and implemented basic SQL queries for QA testing and report/ data validation.
  • Assisted teh QA team in designing teh test plan and test cases. Performed User Acceptance Testing.

Environment: Informatica Power Center 8.5 (Power Center Designer, workflow manager, workflow monitor), HP Quality Center 9.2, Oracle8, SQL Server 2000, Windows 2000. UNIX Shell Scripting

Confidential, New York City, New York

QA/ETL Tester

Responsibilities:

  • Implement teh strategic plan for support of future company information requirements.
  • Involved in predefining data mapping from ETL & BI to teh relational source, and running ad-hoc queries for providing optimized reports.
  • Created Test Strategy for Enterprise Data Warehouse in ETL framework, including Business Intelligence.
  • Involved in Business analysis and requirements gathering.
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
  • Involved integration testing of Informatica mappings.
  • Involved in teh Meetings scheduled in order to discuss teh documented Defects logged by teh testing team using Clear Quest.
  • Fully documented and replicated defects for Developers, enabling them to fix Defects faster and meet Production Deadlines.
  • Used Quality Center for Requirement Gathering and Test Case, Test Case Execution and Defect Tracking
  • Preparation of technical specifications and Source to Target mappings.
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
  • Solid testing experience in working with SQL queries.
  • Validated teh data after running teh batch process from differentMainframe systems
  • Provided technical guidance and support to end-users by developing teh documentation required.
  • Worked on Excel Add-in Tools to generate various reports to analyze teh business
  • Created users, user groups in teh Planning application for accessing teh various application elements.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Worked with ETL group for understating mappings for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Involved in offshore and onsite Coordination activities

Environment: Informatica 8.6,SQL Server2000/2005, HP Quality Center 10.0, Oracle 9i/8i, XML, XSLT, Rational Clear Quest, Clear Case, UNIX Shell Scripting, UNIX, Windows 2003, SQL, TOAD

Confidential, Princeton, NJ

Manual QA Tester

Responsibilities:

  • Understand teh application business logic with Business Requirements Specification Documents and functionality of application with Functional Requirements Specification Document.
  • Analyzed functional requirements and technical specifications to formulate test scenarios and detailed test cases.
  • Wrote test cases for functional specifications and test them manually.
  • Manually create, develop and executed Test Cases.
  • Execute manual testing for all cases.
  • Extensively used Quality Center for creating, updating and executing test cases.
  • Conducted Functionality and Regression testing during teh various phases of teh application.
  • Used Quality Center & MS Excel in creating reports to update teh test execution status on a daily & weekly base.
  • Used HP Quality Center (QC) and Serena Business Manager for reserving, executing test cases, defect tracking, and teh complete test management.
  • Created data using XML and MS Access for batch processing.
  • Performed negative testing to test teh application for invalid data, verified and validated for teh error messages generated.
  • Executed testing in QC to test teh front-end and back-end functionality of teh application.
  • Interacted with developers and other QA Analysts to report and resolve defects.
  • Teh tests also include GUI testing: Testing for validation and display of screen.
  • Involved in entire Software Development Life Cycle(SDLC)
  • Wrote SQL queries to test teh oracle database and validate teh data integrity.
  • Executed SQL Queries for testing integrity of data in database (Backend Testing)
  • Attended test strategy meetings for test assignments.
  • Attended project meetings, release meetings, and QA status meetings.
  • Conducted Weekly Onsite-Offshore Status Meetings
  • Initiated and participated in conference calls, walkthrough ad review meetings.

Environment: HP ALM 11.0, C#, .Net, ASP.NET, Java, XML, HTML, ALM, MS Office, Unix Shell Scripting, UNIX, Toad, Oracle, Sql Server

We'd love your feedback!