We provide IT Staff Augmentation Services!

Etl Tester Resume

0/5 (Submit Your Rating)

Sandimas, CA

SUMMARY

  • Over 7 years of experience in Testing Java based web Applications using bothManualand Automation Testing.
  • Over Two years of experience in Mobile Testing in IPhone, Android using SeeTestManual
  • Extensively worked on Mobile and Tablet testing and performed Cross browser and OS combination testing on different platforms and Devices.
  • Extensively tested on 3 tier applications (Java based Web server applications)
  • Have knowledge on Payment Systems and Transfer systems in Banking Domain.
  • Worked on Wire/EFT/RTGS/ACH/Telegraphic/overseas Transfers.
  • Experience in working with data warehouses testing and developing using Informatica Power Center (Designer, Repository Manager, Workflow Manager and Workflow Monitor)
  • Experience in ETL testing and Executed ETL code to load data in database tables using a scheduling tool such as Control - M
  • Experience in Security Testing and Mainframe Testing.
  • Excellent experience working independently and as a Team Member for testing web based applications using Java, asp, .Net, Insurance and financial applications.
  • Extensively worked on Penetration testing techniques like CSRF attack, SQL Injection, In secured Direct Object Reference, XSS and other major Vulnerabilities.
  • Excellent understanding of the Software Development Life Cycle.
  • Excellent skills in testing web-based applications.
  • Strong skills in performing Functional, Regression, Smoke, Front End and Back End Testing.
  • Extensive work with PL/SQL, performance tuning of Oracle using SQL trace, SQL plan, SQL hints, Oracle partitioning, various indexes and join types
  • Good experience in Preparing Test Plan, Test data preparation, Writing & Executing Test cases and Documenting Test results.
  • Good knowledge of Software Testing life cycle.
  • Skilled in a high-volume workflow with creative problem resolution capabilities.
  • Good work experience in Retail, Banking, Finance and Insurance Domains.
  • Excellent Team Interfacing, Customer facing and Communication skills.

TECHNICAL SKILLS

Testing Tools: QTP, QC, RTH, Bugzilla, Toad, Burp Suite, Load Runner and RUMBA

ETL Tools: Informatica Power Center 9.0.1/8.6

Test Management Tool: RTH, Quality Center, ALM.

Methodologies: ETL, Water fall, RAD, Agile and Software Development Life Cycle.

Languages: C, C++, Java, HTML, V.B 6.0.

RDBMS: MS SQL Server 2005/2008, Oracle 9i /10g/11g, DB2, Teradata

Servers: IBM Web sphere 3.5.2 /2.0, Web logic 5.1/4.5, Java Web Server and Tomcat-Apache Server

Operating System: Windows 7/2000/XP& Professional, UNIX.

PROFESSIONAL EXPERIENCE

Confidential

ETL Tester

Responsibilities:

  • Used Informatica Power Center 8.1.1 in migrating data from various OLTP databases and other applications to the Radar Store Data mart
  • Created Informatica mappings with extensive use of Aggregator, Union, and HTTP Post, Filter, Router, Normalizer, Joiner and Sequence generator transformations.
  • Worked with different sources like Relational, Mainframe (COBOL), XML and flat files (CSV).
  • Created and used parameter files to perform different load processes using the same logic.
  • Extensively used PL/SQL for creation of stored procedures and worked with XML Targets, XSD's and DTD's.
  • Performed performance tuning of targets, sources, mappings and session and performed pipeline partitioning.
  • Utilized the new utility Informatica Data Quality (IDQ) and Informatica Data Explorer (IDE) that came up with Informatica Ver.8.
  • Defined Target Load Order Plan and Constraint based loading for loading data appropriately into multiple Target Tables.
  • Expertise in using different tasks (Session, Assignment, Command, Decision, Email, Event-Raise, Event-Wait and Control).

Environment: Informatica power center 8.1.1, Power Exchange, Oracle 9i, XML, UNIX, PL/SQL, Windows 2000/XP.

Confidential, Sandimas, CA

Test Lead

Responsibilities:

  • Strong Agile Scrum Experience; Planning Meeting, Daily Stand up meetings, Demo meetings, Burn Down Charts, User Story Estimation, Capacity Planning.
  • Delivery and Management of the project.
  • Preparation of test plan and scenario wise test cases.
  • Test Execution and tracking of Defects using Quality Center.
  • Java based Web application testing
  • Preparation of test reports and weekly/monthly status reports
  • Participation in peer reviews of test artifacts.
  • Good exposure to SQL queries written in MS SQL server and Oracle using TOAD tool
  • Worked in Documenting Software Defects, using Bug Tracking Tools and Reporting Defects to software developers.
  • Knowledge transfer and training offshore team members.
  • Maintaining all the Quality process and related documents
  • Preparing the weekly/monthly status reports
  • Handling Onsite-Offshore Status Meetings

Environment: Websphere Application, Weblogic Application, Oracle using TOAD, Application Life cycle Management (ALM), Quality Center (QC), SAP-BI, Mainframes, DB2, JAVA, XML, UNIX, Water fall model, Control-M.

Confidential, Sandimas, CA

Test Lead

Responsibilities:

  • Delivery and Management of the project in all 3 phases.
  • Preparation of test strategy, test plan and scenario wise test cases
  • Test Execution and tracking of Defects using Quality Center.
  • Preparation of weekly status reports.
  • Testing of Java Based Web applications
  • Knowledge transfer and training other team members.
  • Maintaining all the Quality process and related documents
  • Handling Onsite-Offshore Status Meetings

Environment: Websphere Application, Weblogic Application, Oracle using TOAD, Application Life cycle Management (ALM), Quality Center (QC), SAP-BI, Mainframes, DB2, XML, UNIX, Agile, Control-M.

Confidential

Senior Test Analyst

Responsibilities:

  • Delivery and Management of the project.
  • Preparation of test plan and scenario vise test cases.
  • Test Execution and tracking of Defects using Quality Center.
  • Performed testing on both Apps and Browser based applications on different Mobile and Tablet devices.
  • Extensively worked on Mobile and Tablet testing and performed Cross browser and OS combination testing on different platforms and Devices
  • Tested various Apps on Iphone, Android and Windows using See Test Manual Tool.
  • Have knowledge on Payment Systems and Transfer systems in Banking Domain.
  • Worked on Wire/EFT/RTGS/ACH/Telegraphic/overseas Transfers.
  • Preparation of test reports and weekly/monthly status reports Using Quality Center.
  • Participation in peer reviews of test artifacts.
  • Working as a Lead for a critical module at Onsite.
  • Client interaction and Presentation of DSR (Daily Status Reports) to clients.
  • Knowledge transfer and training offshore team members.
  • Maintaining all the Quality process and related documents
  • Preparing the weekly/monthly status reports
  • Handling Onsite-Offshore Status Meetings
  • Reviewing and Reporting of Test Results

Environment: Websphere Application and Tomcat-Apache Server, Web Services, Oracle, See Test Manual, Mobile Testing, Citrix, Quality Center (QC), MAC, Android, Windows and Blackberry.

Confidential

Software Quality Analyst

Responsibilities:

  • Participated in defining a QA Process for the PSS product - Java based Web Application
  • Understanding the Functionality of the application.
  • Developed Load Runner test scripts according to test specifications/ requirements.
  • Identify and eliminate performance bottlenecks during the development Lifecycle.
  • Verified that new or upgraded applications meet specified performance requirements.
  • Used to identify the queries which taking too long and optimize those queries to improve performance
  • Developed Scripts in HTML/HTTP, Citrix for LoadRunner
  • Written, Developed, Executed Integration Test scripts
  • Involved in defects tracking and defect analysis.
  • Independently develop LoadRunner test scripts according to test specifications requirements.
  • Using LoadRunner, execute multi-user performance tests, used online monitors, real-time output messages.
  • Develop and implement load and stress tests with LoadRunner, and present performance statistics to application teams, and provide recommendations on how and where performance can be improved
  • Monitor and administrate hardware capacity to ensure the necessary resources are available for all tests.
  • Preparation and execution of test scripts using JMeter and SOAP UI tool to perform Web Services testing.
  • Tested deployment of applications in Enterprise environments during all phases of the product cycle. Worked with Developers, as necessary, to isolate and repair bugs.
  • Functional responsibilities included, Stress Testing, System Testing, Integration Testing, Unit testing and Regression Testing on application.
  • Reported and Documented the Defects.
  • Generated reports and metrics to provide project status to upper management.

Environment: Weblogic Application Server, Oracle, JMeter, SOAP UI, Load Runner and Quality center, Java, SQL, AJAX, XML, Bugzilla.

Confidential, Wellesley Hills, MA

Software Quality Assurance Engineer

Responsibilities:

  • Understanding the functionality of the application.
  • Preparing AID documents for the application.
  • Participated in KT Sessions
  • Functional Study on Use Case documents
  • Involved in preparing Test Plan & Test Strategy
  • Assisted in Execution of Automated Test scripts using QTP
  • Execution of Test Cases & Test Scripts in QTP using Keyword driven Framework.
  • Deployment of build in QA, client Environments.
  • Participated in daily & weekly status meetings with the client
  • Finding bugs and Reported to the same Involved in Functional, GUI and Regression testing.
  • Worked with and supported release team on applications deployment and acceptance testing.
  • Generated Reports as per Requirements.
  • Liaison between QA and business unit managers, development teams, and support staff, and thus acted as the primary resource for resolving issues

Environment: Websphere Application Server, SQL Server, QTP and Quality center, Java, SQL, AJAX, XML, RTH, Bugzilla.

We'd love your feedback!