PROFESSIONAL SUMMARY:

• Around 8+ years of IT experience in testing of Data Warehouse (ETL/BI) and Big data applications.
• Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
• Experience in all phases of Software Development life cycle such as Agile, Scrum, Waterfall, RUP
• Expertise in performing all kinds of testing like black box testing, functionality testing, integration testing, regression testing, performance, boundary testing, System testing and UAT testing.
• Expertise in using Quality Center & HP ALM and JIRA for designing, writing, implementing and maintaining the Test Cases, Test Execution, Defect management, Bug Reporting and familiarity with other features of Quality Center and Administration.
• Experience in importing and exporting of data using Sqoop from HDFS to RDBMS and vice versa
• In depth technical understanding of Data Warehousing, Data Validations, OLAP, SQL Server and Oracle
• Knowledge in Business Intelligence tools like SSRS, MicroStrategy, Tableau, Cognos
• Expertise in designing the test scenarios and scripting the test cases in order to test the application
• Experience in testing and writing complex SQL statements to validate the database systems and for backend database testing.
• Expertise in Agile/SCRUM Process, V - Model and Waterfall Model methodologies and extensive work experience on QA process and Approaches
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica, SSIS and Data Stage
• Good working experience in Unix Shell Scripting including different commands like grep, diff, sed, chmod and wc.
• Extensively strong on databases including Oracle, MS SQL Server, Teradata and DB2

TECHNICAL SKILLS:

Languages: SQL, PL/SQL

Databases: Oracle (10g, 11g, 12c), MS SQL Server 2008

Big Data: HDFS, Hive, MapReduce, Pig, SqoopReporting Tools MicroStrategy 10.1, Cognos 11x

Operating Systems: Windows, UNIX, Mainframes

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: HPALM 12.0, Jira

ETL Tools: Informatica 10.2/10.0/9.6 , DataStage, SAS

PROFESSIONAL EXPERIENCE:

Confidential, Rolling Meadows, IL

Tester - ETL/DWH/Hadoop

Responsibilities:

• Worked in an agile environment.
• Performed integration testing of Hadoop packages for ingestion, transformation, and loading of massive structured and unstructured data into benchmark cube.
• Involved in creating hive tables, loading and analyzing data using hive queries.
• Prepared hive queries for testing purposes.
• Create reports for the BI team using Sqoop to export the data into HDFS and Hive.
• Used Informatica Power Center Workflow Manager to run the workflows.
• Performed all aspects of data verification, validation including functional, regression, retesting, system testing, positive and negative testing.
• Attended daily-stand up, sprint planning and retrospective meetings.
• Written SQL statements for various business scenarios.
• Written & Executed test cases based on acceptance criteria.
• Expert in writing SQL scripts in querying SQL Server Management Studio.
• Written Test Cases for ETL to compare Source and Target database systems.
• Interaction with Business/System Analyst team members to understand the project scope and business ask.
• Worked on JIRA as Agile management tool and all testcases and defects are maintained and executed in HPALM
• Performed Data Analysis and data validation including data completeness, Data Transformation and functions, Data Quality.
• Worked on source data coming from Mainframes
• Through testing of SCD1 and SCD2 in dimension tables.
• Tested several ETL jobs for loading purpose and tested incremental/Full load.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables.
• Validated the data in excel spreadsheets to compare the data.
• Internal documents are reviewed in ‘Box’ folders and shared to access it.
• Involved in testing the MicroStrategy reports by writing complex SQL queries.
• Validated SAS reports.

Environment: HDFS, Hive, MapReduce, Pig, Sqoop, Informatica 10.2, MicroStrategy 10.1, SQL, Agile, SQL Server 2008, UNIX, JIRA, Oracle 11g, HP ALM 12.0, Mainframe COBOL copybooks.

Confidential, Boston, MA

ETL/Data Warehouse Tester

Responsibilities:

• Performed all aspects of verification, validation including functional, structural, regression and system testing.
• Extensively tested several reports for data quality, Report testing.
• Worked on agile environment.
• Written several complex SQL statements for various business scenarios
• Expert in writing Complex SQL Scripts in querying SQL Server and Oracle.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Collected requirements and tested several business reports.
• Involved in testing and writing SQL and PL/SQL statements.
• Validated the data of reports by writing SQL queries in ODS.
• Involved in user training sessions and assisting in UAT (User Acceptance Testing).
• Written Test Cases for ETL to compare Source and Target database systems.
• Perform end-to-end UAT testing before handling it off to the user group.
• Involved in reviewing Test cases, Functional Requirements.
• Tested different reports, graphs and pivot reports in tableau dashboards.
• Generating analysis graphs to verify the status of the project as well as the execution count of resources.
• Involved in functional testing and Regression Testing
• Maintaining Traceability matrix of the project.
• Interaction with Business/System Analyst team members to understand the project scope and requirements.

Environment: Informatica 9.0, tableau, SQL, SOAP UI, Agile, UNIX, SQL Server, HP ALM, TOAD, XML

Confidential, Atlanta, GA

ETL/QA/Data Warehouse Tester

Responsibilities:

• Involved in Regression, Functional, Integration, System Testing and User Acceptance Testing.
• Prepared Execution procedure document format to prepare the Test cases based on mapping document.
• Involved in Test plan preparation, preparing daily status reports and defect reports.
• Tested the Reports generated by the BI tools MicroStrategy and validated the data on the Reports
• Observed the Extract, Transform, Load process with DataStage and tested the data load process using the DataStage as ETL tool
• Ensured that the mappings are correct and Conducted data validation testing.
• Worked with business analyst and developers in setting up test data.
• Expert in writing Complex SQL/PLSQL Scripts in querying SQL Server and Oracle.
• Writing complex SQL queries for data validation for verifying the ETL Mapping Rules.
• Using JIRA (workflow manager) for recording Test cases, Test Executions, Bugs.
• Used SQL for Querying the SQL Server database for data validation and data conditioning.
• Used SQL tools to run SQL queries and validate the data loaded in to the target tables.
• Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS.
• Preparing manual test cases and test data for Scenarios.
• Involved in testing the MicroStrategy reports by writing complex SQL queries.
• Experience in creating Unix scripts for file transfer and file manipulation.
• Created and executed Test scripts for system validation and user acceptance testing (UAT).
• Created ETL execution scripts for automating jobs.

Environment: DataStage 8.0, Web server, Jira 7.0, MicroStrategy 9.5, SQL, Agile, SQL Server, TOAD, PL/SQL, Data mover, XML

Confidential, Littleton, CO

ETL QA Tester

Responsibilities:

• Used Informatica to test mappings, transformations and source and target tables.
• Extraction of test data from tables and loading of data into SQL tables.
• Tested -reports, Dashboards and other functionality within the Cognos
• Responsible for Data mapping testing by writing complex SQL Queries
• Experience in creating UNIX scripts for file transfer and file manipulation.
• Validating the data passed to downstream systems.
• Worked with data validation, constraints, source to target row counts.
• Wrote and ran Unix Scripts for batch jobs.
• Responsible for different Data mapping activities from Source systems to Oracle SQL developer.
• Validating Tableau based on business requirements and sharing results with users during UAT.
• Performed regression testing against the various builds of the application Strong in writing SQL queries and makes table queries to profile and analyze the data in MS SQL SERVER.
• Created macros to automate the process of refreshing the data in MS SQL SERVER.
• Worked with Data Extraction, Transformation and Loading (ETL).
• Involved in testing data mapping and conversion in a server-based data warehouse.
• Used Microsoft excel and Word to document the test status reports and the Test Data.
• Used HPALM to track and report system defects.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.

Environment: Informatica, Tableau, HPALM, Agile, SOAP UI 4.5, SQL, SQL Server, PL/SQL, UNIX