SUMMARY

• ETL tester with 9 years of industry experience specialize in manual and automated testing, ETL tests / Data Warehouse testing, UAT testing, Regression tests, GUI testing and have strong knowledge of SDLC and STLC. Extensive experience in writing test scenarios, test cases, test scripts, test plans and hands on experience with ETL tools Informatica, Teradata, IBM Ascential Datastage, IBM Infosphere SQW and Reporting tools like IBM Cognos, SAP BO and SAS with across RDBMS’s like Oracle, SQL Server, IBM DB2 and Netezza
• Expertise in querying and testing RDBMS such as Oracle, MSSQL Server using SQL, PL/SQL for data integrity.
• Ability to interact with developers and Business Analyst regarding testing status, defects and change tracking using Quality Centre and Clear Quest.
• Experience in developing, reviewing and executing Test Strategy, Test plans, Test scenarios and Test Cases/ Scripts
• Experience in manual testing process and in creating automation environment using Quick Test Pro (QTP), Load Runner, Win Runner, Test Director, and Quality Center.
• Hands on experience with source to target mapping in enterprise data warehouse environment.
• Experience in ETL Tools Informatica, Datastage, IBM Infosphere SQW, Teradata, OLAP Tools, Database Testing and UNIX
• Extensive experience in testing Informatica Workflows and sessions using Informatica Work flow manager
• Experience in testing Datstage jobs, sequences using Datastage Designer, Datastage Director
• Experience in Testing Teradata scripts like FastLoad, MultiLoad, Fast Export and Bteq Scripts
• Experience in Testing IBM Infosphere SQW tool Data Flows, Sub processes and Control flows
• Hands on experience with strong SQL knowledge.
• Created ETL test data for all ETL mapping rules to test the functionality of the Informatica graphs.
• Extensively involved in preparing Master Test Plan, Estimations and Test Result and Summary reports
• Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
• Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target D/W.
• Familiarity and experience in the work environment consisting Stakeholders, Subject Matter Experts, Database modelers, Database developers and Database Administration.
• Experience in Reports testing in Crystal Reports XI Environment.
• Having experience on BI reporting services - COGNOS
• Hands-on experience and strong understanding of Software Development Life Cycle (SDLC) and Software Testing Life Cycle (STLC).
• Good experience of Quality Assurance methodologies like Waterfall, V-Model, Agile, Scrum, RAD, TDD.
• Experience in creating Traceability Matrix to ensure comprehensive test coverage of requirements.

TECHNICAL SKILLS

Data Warehouse ETL tools: Informatica, Teradata, Ascential Datastage, IBM Infosphere SQW

Reporting tools: SAP Business Objects, IBM Cognos, SAS

Database: Teradata, IBM DB2, SQL Server 2012/2008, Oracle 11g. 10g, 9i, MySQL

Methodologies: WaWaterfall, Agile and Scrum

Operating Systems: UNUNIX, LINUX, Windows - 7, Vista, XP, NT, 2003, 2000

MS SUITE: MS Office (Word, Excel, PowerPoint, Outlook), MS Visio, MS Project

PROFESSIONAL EXPERIENCE

Confidential, Bloomington, IL

Sr ETL Tester

Responsibilities:

• Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
• Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
• Tested various Reusable ETL Transformations which facilitate Daily, Weekly & Monthly Loading of Data.
• Tested the performance bottle necks at sources, targets, mappings, and sessions and employed required measures.
• Used Toad and SQL Plus for testing execution of ETL Processes' PL/SQL procedures, packages for business rules.
• Tested Triggers which were enforcing Integrity constraints, stored procedures for complex business logic complementing the Informatica sessions.
• Created Integrated summary data from multiple Oracle tables to represent the business perspective of the top management executives
• Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
• Formulate methods to perform Positive and Negative testing against requirements.
• Conducted Smoke testing, Functional testing, Regression testing, Integration testing, User Acceptance Testing (UAT) and Data validation testing.
• Used Agile testing methodology for achieving deadlines in UAT.
• Developed automated Test scripts using QTP to perform Functional and Regression testing.
• Executed and managed test cases and reported bugs in Quality Center.
• Performed Verification, Validation, and Transformations on the Input data (Text files, XML files) before loading into target database.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
• Validated data in between source and target after running Mappings by the Informatica developer team.
• Developed SQL queries to check the database automatically and checking the data integrity in accordance with business standards of the company.
• Used TOAD for SQL Server to write SQL queries for validating constraints, indexes.
• Responsible to send the Data Warehouse Quality report to the QA manger on weekly basis for Caliber data mart.
• Hands on experience in collecting several metrics and come up with corrective measure to be presented to senior management.
• Hands on work experience working with offsite team model; coordinate my own efforts with team members in the off- site team.
• Participated in User Acceptance testing (UAT) and involved in UA test cases, Executed test cases, Documenting

Environment: SQL server 2008, UNIX, Informatica, SAP BO, Windows 2008, TFS, TOAD

Confidential, Dallas, TX

Sr. ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Involved in ETL process testing using Informatica ETL tool.
• Test Case Execution and Adhoc testing
• Performed Integration, End-to-End, system testing
• Involving in Functional Testing & Regression Testing
• Developing Automated Test Scripts to perform Functional Testing, Performance Testing, Integration Testing, Stress Testing, System Testing, User Acceptance Testing, Regression Testing and Volume testing of the application using Load Runner
• Involving in writing SQL queries and Database Checkpoints to verify data quality and calculations, reviews
• Performed data validation testing writing SQL queries.
• Wrote complex queries in Teradata SQL assistant to check the data from Source and Target.
• Used Teradata utilities (MLOAD & FLOAD) to load the source files in to test region. And did the querying on the same data.
• Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
• Working on Quality Center for creating and documenting Test Plans and Test Cases and register the expected results
• Experience assessing testing processes, creating and implementing testing strategies in UAT phase.
• Using HP Quality Center for storing, maintaining the test repository, bug tracking and reporting
• Preparing documentation for some of the recurring defects and resolutions and business comments for those defects
• Developed UNIX scripts to validate the flat files and to automate the manual test cases.
• Developing Test Matrix to give a better view of testing.

Environment: Informatica, Teradata, SQL, DB2, Oracle, HP Quality Center, Rational Clear Case, Rational Clear Quest, Remedy, Microsoft Office, Internet Explorer7.0, WindowsNT4.0/2000, HP/Unix. creehan

Confidential, NA

ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Created some macros in Teradata to load the test data in to Target tables.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Tested Business Objects reports and cross verifying with Staging data by writing the SQL queries on aggregated fields.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: Informatica, Teradata, SQL, DB2, Oracle, SAP BO, HP Quality Center, Rational Clear Case, Rational Clear Quest

Confidential

ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Datastage server jobs, sequences using Datastage Designer, Datastage Director to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Datastage Jobs, Sequences, Variables, Parameters to extract only the additional data added during that period.
• Extensively tested IBM Infosphere SQW tool Data flows, sub processes, Control flows.
• Wrote complex queries to compare the counts and data from source to target.
• Tested Cognos reports and cross verifying with Staging data by writing the SQL queries on aggregated fields.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created, maintained and updated regression suites upon receiving new build.
• Modifying and executing test scripts for web based environment-using Quality Center.
• Extensively used Load Runner for generating the automated test scripts.
• Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: Datastage, IBM Infosphere SQW, SQL, DB2, Oracle, IBM Cognos, HP Quality Center

Confidential

ETL Tester

Responsibilities:

• Responsible for creating complete test cases, test plans, test data, and reporting status ensuring accurate coverage of requirements and business processes.
• Analyzing requirements and creating and executing test cases
• Performing manual testing by performing the operations mentioned in the design steps. Compared the expected results with the actual outcome and recorded the results.
• Working with the Development team for process improvement and release planning
• Analyzed application data using the SQL to identify the ETL processes
• Modifying and creating SQL Queries and stored procedures for quality assurance and analysis.
• Worked with data analysts to implement Informatica mappings and workflows, shell scripts and stored procedures to meet business requirements.
• Performing backend testing of the DB by writing PL/SQL queries to test the integrity of the application and Oracle databases.
• Wrote and modified SQL validation scripts, and writing scripts in SQL to validate the outputs.
• Extensively worked on Mapping Variables, Mapping Parameters, Workflow Variables and Session Parameters to extract only the additional data added during that period.
• Wrote complex queries to compare the counts and data from source to target.
• Formulating the QA plan for black box testing of the application including Functional, Regression, Integration, Systems and User Acceptance Testing.
• Tested Business Objects reports and cross verifying with Staging data by writing the SQL queries on aggregated fields.
• Performing database testing to verify backend database transactions.
• Wrote complex queries in Teradata SQL assistant to analyze the data
• Coordinating user acceptance testing activities for business groups and IT.
• Involving in communication between UAT team members, business leaders, and IT.
• Participates in application release planning and status sessions.
• Used Agile testing methodology for achieving deadlines in UAT testing.
• Working on conversion of manual tests into automated test scripts
• Created and executed goal oriented and manual scenarios using Load Runner Controller.
• Creating traceability relationship between requirements in the same module and also between different modules.
• Extensively used Quality Center for documenting, organizing and tracking requirements.
• Involving in formulating the test plan, procedures and Wrote test cases.

Environment: Informatica, SQL, DB2, Oracle, SAP BO, HP Quality Center.