SUMMARY

• Over all 8 years of experience in the IT Industry, ETL Testing experience in Data Warehouse Applications and OBIEE testing.
• Complete working knowledge of SDLC and STLC lifecycle models in Agile and Waterfall methodologies.
• Skilled professional experience in Design of Test Plan, Test Scenarios, and Test cases and test documents and executing the Test cases
• Professional experience in Unit testing, Integration, Functional, Regression testing.
• Professional experience working in UNIX environments, writing SQL and DB validations. Experience in ETL testing for Data completeness and Data accuracy and User Acceptance testing.
• Having good knowledge in DataWarehouse concepts, ETL & OLAP Testing process
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
• Strong experience in testing Banking, Insurance applications
• Motivated team player with excelent inter - personal skills
• Proficient problem-solver in envisioning business and technical perspectives and develop workable solutions.
• Demonstrated ability to succeed and learn quickly in challenging environment.

TECHNICAL SKILLS

Project Management Tools: Version One

SQL and PLSQL Tools: SQL Server Management, Oracle SQL Developer 3.0.4, Toad,SQL Assistent

Database: -SQL Server 2008, Oracle 10g & 11g,DB2,Teradata

Languages: C, SQL, VB Script,PL/SQL

UNIX Tools: Putty, Cygwin, MS Tools MS Office Suite

Operating Systems: Windows, Linux, Unix

PROFESSIONAL EXPERIENCE

Confidential, TX

ETL Tester

Environment: Oracle, DB2, Informatica, Autosys, UNIX

Responsibilities:

• Data Loads from Source to target through ETL Tool Informatica, and Autosys cheduler tool.
• Data Validations includes File Validations, Table Validations, DDL Validations in Database and Unix
• Carried out Test Execution in different cycles of Integration, System, Sanity
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Strong in writing complex SQL queries to profile and analyze the data.
• Used SQL queries & Join operations to Test database tables.
• Executed the developed Test Cases and Test Plans and also coordinate with the development team to run the workflows if needed and write the SQL scripts to test the test cases.
• Involved in ETL Mapping Design and Performance tuning to Load mapping process.
• Capturing results
• Preparation and Execution of Test Plans, Test Cases for the mappings developed through the ETL Informatica tool in the QA environment
• Developed advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• IST and UAT Sign off handling.
• Worked on defect reporting
• Participated in offshore calls on daily development activities and coordinate with the developers and QA in there day to day testing effort

Confidential, TX

ETL Tester

Environment: HP Quality Center, Database - DB2

Responsibilities:

• Worked on testing Datamarts, eCoupon and IVR and some parts of TDM
• Developed test cases in HP Quality center and associated them with Test Plan and Test set for traceability and progress.
• Setup test data before each execution and data cleansing.
• SQL queries used to validate source data versus data in the data warehouse including identification of duplicate records
• Writing QTP scripts for Database validations and saving results and same to be used for later rounds of comparison with new builds.
• Carried out Test Execution in different cycles of Smoke, System, Regression and Re-Testing
• Designed testing approach for ETL process for Sales Data Mart and Inventory data mart and ensure consistent and effective communication among all parties.
• Handled Test design reviews prepared by offshore, Supporting with critical path SQL queries.
• Worked on defect reporting and represented testing team in defect triage meetings.
• Participate in root cause analysis of defects and preparing processes to reduce the impact going forward.
• Escalating issues to Test Manager as appropriate and needed for quicker resolution
• Raise requests and coordinate activities with external groups as required for test environment.
• Sending daily, weekly status report to the management
• Followed continuous integration model for repeated testing for every automatic build performed by the build server.
• Participated in daily scrum meetings to update and discuss issues and resolution and give status updates
• Participated in offshore calls on daily development activities and coordinate with the developers and QA in there day to day testing efforts.

Confidential, RI

ETL Tester

Environment: DB2, Flatfiles, Informatica, Control-M, UNIX

Responsibilities:

• Involved in gathering requirements and analysis for applications.
• Developed Test Plans, Test Cases, and Test Scripts for UAT test scripts.
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, and UAT and Regression testing.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Responsibilities include acceptance testing, functional testing, Integration testing, System testing, performance testing.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling.
• Execute batch processing and verify the jobs status and data in database tables

Confidential

ETL Tester

Environment: INFORMATICA, Oracle 11g, HP Quality Center, TERADATA

Responsibilities:

• Planning QA Test cycles for all the modules in project
• Generated test plans and test lab setup in HP Quality center
• Write and modify several application specific Config scripts in UNIX in order to pass the Environment variables
• Using Teradata SQL Assistant (for running SQL queries), we verified our data
• Uploaded detailed level test cases from Microsoft Excel to HP Quality center
• Logged and tracked defects to closure in HP Quality Center
• Generated reports in HP Quality Center and tracked daily defect status reports
• Identified and created test data for all the modules involved
• Created SQL queries to verify the Test Results using Toad
• Check the status of source and target tables in the specified database, used in the Informatica 9.0 by running SQL queries
• Conducted defect review meetings
• Conducted domain knowledge transfer sessions
• Prepared knowledge base documents for the projects
• Analyzed and worked on the trouble tickets (TT) raised
• Involved in gathering requirements and analysis for applications.
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Created Test Cases in Quality Center and RTM and mapped Test Cases to Requirements in Req Pro.
• Developed Tractability Matrix and Test Coverage reports.
• Managed and conducted System testing, Integration testing, Functional testing, UAT and Regression testing.
• Used the Informatica Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into data warehouse database.
• Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
• Develop parameter driven ETL process to map source systems to target data warehouse with Informatica complete source system profiling

Confidential

ETL Tester

Environment: INFORMATICA, OBIEE, Oracle 11g and HP Quality Center

Responsibilities:

• Effort Estimation of the new project and CRs
• Creating and Testing the Ad-hoc reports.
• Create the test cases based on the test plan and TDD for the reports and ETL.
• Update the project status to the onsite co-coordinator on daily basis.
• Prepare the customized complex SQL queries to validate the reports.
• Test the ETL (System and Functional Testing)
• Identify the complete test scenario for report testing and ETL testing.
• Review the test strategy, test plan, TDD and test script for the project
• Handling the report/ETL testing team with a team size of 5.
• . Review the offshore clarifications/deliverables before being sent to onsite.
• Assigning work on the daily basis to the team members.
• Compared the actual result with expected results. Validated the data by reverse engineering methodology i.e. backward navigation from target to source
• Checked the reports for any naming inconsistencies and to improve user readability
• Worked on OBIEE Add-Inns for MS Office applications Excel and PowerPoint
• Unit, integration and system testing for all components in OBIEE. Test cases have been prepared and documented the results
• Involved in validating the reports layouts in OBIEE based on Report Layout Document
• Creation and execution of test cases on Oracle Reports and OBIEE
• Created and tested Validation of reports in OBIEE
• Performed backend database testing by writing SQL scripts to verify data integrity
• Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules
• Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle
• Involved in all testing phases: Unit Testing, System Testing, Regression Testing, Integration Testing, and Quality Assurance Testing
• Assisted in creating test data and test cases and execute function system tests as needed
• Tested the application by writing SQL Queries and creating pivot views as to perform back-end testing
• Review the SQL scripts created by the team members.
• Wrote the SQL queries on data staging tables and data warehouse tables to validate the data results
• Reviewed Informatica mappings and test cases before delivering to Client
• Extensively used Informatica power center for extraction, transformation and loading process
• Write SQL queries to validate that actual test results match with expected results