Etl Tester Resume
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.