Summary:

• Over 7 years of experience in Web Services testing, ETL testing and manual testing on web based, Client/Server and data warehousing applications.
• Professional experience in Integration, Functional, Regression, Smoke and System Testing.
• Experience in Web based applications like online banking, transactions applications and ETL application like conversion, interfacing and Data warehousing.
• Expertise in Human resource management, Banking, and Financial domains etc.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica jobs.
• Experience in Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Experience in creating Requirement Traceability Matrix (RTM) documents.
• Experience in using HP Quality Center, ALM for Bug Tracking and Defect Reporting.
• Expertise in querying and testing RDBMS such as Oracle, SQL server and DB2 using SQL for data integrity.
• Expertise in validating the data on AS400 Screens.
• Hands on experience in LISA and DEV Test Automation tools.
• Experience in System Testing, Integration Testing, End - to-End Testing of complex multiple Interfaces and Regression Testing on Windows and UNIX environments
• Expertise in defect analysis, planning, assessing challenges / risks, estimating and scheduling of testing tasks for QA engineers and proficient in reporting, tracking, scheduling and managing bugs and issues to ensure commitment dates be met.
• Good experience in Water fall process and agile process.
• Having experience with automation testing tools like Quality Center (QC).
• Expertise in co-coordinating On-Site & Off-Shore teams and can handle multiple tasks.
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Flexible and versatile to adapt to new environment and hardworking and self-motivated.
• Highly motivated team player with excellent analytical, problem solving, interpersonal and communication skills.
• Excellent interpersonal communication skills, functional and technical documentation skills.

PROFESSIONAL EXPERIENCE:

Sr. ETL Tester

Confidential, Indianapolis, IN

Responsibilities:

• Involved in designing of Test Plan, Identifying Test Scenarios and Executing the Test Cases.
• Conducting Retesting with multiple sets of test data using Data Driven Approach.
• Identified and logged the defects based on the User Stories in JIRA.
• Verified the back-end reflection in the database by establishing connection to the database and by executing SQL queries both in manual and automation process.
• Writing Test cases and test scenario's on multiple applications to validate data end to end from source to target.
• Experience in testing data extraction/load programs developed using tool Informatica.
• Validating maps on Informatica to verify data from Source to Target data base & record test results.
• Extensively used ETL for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Performed Informatica ETL testing to validate end-to-end data from source system MS SQL Server and Target system Teradata environment.
• Used Source to target (STM) mapping document to perform ETL testing for end-to-end flow of data.
• Very good understanding on Data warehouse concepts, end-to-end ETL flow and BI methodologies.
• Used Team Foundation Server (TFS) for defect tracking, updating status of defect and task assign list, uploading test cases and test documents for multiple applications.
• Distributed the reports to the users via Cognos Connection.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Attended daily SCRUM meeting and provide team with test results and performance improvements needed.
• Implemented defect management, automated regression testing, performance testing, requirement review, code review, release management.
• Logged defects for improper requirements and harness issues respectively.
• Use HP Quality Center for defect tracking, fixing the defect and updating the status of the defect.
• Generated Cognos reports using Oracle target view and validating to match user requirements
• Wrote SQL views in schematic layer to test data inbound to reports.

Environment: Team Foundation Server (TFS) 2013, MS SQL Server 2014, Teradata SQL Assistant 14.11, Informatica Power Center 9.1.6, Cognos, SQL, Quick test Pro, Manual Testing, MS Office (Word, Excel, Visio), Pivot tables and charts.

ETL Tester

Confidential - Fort Wayne, IN

Responsibilities:

• Interacted with Business users to gather testing needs and data flow from source to target.
• Involved in test plan, writing test scenarios and executing test cases as per user requirement.
• Validated data using different parameterized techniques and plans to perform analysis.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures, and Macros.
• Developed SQL scripts to validate the data loaded into warehouse and Data Mart tables using Informatica.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools)
• Tested reports developed by Business Objects Universes for both Ad hoc & Canned Reporting users of Business Objects XI.
• Used various checkpoints in the Informatica designer to check the data being transformed.
• Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• Worked on HP ALM to track on defects and updating status of defects on timely manner
• Attending Daily Calls and updating test data and status of the work to management.
• Used Informatica ETL tool to perform ETL testing and validating end-to-end flow of data with Informatica.
• Used STM- Source to target mapping document to understand ETL end to end flow of data in ETL design.
• Worked with offshore team for performing needed testing and analysis as per user requirement.
• Documented test cases and test scenarios for multiple applications from repot generated by business objects (BO) reporting tool.
• Experience in testing Business Report developed in Business Objects XIR2.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business Objects Universes.
• Worked on a Business Intelligence reporting system that was primarily functioning on Oracle Applications OLTP environment with Business Objects for Business Intelligence reporting
• Involved in Smoke testing of application during releases and performed testing.
• Performed User Acceptance testing (UAT) to ensure on end-to-end functionality process.
• Responsible for testing Business Objects universe and universe enhancements.
• Based on the requirements created Functional design documents and Technical design specification documents for transformation and loading purpose.
• Performed Unit testing and Integration testing on the mappings in various schemas.
• Worked with offshore team for performing needed testing and analysis as per user requirement.

Environment: HP Application Lifecycle Management 10.0, Teradata V13.10, Informatica Power center 8, Oracle 10g, SQL Server 8.0 (SSIS, SSRS), QTP, Toad, Microsoft Office 2010, Business Objects (BO)

ETL Tester

Confidential - Plano, TX

Responsibilities:

• Translating client's strategic vision into technical solutions and application identification.
• Used HP Application Lifecycle Management (ALM) for uploading test cases, Data Scenario's and procedure documents for different departments.
• Performed smoke batch end to end to ensure proper data flow from source to target.
• Worked on tracking defects and fixing the defects as needed for multiple applications.
• Performed Ad-hoc testing and regression testing on multiple applications.
• Wrote complex SQL and PL SQL queries for validating Data Stage jobs loading functionalities with available requirement spec and business rules.
• Prepared Test Cases for the mappings developed through the ETL tool Data Stage and executed those Test Cases
• Involved in User acceptance testing UAT and wrote multiple test cases.
• Distributed the reports to the users via Cognos Connection.
• Wrote complex SQL and PL SQL queries for validating Data Stage jobs loading functionalities with available requirement spec and business rules.
• Written SQL scripts to test the mappings and extensively used Cognos for report generation.
• Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Wrote complex SQL Queries to validate data in SQL Server and Teradata SQL Assistant.
• Extensively worked in validating migration data, smoke testing of application during production 'Go - Live'.
• Attended daily SCRUM meeting and provide team with test results and performance improvements needed.
• Writing scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
• Involved in writing complex queries, testing and review sessions.
• Worked with offshore team for performing needed testing and analysis as per user requirement.

Environment: HP ALM, JIRA, Data Stage, Cognos, Oracle 9i, SQL, QTP, Toad, Windows NT/2000, MS Office 2010

ETL Tester

Confidential

Responsibilities:

• Involved in gathering testing needs for ETL migration architecture and end-to-end functionality.
• Involved in Unit Testing and Preparing test cases and also involved in Peer Reviews
• Created tables and views in Oracle as per user requirement for various applications for testing purpose.
• Performed ETL testing using Data stage ETL tool for data coming from different sources in Target Teradata System.
• Worked on writing test scripts and test scenarios for validating end-to-end data and source and target in ETL flow design.
• Used HP ALM to track assigned defects and update the status of defects and check on user stories related to defects.
• Validated Data Stage logic by executing ETL Wrappers and Autosys jobs by using SQL and Unix Shell scripts.
• Tested several Data stage ETL jobs and ran on UNIX for loading purpose and checking the log files
• Worked with ETL group for understanding Data Stage jobs for dimensions and facts
• Prepared various Data Stage jobs on 8.1 Environment.
• Wrote complex SQL queries in Oracle to perform analysis and validation of data as per user requirement.
• Executed Smoke Test at the end to ensure proper functionality of enhanced services.
• Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE.
• Supported the entire Testing Phase of the project by creating and executing manual test cases to support OBIEE.
• Involved in validating the reports layouts in OBIEE based on Report Layout Document.
• Hands on experience using Microsoft Excel database for creating scenarios.
• Attending Daily Calls and updating test data and status of the work to management.
• Attended SCRUM meeting to update status of testing and provided testing results to management for decision-making.
• Involved in Smoke testing, As-hoc testing and UAT testing.
• Wrote multiple tests cases and test scenarios as per user requirement to perform validation of data.

Environment: HP APLM, JIRA, Data Stage, Obiee, Oracle 9i, SQL, QTP, Toad, Windows NT/2000, MS Office 2010