SUMMARY

• Have around 10 +years of IT Experience in ETL Testing (Informatica Power center, Ab intio), Report testing (Cognos, Micro Strategy, and Tableau) and Google Big Query validation.
• Conversant with all phases of Software Testing Life Cycle (STLC), Software Development Life Cycle (SDLC) in Req. gathering, Analysis, Design, Development, Implementation, Testing, Methods like Waterfall, V - Model and AGILE.
• Worked as a Test Lead and delivered the all the assigned tasks with in the given timeframe with the help of team members.
• I have strong expertise in Software quality Assurance (SQA) test strategy preparation.
• Strictly Adheres to Quality Management Office (QMO) practices and Standards.
• Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center .
• Provided weekly status report to the Project Manager and discuss issues related to quality and deadlines.
• Validated Cognos/ Micro strategy/ Tableau Reports by writing complex SQL Queries.
• Expertise in testing Web Services /XML/SOAP and RESTful services using SoapUI tool.
• Tested Cognos reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Drill Maps, and filters.
• As a QA Analyst - Worked on various industry verticals - Banking and Healthcare.
• Having strong knowledge on salesforce application.
• Having strong knowledge on implementing data Quality techniques using Informatica Data Quality.
• Expertise in creating Test Plans, Test Cases, Test Scenarios and Test Strategies, Requirement Traceability Matrix, Defect Management to ensure Quality Assurance and to test all the business requirements.
• Testing Data Warehouse and Expertise in writing complex SQL queries and Google BIG Queries for validating business rules based on various ETL mapping rules in the mapping sheet document.
• Good Knowledge of Data Warehouse Architecture.
• Experience in integration testing of various data sources with Multiple Relational Databases like Oracle, Teradata, DB2, Sybase, SQL Server, Google Big Query and Flat Files.
• Having experience in writing Python Scripts, UNIX shell scripts to automate the data validation process. By using VI and SED editors.
• Actively involved in Component Integration Testing (CIT), User Acceptance Testing (UAT) and Training of the end users. Participated in cross-functional teams to reengineer and improve business processes.
• Solid experience in Black box testing techniques which includes Boundary Value Analysis.
• Extensively worked on defect tracking tool like HP Quality Centre, HP ALM and JIRA.
• Organized Defect Triage meetings and successfully communicated the testing results to Business, development teams and helped them in prioritizing and fixing the defects.
• Having Strong knowledge on Informatica power center and Master data Management.
• Having knowledge of Hadoop, Sqoop, HIVE, PIG, and HBASE.
• Extensive testing ETL experience using Informatica 8.1/9.5/10.0 (Power Center) (Designer, Workflow Manager, Workflow Monitor and Repository Manager).
• Proficient in troubleshooting database issues and long running queries.
• Strong interpersonal skills, ability to interact with individuals at all levels, excellent communication and presentation skills

TECHNICAL SKILLS

ETL/BI Tools: Informatica 8.x/9.x/10.x,Informatica IDQ, Micro strategy, COGNOSOBIEE, SSIS, SSRS, SSAS, Cognos Report Studio, Tableau

RDBMS: Oracle 9i/10g/11g, SQL Server, DB2, Teradata, PL/SQLIBM Netteza, Sybase, Google Big Query, HIVE, HBase

Tools: Toad, SQL Developer, HP LOAD Runner, SOAP UI, Autosys, Putty, Win SCPHP ALM, sqoop

Operating System: Windows XP/7, UNIX AIX

Languages: SQL, PL/SQL, GOOGLE BIG QUERY

Scripting Languages: UNIX, Python, PIG

PROFESSIONAL EXPERIENCE

Confidential, CA

ETL Tester, Report Tester & Team Lead

Responsibilities:

• Created Test Scripts, Test Plans, RTM, Test Scenarios for the AAA NCNU data migration projects based on requirement document.
• Created Scalable, Reusable test cases for the current project.
• Developed SQL queries for querying data against Oracle, SQL Server, Sybase, Google Big Query databases for data verification process.
• Worked as a Test Lead and delivered the all the assigned tasks with in the given timeframe with the help of team members.
• Involved in the Reviewing test cases, Test scenarios and Prepared Test Result documents.
• Prepared Test status Reports and shared with the business stake holders.
• Extensively interacted with developers, Business Analysts and management teams to understand the Project business requirements and ETL design document specifications.
• Participated in regular project status meetings, Daily stand up meetings and QA status meetings.
• Validated the Data Migration in all Levels of Data Movement stages.
• Developed Oracle, SQL Server, Sybase, Google Big Query Structured Query Language (SQL) test scripts. To validate the data in the Prestaging, Staging and Operational tables as per the Requirements provided by the business.
• Having strong knowledge on salesforce application.
• Validated Micro strategy/ Tableau Reports by writing complex SQL Queries.
• I have strong expertise in Software quality Assurance (SQA) test strategy preparation.
• Strictly Adheres to Quality Management Office (QMO) practices and Standards.
• Involved in testing of all the phases of Software Testing Life Cycle.
• Extensively worked with flat files, XML Files and excel sheet data sources.
• Validating the Data as per the mapping sheet document, User requirement document and coordinating the Bug fixes.
• Written UNIX scripts and Python scripts to automate the process.
• Preparation of test closure document with all the required details.
• Extensive SQL querying on Staging, Operational, Data warehouse and Data Marts.
• Validated the Truncate & Load and Delta load mechanism for the required tables.
• Performed the both backend and Front end validations as per the requirement.
• Clearly communicated and documented test results using JIRA and defect resolutions during all phases of testing.

Environment: JIRA, Windows, ORACLE, Teradata, Informatica, Micro strategy, Tableau, SQL Server, Sales force, Autosys, MSOffice (MS word, excel, access, outlook, PowerPoint), Python scripting, Google Big Query & Unix Shell Scripts.

Confidential, Dallas, TX

ETL Tester & Team Lead

Responsibilities:

• Created Test Scripts, Test Plans, RTM, Test Scenarios for the Mosaic data migration project based on requirement document.
• Created Scalable, Reusable test cases for the current project.
• Developed SQL queries for querying data against Oracle database for data verification process.
• Worked as a Test Lead and delivered the all the assigned tasks with in the given timeframe with the help of team members.
• Involved in the Reviewing test cases, Test scenarios and Test Result documents.
• Prepared status Reports and shared with the business stake holders.
• Extensively interacted with developers, Business Analysts and management teams to understand the Project business requirements and ETL design document specifications.
• Participated in regular project status meetings, Daily stand up meetings and QA status meetings.
• Validated the Data Migration in all Levels of Data Movement stages.
• Developed Oracle Structured Query Language (SQL) test scripts. To validate the data in the Prestaging, Staging and Operational tables as per the STTM provided by the business.
• Involved in the testing in pod and Certification QA Environments.
• Extensively worked with flat files and excel sheet data sources.
• Validating the Data as per the STTM mapping sheet document and coordinating the Bug fixes.
• Preparation of test closure document with all the required details.
• Performed the both backend and Front end validations as per the requirement.
• Clearly communicated and documented test results using HP ALM and defect resolutions during all phases of testing.

Environment: HP ALM, JIRA, Windows, ORACLE, Teradata, Ab initio, MSOffice (MS word, excel, access, outlook, PowerPoint) & Unix Shell Scripts.

Confidential, Portland, OR

ETL&BI Tester

Responsibilities:

• Created Test Scripts, Test Plans, RTM, Test Scenarios for Kaiser IDR project based on requirement document.
• Created Scalable, Reusable test cases for the current project.
• Developed Teradata queries for querying data against different tables for data verification process.
• Extensively interacted with developers, Business Analysts and management teams to understand the Project business requirements and ETL design document specifications.
• Participated in regular project status meetings and QA status meetings.
• Developed Oracle Structured Query Language (SQL) test scripts from test procedures and executed those Used SQL queries to retrieve data from tables and to perform back end testing thru SQL server.
• Performed Data validation for Heterogeneous databases with the help of Informatica DVO.
• Worked as a Test Lead and delivered the all the assigned tasks with in the given timeframe with the help of team members.
• Involved in the Reviewing test cases, Test scenarios and Test Result documents.
• Prepared status Reports and shared with the business stake holders.
• I have strong expertise in Software quality Assurance (SQA) test strategy preparation.
• Strictly Adheres to Quality Management Office (QMO) practices and Standards.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases.
• Triggering the Informatica workflows in the QA Environment and validating the Data as per the mapping sheet document and coordinating the Bug fixes.
• Preparation of test closure document with all the required details.
• Extensive SQL querying on Staging, Data warehouse and Data Marts.
• Extensively performed DAY 0 and DAY 1 validations for SCD Type2 implementations.
• Validated Threshold limit validations, Error log file generation, File Archival validation.
• Prepared Requirement Traceability Matrix (RTM) to make sure all the requirements are covered or not.
• Performed data warehouse testing on data loaded on fact and dimensional tables to identify customer segmentation.
• Performed Component Integration Testing (CIT) and integration testing to confirm ETL code integrity.
• Clearly communicated and documented test results using HP ALM and defect resolutions during all phases of testing.

Environment: HP ALM, Windows, Teradata, ORACLE, Informatica Power center 9.5, IBM Netteza, Micro Strategy, Informatica DVO, Autosys, MSOffice (MS word, excel, access, outlook, PowerPoint) & Unix Shell Scripts.

Confidential

ETL &Report Tester

Responsibilities:

• Extensively interacted with developers, Business Analysts and management teams to understand the Project business requirements and ETL design document specifications.
• Created Test Scripts, Test Plans, RTM, Test Scenarios for requirement document.
• Created Test cases for Data Acquisition and Data Delivery and tested the data accuracy for all the transformations.
• Developed SQL Queries using Complex joins such as Inner joins, Left Outer join and Analytical Functions and validated Data warehouse and Data Marts.
• Validated Cognos Reports by writing complex SQL Queries.
• Tested Cognos reports for Report layout, Attributes/Metrics, positions, Totals & Grand Totals, Drilling options, Drill Maps, and filters.
• Tested mappings/Reusable Objects/Transformation/mapplets by using Informatica Power Center.
• Developed Teradata queries for querying data against different tables for data verification process.
• Tested various mappings in Power Center Designer using Aggregate, Expression, Filter, and Sequence Generator & Update Strategy.
• Participated in regular project status meetings and QA status meetings.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• I have strong expertise in Software quality Assurance (SQA) test strategy preparation.
• Strictly Adheres to Quality Management Office (QMO) practices and Standards.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to test the flat files data in the databases.
• Validate the Data by using Informatica DVO from Source to Target table.
• Define the Validation Rules in Data Validation Option (DVO).
• Perform the BIGDATA Testing using HBASE, HIVE, PIG confirms the validation rules for match and merge process.
• Validated the Validation results in Data Validation Option Client.
• Conducted Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
• Triggering the Informatica workflows in the QA Environment and validating the Data as per the mapping sheet document.
• Extensively performed DAY 0 and DAY 1 validations for SCD Type2 implementations.
• Validated Threshold limit validations, Error log file generation, File Archival validation.
• Prepared Requirement Traceability Matrix (RTM) to make sure all the requirements covered or not.
• Performed data warehouse testing on data loaded on fact and dimensional tables.
• Clearly communicated and documented test results and defect resolutions during all phases of testing.
• Preparation of test closure document with all the required details.

Environment: Informatica 9.1/9.5 Cognos, Cognos Report Studio, Oracle 11g,Tera data, HP ALM, HIVE, HBASE, PIG, MS Excel, Toad, UNIX Shell Scrips, Putty, Win SCP, Notepad++, Toad, Windows.

Confidential

ETL Tester

Responsibilities:

• Attended Business Requirements meetings and High Level Design Meetings
• Have closely worked with Business Analysts, Designers to understand and plan for the testing deliverables.
• Prepared RTM, Test Scenarios, Test Scripts.
• Performed Verification, Validation, and Transformations on the Input data (Text files, CSV files) before loading into target database.
• Ran Informatica workflows in QA environment to perform ETL process on the source files.
• Prepared test data as per the requirements for Positive and Negative testing.
• Validated the data generated from the Informatica jobs with the test query prepared.
• Used Unix commands to validate the source and target files in ETL process
• Reviews the Business Requirements documents.
• Perform the BIGDATA Testing using HBASE, HIVE, PIG confirms the validation rules for match and merge process.
• Done Test Case estimations.
• Designed Test Cases for ETL validations(Positive and Negative)
• Prepared test data requirements and with the help of development loaded the production data to test environment.
• Wrote Complex SQL queries to validate the complex Informatica power center mapping requirements.
• Participated in daily defect triage meeting and prioritized the fix of defects
• Prepared Test metrics like test productivity, defect leakage, Test Closure document.

Environment: Informatica 8.5, DB2,Flat files, SSIS, SSAS, SSRS, HIVE, HBASE, PIG, SQOOP, HP QC, MS Excel, UNIX Shell Scripts, Putty, WinSCP, Notepad++, Toad, Windows.

Confidential

ETL Tester

Responsibilities:

• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Interacting with Business Analyst for clarity on requirements.
• Understanding the Source to Target data mapping process.
• Prepared Test Case, Test scripts, Test data and Test Data Strategy Identification.
• Involved in Preparing Process documents like Requirement Traceability Matrix (RTM), Test closure document.
• Following Defect Life cycle through Quality Center.
• Coordinating with development team in tracing errors and tracking it till closures with respect to the test execution done.
• Extensively tested Bulk Load and incremental loads, Daily Load and Delta Loads.
• Wrote complex SQL queries using joins, sub queries and correlated sub queries.
• Performed Metadata, Data completeness, Data Accuracy and Data Quality validations.
• Good working knowledge with XML files as source for Informatica.
• Performed Retesting and Regression testing.
• Involved in defect triage meeting and prioritized the fix of defects.
• Involved in defect analysis and providing more details regarding defect.
• Involved in the preparation of Test closure document.
• Prepared positive and negative test scenarios and tested accordingly.
• Involved in the test data preparation as per the requirement.
• Involved in Retesting and Regression testing.

Environment: Informatica 8.0, SQL, DB2, XML, HP QC, UNIX, Putty, Notepad, Toad, Windows, SQL.