SUMMARY:

• Having 8 years of Experience in Software Testing and testing ETL, Data warehouse, Database and web applications
• Involved in Functionality, Integration, System, Application and Regression Testing.
• Experienced in Test plan, Estimation, project POC preparation and Test case designing.
• Having very good experience in handling testing team.
• Expert in writing SQL, working on Data Comparison, Data Integration and Data Migration.
• Extensive experience in extraction, transformation and loading of data directly from different heterogeneous source systems like Oracle 9i/10g, Flat files, Excel, and Teradata
• Familiarity with BI lifecycle, Dimensional modeling, ETL concepts, OLAP and Reporting Services
• Strong skills of Informatica Power center - Designer, Workflow manager, Workflow monitor, mapplet designer, mapping designer, warehouse designer. Also had a Good experience in Informatica upgrade project.
• Strong skills include Siebel Tools 7.5 and 8.0, Siebel Applications.
• Good experience in various transformations such as source qualifier, expression, joiner, normalizer, router, aggregator, lookup and update strategy.
• Experience on Modifying Siebel Application by Customizing business objects, Developing scripts and Designing Business Process using Siebel tools based on requirements.

TECHNICAL SKILLS:

Op e r ati ng Sy s t em: Windows 7/8, UNIX

Envi r o nm e nt: Informatica, Siebel, Siebel tools 7.x, iRemedy, Confidential

Databa se: Oracle, Teradata, SQL server

La ngu ag es: C, Java, SQL, HTML

Oth er: Selenium (WebDriver, RC), SOAPUI

IDE Framework: Eclipse IDE

WORK EXPERIENCE:

Selenium QA Tester

Confidential, Los Angeles, CA

Responsibilities:

• Involved in Development of Application Specific Methods in Framework.
• Analysis of the Test Cases.
• Logging defects in defect tracking tool and follow up.
• Communication with QA’s of client for clarification of test cases.
• Scripting of the Test Scripts.
• Debugging and Batch Execution.
• Review of the Test Scripts.
• Preparation Weekly Status and Project Management reports.
• Coordinated with the developers to resolve defects.
• Involved in documentation in order to maintain and automate scripts for future enhancements.

ETL / SQL Tester

Confidential, New York, NJ

Responsibilities:

• Design and Development of QA documentation like Test Cases and Test scenarios from business and functional requirements
• Used Quality Centre as the test management tool for the maintenance of the test cases and JIRA to track the defects.
• Performed SQL validation to verify the data extracts and record counts in the database tables by writing complex SQL minus queries
• Involved in the preparation of SQL queries based on business requirements and testing needs
• Executed SQL Queries for testing integrity of data in database (Backend Testing).
• Coordinated with the Developers regarding the Defects raised and Retested them against the application.

QA/ ETL Tester

Confidential

Responsibilities:

• Understand functional specifications
• Understanding the testing scope
• Design and Executed functional test cases on QA environment
• Prepared SQL scripts to validate data from source files to staging and staging to target.
• Perform mandatory fields check and user re-usability validation
• Creation of test data - Create the new data in the application and validate that reports are displaying the newly created data
• Used Quality Centre as the test management tool for the maintenance of the test cases and to track the defects.

QA/ETL Tester

Confidential

Responsibilities:

• Responsible for getting, understanding the business specification, preparing technical Specification
• Worked with Data Analysts to implement Informatica Mappings and Workflows
• Understanding the Data Mapping between source and target database
• Developing SQL queries to extract, manipulate, and/or calculate information to fulfil data and reporting requirements including identifying the tables and columns from which data is extracted
• Design the baseline test script based on the Mapping requirements
• Executed Data migration test cases on QA environment
• Validate the data migration (ETL Process)
• Executed data Quality checks on the data migrated in QA environment.
• Logging defects in Quality Centre, categorizing them on different levels of severity

QA/ETL Tester

Confidential

Responsibilities:

• Understanding the Business- functional and technical requirements.
• Understanding the testing scope
• Creation of Test Strategy document.
• Executed functional test cases on QA environment
• Running the Jobs/Workflows for ETL process
• Executed data Quality checks on the data migrated in QA environment.
• Executed performance test cases & checked the ETL performance.
• Creation of test data - Identify the test cases which require test data, work with the business and APL to get a sample representation of the test data to test all functionalities
• Logging defects in Quality Centre, categorizing them on different levels of severity

QA/ETL Tester

Confidential

Responsibilities:

• Requirement analysis and Informatica upgrade test plan preparation.
• Understanding mappings and identification of dependencies between workflows.
• ETL build deployment in QA environment.
• Tested new mappings and updating old mappings according to changes in Business logic. Tested Mapping by extracting data from various sources involving flat files and relational tables.
• Testing Transformations like Lookup, Update Strategy, Aggregator, Router, Stored Procedure, Expression and Joiner Using Informatica. Experience of testing Slowly Changing Dimensions to maintain the complete History.
• Created new mappings and updating old mappings according to changes in Business logic.
• Extracting data from various sources involving flat files and relational tables.
• Experience of handling Slowly Changing Dimensions to maintain the complete History.
• Tested all the mappings according to the design document and mapping,
• Based on specs provided and performed unit testing.

QA/ETL Tester

Confidential

Responsibilities:

• Knowledge gathering from onshore & Working at onshore for initial testing deliverables
• Prepared Test Cases based on the requirements.
• Involved in creating queries to pull out the relevant data from the database
• Execution of test cases
• Automation activity revolving around comparing the DBs post migration.
• Preparing and Sending DSRs.

QA Tester

Confidential

Responsibilities:

• Involved in functional study of the application
• Running the Jobs/Workflows for ETL process
• Prepared sql queries to verify the data verifying the ETL data in target database
• Designed and Peer reviewed the test cases and prepared test data
• Column Mapping between source and target databases
• Interactions with BA & Dev teams to resolve the issues.
• Reporting daily testing status report
• Executed Test cases
• Performance tuning for Informatica mappings and sessions
• Identified Test cases for Regression testing
• Defect Analysing and Reporting in QC

QA Tester

Confidential

Responsibilities:

• Understanding the Business requirement
• Running the Jobs/Workflows for ETL process
• Prepared and ran sql queries to verify DIMENSIONAL and FACT tables to have correct computed values.
• Verifying the data in target database
• Reporting daily testing status report
• Executed Test cases & Defect reporting in QC
• Identified Test cases for Regression testing

QA Tester

Confidential

Responsibilities:

• Gathered requirements
• Design of the project (application)
• Lead the team and development (coding) the Java module
• Lead the PL/SQL team member to achieve what was required
• Involved in testing
• Deployment and production support

QA Tester

Confidential

Responsibilities:

• Co-Ordinate with Onsite team to on daily basis to discuss the Change Request and Progress.
• Understand Business Requirements and Prepare Low Level Design.
• Involved in development of Siebel Application and Unit testing the Developed code.
• Interaction with client on progress of Failed Orders and setting future goals.
• Was involved in performing Confidential for orders failing in production, interacting with team of technical architects and proposed solutions, aligned with the client requirements
• Involved in Production support for Critical issue and Deployment Tasks.