PROFESSIONAL SUMMARY:

• Over 10 years of total IT experience in ETL Testing (QA), Data Warehouse Testing.
• Understanding the business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during the review.
• Expertise in Hadoop Big Data Testing (Used HADOOP HIVE HQL NOSQL)
• Good experience in BI Cognos, QlikView, Tableau, SAP BO Reports Testing
• Created SQL/HQL Queries to test the Data in the Data Warehouse table and Data Mart Tables
• Experience in creating functional/technical specifications, data design documents based on the requirements
• Expertise in applying Enterprise Data Warehousing concepts in Healthcare, Banking, and Retail Domains.
• Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate - wide-ETL Solution using Informatica.
• Expertise in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Implemented various test scenarios and test cases based on the HLD, LLD Documents.
• Wrote SQL scripts to Automate the execution process
• Implemented Automation Scripts to validate the Data Marts and Dashboards.
• Experience in Integration, Regression, System Testing, Load Testing, Involved in End to End ETL and BI (Data Warehouse Testing)
• Worked with slowly changing dimension validations Type1, Type2Extensive experience in developing reports using prompts like value prompt and Tree prompts.
• Validated Cognos and QlikView Dashboards
• Used HP QC and ALM for test management life cycle.
• Involved in Efforts estimation for the new projects.
• Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, dimensional modeling and reporting tools, worked with high volume databases with partitioned data.
• Reviewing the business requirements for Data Warehouse ETL process and working with business and requirements team for gaps found during the review. Involved in Team Cross skilling and Training activities

TECHNICAL SKILLS:

Primary Skill category: ETL Testing

Database: Oracle 11G, Big Data, Hadoop, SQL Server, Hive

Secondary skills 2: Tableau, Informatica Power Center 9.5.1, IBM Cognos 10,Qlikview,Qlik SenceProject Acquired skills: Tableau, Informatica 9.5.1, Oracle 11G, TOAD, HP ALM, TOAD

Domains: Healthcare, Insurance, Banking

Trained Skills: IBM Cognos 10, BIG DATA (HIVE)

Linguistic Skills: English,Hindi, Telugu

PROFESSIONAL EXPERIENCE:

Confidential, South San Francisco

ETL SQA Lead

• Coordinating meetings between SQA and Dev Teams.
• Involved Understanding the client business requirements.
• Involved in preparing Test Strategy, developing Test Plan, Detailed Test Cases, writing Test Scripts by decomposing Business Requirements, and developing Test Scenarios to support quality deliverables.
• Involved in to HADOOP Hive Testing (Implemented source and target comparison logic to validate the data)
• Identification of High level scenarios and writing TC’s based on the requirements.
• Involved in creating/Modifying Test Plan and Test Strategy.
• Created SQL/HQL Queries to test the Data in the Data Warehouse table and Data Mart Tables
• Created and executed the test cases for all the tables in the HP ALM tool.
• Extracting the data from flat files, oracle database and processing into Data warehouse.
• Performance tuning the SQL queries
• Involved in Unit Testing, Integration Testing and User Acceptance Testing of the Interface.
• Involved in documenting the modifications to the existing functionalities.
• Involved in to Informatica Development
• Developed various Mappings, Maplets, Reusable transformations and Reusable tasks.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, workflows for the mapping to run daily based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues, Troubleshooting of Informatica Mappings, evaluating current logic for tuning possibilities.
• Responsible for creating production support documentation.
• Involved in Data masking for unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.
• Involved in to Defect triage meetings

Environment: Hadoop, Informatica, Oracle, SQL Developer, Windows, TOAD, SQL

Confidential

ETL SQL Lead

• Involved Understanding the client business requirements.
• Identification of High level scenarios and writing TC’s based on the requirements.
• Involved in creating/Modifying Test Plan and Test Strategy.
• Created SQL Queries to test the Data in the Data Warehouse table and Data Mart Tables
• Created and executed the test cases for all the tables in the HP ALM tool.
• Extracting the data from flat files, oracle database and processing into Data warehouse.
• Performance tuning the SQL queries
• Involved in Unit Testing, Integration Testing and User Acceptance Testing of the Interface.
• Involved in documenting the modifications to the existing functionalities.

Environment: Informatica, Oracle, SQL Developer, Windows, Erwin, TOAD

Confidential

ETL Test Lead

• Developed the test plans and scripts based on technical specifications, design documents and business rules.
• Involved in Developing/Modifying test plan and test strategy and also writing SQL queries to test the Warehousing tables
• Worked and written SQL queries to test various DW and DM tables and QlikView dashboards.
• Communicating, tracking and reporting of defects identified during testing.
• Participating in regular project status and QA status meetings.
• Used HP QC for Defect life cycle management.

Environment: Tableau, Oracle, SQL Developer, Windows, SQL*Plus

Confidential

SQA Lead

• Understanding the FS and preparation of Test planning and Test strategy.
• Building the Test Scenarios
• Building the Test Cases
• Involved in Client Calls
• Involved in Weekly and Monthly status meetings.
• Updated and Executed TC’s in the HP ALM tool.

Environment: Informatica PowerCenter, Oracle, SQL Developer, Windows, TOAD, SQL*Plus, SQL*Loader

Confidential

ETL Tester

• Involved Understanding the client business requirements.
• Involved in to HADOOP Hive Testing (Implemented source and target comparison logic to validate the data)
• Identification of High level scenarios and writing TC’s based on the requirements.
• Involved in creating/Modifying Test Plan and Test Strategy.
• Created SQL/HQL Queries to test the Data in the Data Warehouse table and Data Mart Tables
• Created and executed the test cases for all the tables in the HP ALM tool.
• Extracting the data from flat files, oracle database and processing into Data warehouse.
• Performance tuning the SQL queries
• Involved in Unit Testing, Integration Testing and User Acceptance Testing of the Interface.
• Involved in documenting the modifications to the existing functionalities.
• Involved in to Informatica Development
• Developed various Mappings, Maplets, Reusable transformations and Reusable tasks.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, workflows for the mapping to run daily based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues, Troubleshooting of Informatica Mappings, evaluating current logic for tuning possibilities.
• Responsible for creating production support documentation.
• Involved in Data masking for unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.
• Involved in to Defect triage meetings

Environment: Tableau, Oracle, SQL Developer, Windows, TOAD

Confidential

ETL Tester

• Involved Understanding the client business requirements.
• Extracting the data from flat files, oracle database and processing into Data warehouse.
• Performance tuning the SQL queries
• Involved in Unit Testing, Integration Testing and User Acceptance Testing of the Interface.
• Involved in documenting the modifications to the existing functionalities.
• Involved in creating/Modifying Test Plan and Test Strategy.
• Created SQL/HQL Queries to test the Data in the Data Warehouse table and Data Mart Tables
• Created and executed the test cases for all the tables in the HP ALM tool.
• Extracting the data from flat files, oracle database and processing into Data warehouse.
• Performance tuning the SQL queries
• Involved in Unit Testing, Integration Testing and User Acceptance Testing of the Interface.
• Involved in documenting the modifications to the existing functionalities.
• Involved in to Informatica Development
• Developed various Mappings, Maplets, Reusable transformations and Reusable tasks.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, workflows for the mapping to run daily based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Involved in to Defect triage meetings.

Environment: Tableau, Informatica PowerCenter 9.x, Oracle, SQL Developer, Windows, TOAD, SQL*Plus, SQL*Loader

Confidential

ETL QA Tester

• Involved Understanding the client business requirements.
• Involved in Unit Testing, Integration Testing and User Acceptance Testing of the Interface.
• Involved in documenting the modifications to the existing functionalities.
• Developed various Mappings, Maplets, Reusable transformations and Reusable tasks.
• Analysis of Business requirements & Design Specification Document to determine the functionality of the ETL Processes.
• Participated and Performed System Integration testing by developing Sub graphs and Integrated with Extraction and Load Graphs.
• Communicated and Discussed with Business analysts and Developers about the status of each Data Quality Issues
• Executed UNIX Shell Scripts for Batch Job Execution.
• Written several UNIX scripts for running test loads for regression testing purpose.
• Ran SQL Statements manually to execute Record Counts on Each Table Loaded into System and Compared with Source Table.
• Tested Business Objects reports and Web Intelligence reports.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes
• Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
• Tracked and reported the bugs with Quality center.
• Involved in team weekly and by monthly status meetings.
• Involved in to Defect triage meetings.

Environment: Tableau, Informatica PowerCenter 9.x, Oracle, SQL Developer, Windows, Informatica Autosys job scheduler, Erwin, TOAD, SQL*Plus, SQL*Loader

Confidential

ETL Tester

• Involved Understanding the client business requirements.
• Identification of High level scenarios and writing TC’s based on the requirements.
• Involved in creating/Modifying Test Plan and Test Strategy.
• Created and executed the test cases for all the tables in the HP ALM tool.
• Extracting the data from flat files, oracle database and processing into Data warehouse.
• Performance tuning the SQL queries
• Involved in Unit Testing, Integration Testing and User Acceptance Testing of the Interface.
• Involved in documenting the modifications to the existing functionalities.
• Involved in to Informatica Development
• Developed various Mappings, Maplets, Reusable transformations and Reusable tasks.
• Created Connected, Unconnected and Dynamic Lookup transformations for better performance.
• Created sessions, workflows for the mapping to run daily based on the business requirements.
• Extensively used Parameter files, mapping variables in the process of development of the mappings for all the dimension tables.
• Worked on handling performance issues, Troubleshooting of Informatica Mappings, evaluating current logic for tuning possibilities.
• Responsible for creating production support documentation.
• Involved in Data masking for unit testing and fixing the bugs identified, provided data to the reporting team for their daily, weekly, monthly and quarterly reports.
• Involved in team weekly and by monthly status meetings.
• Involved in to Defect triage meetings.

Environment: Tableau, Oracle, SQL Developer, Windows, Informatica Power exchange

Confidential

ETL Developer

• Validated data between source and target is correct.
• Written SQL Scripts to validate the data.
• Implemented Automation technique to validate all the columns data
• Prepared Test scenarios and Test cases executed TC’s in the HP ALM Tool.
• Involved in preparation of Test Planning

Environment: Informatica, Oracle, SQL Developer, Windows, TOAD, SQL*Plus, SQL*Loader

Confidential

ETL Tester

• Involved in Business analysis and requirements gathering.
• Written the SQL scripts to validate ETLs developed by Ab Initio.
• Validated Ab Initio ETL mappings and transformations like joiner, update strategy and lookup.
• Involved in conducting Functionality, Negative/Positive, and Security testing manually.
• Analyzed the data using Ab Initio Data Profiler giving Statics of the data like null values, maximum, minimum and average values.
• Utilize various AbInitio components like Lookup, Join, Rollup and Reformat to process data.
• Experience in preparing the traceability matrix, test scenarios and test cases.
• Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics,
• Defect Report and requirement traceability using Quality Center.
• Analyzed test cases for automation and created scripts for regression testing using QTP Automated Test cases for the purpose of regression testing.
• Reviewed the test cases written based on the Change Request document.
• Tested data migration to ensure that integrity of data was not compromised.
• Experienced in writing complex SQL queries for testing data in oracle targets.
• Worked on issues with migration from development to testing.
• Prepared test data to validate ETL rules wherever necessary.
• Accessed source files from UNIX environment.
• QTP/UFT was used to generate automated Test scripts for functionality and GUI Testing.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
• Written several complex SQL queries for validating Business Objects Reports.
• Write SQL queries to validate Drilldown and Cross-Tab reports.
• Validated reports cosmetic like color, size in Business Objects reports.
• Reviewed the test cases written based on the Change Request document.
• Preparation of System Test Results after Test case execution.
• Developed SQL* loader scripts to load the data into the custom table.

Environment: Informatica, Oracle, SQL Developer, TOAD