SUMMARY

• Having 8 years of experience in Software Quality Assurance and Testing of Stand Alone, Client Server, Web Based applications, Data Warehousing, BI andETLTesting.
• Hands on experience Testing using Apache Hadoop ecosystems including Hadoop, HIVE, PIG, SQOOP and Spark.
• Extensive experience in Data Warehouse applications testing using Informatica Power Center on multiple platforms.
• Analyzed the Data warehouse Hadoop Bigdata ETL design documents to understand the logic.
• Created test cases and test procedures for various stages of the Bigdata ETL process including source to extract, source to staging and staging to target using Hadoop.
• Well versed with various types Software Development methodologies - Waterfall, Agile, RUP, and Iterative.
• Extensive experience in reviewing Business Requirement Documents, Software Requirement Documents and preparing Test Cases, Test scripts and Execution.
• Experienced in SQL Server 2008/2012 Business Intelligence Tools using SQL Server Reporting Service (SSRS), SQL Server Analysis Service (SSAS) and SQL Server Integration Service (SSIS).
• Tested the created SSIS packages to transfer data from various sources like Oracle, Db2, MS Access, Excel, Flat files
• Tested Complex ETL SSIS Packages and Sessions based on business user requirements and business rules to load data from different source.
• Extensive experience in testing packages using SSIS to verify data completeness, data transformation, data quality, integration testing, UAT & regression testing.
• Experienced in DW projects ETL testing against DW testing with Informatica, Ab Initio and data stage tools.
• Extensive experience in Test Data Management, creating test data suite, tracking the results and using for regression testing.
• Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center DVO, DataStage, Ab Initio and SSIS ETL tools.
• Experience with Creating test plan, test cases and executed test cases and reported defects using in HP QC/ALM.
• Proficient understanding of working with ETL Automation Tools like DVO and Query Surge.
• Extensive experience of manual and automated testing of application and use of HP Quality Center, HP Quick Test Pro, Test Director.QTP.
• Good Knowledge on Business intelligence, OLAP, Dimensional modeling, Star and Snowflake schema, extraction, transformation and loading (ETL) process.
• Involved in fine tuning SQL overrides for performance Enhancements.
• Ability to develop complicated SQL script for Data validation testing by running SQL script, procedures.
• Participated in all aspects of SDLC; build and execute test suite using Microsoft Test Manager (MTM)
• Proficient in SQL, Shell Scripting and PL/SQL coding and experience in Performance Tuning of SQL and Stored Procedures.
• Hands on experience in Performance Tuning of mappings, identifying and resolving performance bottlenecks in various levels like sources, targets, mappings and sessions.
• Having excellent knowledge in Unit Testing, System testing, Integration, Regression, End to End Testing.
• Having knowledge in Doing Estimation and Preparing Schedule for Different phases of Test cycle.
• Excellent knowledge in preparing Test case plans and RTM.
• Experience in preparingTest Strategy, developingTest Plan, Detailed Test Cases, writingTest Scriptsby decomposing Business Requirements, and developingTest Scenariosto support quality deliverables.
• Experience in Black box testing with a complete QA cycle - from testing, defect logging and verification of fixed bugs.
• Extensive experience in Functional testing, Integration/System testing, Regression testing and User Acceptance testing.

TECHNICAL SKILLS

Data Warehousing: Informatica 9.5.1/9.1/8.6.1/8.1/7.1/6/5.1.1/1.75 , Data Stage 8.x,Ab initio, Query surge tool

Reporting Tools: OBIEE, Cognos 8.0 Suite, Business Object XI 3.1, Crystal Reports, SSAS, SSRS, MicroStrategy 8.x, Alteryx.

Data Modeling: TOAD, Star-Schema Modeling, Snowflake-Schema Modeling, Fact and dimension tables, Pivot Tables, Erwin

Testing Tools: HP ALM, Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools

Defect Tracking Tools: TFS, JIRA, Confluence

RDBMS: Oracle 11g/10g/9i/8i/7.x, MS SQL Server 2005/2008, DB2, Sybase, Teradata, MS Access 2008

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL,Python, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, .NET, Java, J2EE, XML, XSD, XSLT

Environment: UNIX, MVS, IBM AIX 4.2/4.3, Hyperion, Win 3.x/95/98, NT 4.0

Databases: Netezza NPS 8050, Teradata, Hive, HBase, Impala, Hadoop, MS SQL Server 2008/2012 (SSRS/SSAS/SSIS)

PROFESSIONAL EXPERIENCE

Confidential, OR

Sr. ETL/BI Tester

Responsibilities:

• Tracking the defects which are encountered during testing of various modules of the application.
• Perform Backend Testing like Functional Testing, Regression Testing.
• Wrote complex MS SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
• Worked as ETLTesterresponsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
• Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS) and generating pie charts.
• Experience in ETL Data Warehousing, database testing using Informatica for job process.
• Generated automated test cases on first build of the module using QTP, Rational Tools.
• Worked with business team to test the reports developed in MicroStrategy
• Performed regression testing against the various builds of the application and executed manually in RQM to perform through testing.
• Knowledge in Python scripting.
• Enhanced the daily test automation environment using Python 2.3.
• TestedSSIS packagesaccording to business requirements and data mapping requirement documents.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping.
• Hands on testing experience on applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using Informatica, SQL Server SSIS.
• Tested the reports generated by (SSRS) SQL Server reporting services and checked as they are as per the Organization standards.
• Optimization and maintenance of existing SSIS packages & Testing of SSAS reports.
• Performed extensive data validations against Data Warehouse.
• Created well detail Manual Test scripts in HP ALM to test application Functionality, End to End, GUI, Look & Feel, and Content.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Actively involved in interacting with developers for the Bug Fixes and Problem resolution.
• Created test plan, test cases, test scripts and test steps for every release and stored in Microsoft- TFS.
• Extensively used HP ALM to create test plan, test cases and bug tracking.
• Validated SSIS Packagesby using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages
• Developed Test Plans, Test Cases, Test Scripts for UAT tests.
• Testing and bug fixing of an embedded logging application written in Python.
• Worked on Hive to Stage (Netezza) Mappings this involved Hive (data fabric) as source.
• Extensively used HQL Queries to analyze the HDFS data.
• Validated the data load process for Hadoop using theHiveQL queries.
• Worked with Teradata SQL Assistant for data retrieval and data validation
• Created test plan, test cases, test scripts and test steps for every release and stored in Microsoft- TFS
• Use SQL, PL/SQL to validate the Data going into the Data Warehouse.
• Created Hive queries for the data validation
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Analyzed and created the bug tracking reporting and summary report in the ALM/Quality Center
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Promoted Unix/Informatica application releases from development to QA and to UAT environments.
• Validated the Pig, Hive Scripts by pulling the data from theHadoopand validating it with the data in the files and reports.
• Performed tests on various features of Agile Development process
• Perform end-to-end UAT testing before handling it off to the user group.
• Performed Data centric testing using advanced SQL skills.
• Experience in Automation. (Query surge)
• Use of ETL Automation tool Query Surge to create query pairs using SQL queries.
• Implemented Data Validation Option (DVO) for understanding on how to run tests and evaluated the test results.
• Involved in testing Cognos Reports and closely worked with operations, and Release teams to resolve the production issues.
• Involved in testing the Cognos reports by writing complex SQL queries.
• Analyzed root cause of a problem and demonstrated good sense when handing the problem over to development.
• Co-ordinate with off-shore and on-shore team for sprint deliverables.
• Maintain Project dashboards and user dashboards to reflect current sprint data.
• Validated the Dashboard navigations at monthly level and weekly level to the detailed report.

Environment: Informatica, SQL, Teradata, MicroStrategy, Agile, Control-M, Informatica DVO, Oracle, Database, Python 2.3, Microsoft Visual Studio, SSIS, SSRS, SQL Server Management Studio 2014, UAT, XML, Netezza, XSLT, MS SQL, Rational DB2, Quality Manager (RQM), Hadoop, PL/SQL, UNIX, TFS, Quick Test Pro/UFT, Autosys, Web Services, Query surge tool, HP ALM Quality Center.

Confidential, Charlotte, NC

Sr. ETL/QA/BI Tester

Responsibilities:

• Wrote test scenarios and then test cases and created test data for testing the application.
• Actively involved in functional, unit and integration testing in rational methodology.
• Involved in testing all the reports that were generated through Alteryx.
• Created and executed test cases, test scripts based on ETL Mapping document.
• Involved in validating various SSIS and SSRS packages according to functional requirements.
• Used HP Quality Center to upload all test cases in Test plan and Test lab modules.
• Create mapping using Informatica to cleanness data and feed into tables again.
• Raised defects in defect module of QC and retested when in test status.
• Involved in testing Alteryx reports including for data validations.
• Tested ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files to target tables.
• Tested data migration to ensure that integrity of data was not compromised.
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Mapping.
• Tested Complex ETL SSIS and SSRS Packages and Sessions based on business user requirements and business rules to load data from different source.
• Developed Test Cases for Deployment Verification, ETL Data Validation and Data Report testing in SSRS report testing.
• Generated flat files using the Teradata Export for the Segmentation process.
• Used Hive to write HQL queries for validating constraints, indexes.
• Identify business rules for data migration and Perform data validations.
• Tested/Found the defects in Backend DWH staging tables, Facts and Front-End Cubes and reports.
• Performed System, Integration, User Acceptance and Regression testing.
• Used tableau, Alteryx to offer interactive reporting to the end users
• Logged defects in ALM and communicated that to the development team during daily defect status call.
• Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data
• Created defects inHPALMand mapped them toHPALMtest cases.
• Hands on Experience in HP ALM and QUERY SURGE.
• Extensively tested theBusinessObjects report by running the SQL queries on the database by reviewing the report requirement documentation.
• Involving in formulating the test plan, procedures and Wrote test cases.
• Reported bugs and tracked defects using Quality Center 11.
• Loading Flat file Data into Teradata tables, Hive, HBase using UNIX Shell scripts.
• Involved in testing of Universes from different data sources like Teradata, Netezza, Oracle.
• Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
• Involved in testing the designing and development of data warehouse environment.
• Worked with appropriate business and technology leads to determine the acceptable range for test results and performance.
• Responsible for different Data mapping activities from Source systems to Teradata.
• 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.
• Testing of Business Objects and Reports which Includes, Database Connectivity, tested objects in the Universe to ensure the correct mapping of the objects.
• QueriedTeradataDatabase and validated the data using SQL Assistant.
• Tested several reports developed using Business Objects.
• Worked on profiling the data for understanding the data and mapping document.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used SQL for Querying the Teradata database.
• Involved in extensive DATA validation using SQL queries and back-end testing.
• Used HQL for Querying the Hadoop database in UNIX environment.
• Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.

Environment: Informatica, Hadoop, Alteryx, HP ALM/Quality Center 11.5, 1A automation, Query surge tool, rational, SQL Server 2014, SSIS, SSRS, SQL, HQL, Ambari, Teradata SQL Assistant, Oracle 11g, UNIX, Shell Scripting.

Confidential, RI

Sr. ETL/QA/BI Tester

Responsibilities:

• Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems.
• Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application.
• Validating maps on Informatica to verify data from Source to Target data base & record test results.
• Managed multiple OLAP andETLprojects for various testing needs.
• Debugging the SQL-Statements and stored procedures for various business scenarios.
• Performed extensive Data Validation, Data Verification against Data Warehouse.
• Responsible to create, Execute Test Sets in HP ALM Test Lab.
• Reported defects using HP ALM Verified fixes and closed bugs during regression testing.
• Tested the ETL SSIS mappings and other ETL Processes (Data Warehouse Testing).
• Created ETL test data for all ETL mapping rules to test the functionality of the SSIS Packages.
• Tested the created SSIS packages to transfer data from various sources like Oracle, Db2, MS Access, Excel, Flat files
• Loading Flat file Data into Teradata tables using Unix Shell scripts.
• Used Teradata SQL to save queries to a file so they can be run automatically from the same file in the future.
• Validated theCognosReports by checking the summary records in the cube equal the total of the detail records in the report when queried using the same parameters.
• Created and executed test cases based on test strategy and test plans based on ETL Mapping document.
• Tested Informatica ETL mappings that transfer data from Oracle source systems to the Data Mart.
• TestedCognosreports to check whether they are generated as per the company standards.
• Analyzed business requirements and develop detailed Test Matrices, Test Scenarios and Test Cases.
• Wrote SQL scripts in TOAD for Oracle and Teradata SQL Assistant for Teradata.
• Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
• Testing the source and target databases for conformance to specifications.
• Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center.
• Designed and prepared scripts to monitor uptime/downtime of different system components.
• Written Test Cases forETLto compare Source and Target database systems.
• Involved in designing of Informatica mappings by translating the business requirements.
• Interacting with senior peers or subject matter experts to learn more about the data.
• Identifying duplicate records in the staging area before data gets processed.
• Extensively written test scripts for back-end validations.

Environment: Informatica, Cognos, HP ALM/Quality Center 11.5, Control-M, Agile, SQL, SQL Server 2012, SSIS, SSRS, PL/SQL, TOAD, Teradata SQL Assistant, Oracle 11g, UNIX, Shell Scripting.

ETL/DWH QA Tester

Responsibilities:

• Assisted in creating fact and dimension table implementation in Star Schema model based on requirements.
• Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document.
• Performed extensiveDatabaseTesting by writing complex SQL Queries in DB2 to test the different scenarios in the application.
• Performed data manipulation using basic functions and Informatica Transformations.
• Performed Functional, Integration, Regression and System (End-End), and Back-End Integration Testing with back end OracleDatabaseusing SQL Queries.
• Written complex SQL queries for querying data against different data bases for data verification process.
• Performed UAT testing.
• Responsible for testing Business Reports developed by Business Objects.
• Prepared the Test Plan and Testing Strategies for Data Warehousing Application.
• Preparation of technical specifications and Source to Target mappings.
• Managed and executed the test process, usingAgileMethodology.
• Involved in executing the ETL Test Jobs from the Informatica power center workflow Manager to verify different test cases and validate the data.
• Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security.
• Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans.
• Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads.
• Creating test cases for ETL mappings and design documents for production support.
• Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files.
• Effectively communicate testing activities and findings in oral and written formats.
• Worked with ETL group for understating mappings for dimensions and facts.
• Informatica designer tasks such as creating mappings, mapplets, transformations, sessions and workflows to extract, transform and load data into data warehouse.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked on issues with migration from development to testing.

Environment: Informatica, Business Objects, Quality Center 10, Control-M, MS SQL Server 2012, Agile, TOAD, Oracle, PL/SQL.

Confidential, Dallas, TX

ETL QA BI Tester

Responsibilities:

• Analyzed the Business Requirements of the system. Worked with the development team to review project plans, requirements specification, design documents, and computer software.
• Created Manual Test Suites for various modules.
• Analyzed the Functional requirements using Scenarios & DDD (Detailed Design Document).
• Worked with business team to test the reports developed in Cognos.
• UtilizedTFSfor test case management and Defect Tracking.
• Ran SQL queries to verify the number of records from Source to Target and validated the referential integrity, Time variance, Missing records, Nulls/Defaults/Trim spaces rules as per the design specifications.
• Used Informatica as an ETL Tool for Developing the Data Warehouse.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise data warehouse.
• Used UNIX to verify the session log files for error and warning details.
• Responsible for creating Test Plans, Test cases, Test data based on functional and non-functional requirements (i.e. Interfaces) to test theCognosreports
• Compared query result sets from different database systems using UNIX diff command.
• Verified correctness of data after the transformation rules were applied on source data.
• Coordinated execution of User Acceptance Testing, regression and integration testing with multiple departments.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Maintained the batch processes using Unix Shell Scripts.
• Worked with development team to ensure testing issues are resolved on the basis of using defect reports.
• Wrote complex SQL s to validate target data based on the business requirements.
• Used PL/SQL programs for performance testing.
• Implemented data verification procedures for ETL processes in load testing.
• Used SQL and PL/SQL scripts to perform backend database testing.
• Involved in coordinating the White box and Black box testing for the data warehouse by checking ETL procedures/mappings, Generated the detailed reports.

Environment: Informatica, Teradata, Cognos, SQL, PL/SQL, DB2, UNIX Shell Scripting, Toad, Oracle, Windows.

Confidential

ETL Tester (Internship)

Responsibilities:

• Worked closely with Business user in Understanding designing and documenting the Functional testing plan and then Writing, executing, documenting the results and Logging defects.
• Wrote test cases based on ETL mapping document for testing the entire ETL job.
• Tested several Informatica ETL jobs and ran on UNIX for loading purpose and checking the log files.
• Created and Configured Workflows, Work lets, and Sessions to transport the data to target using Informatica Workflow Manager.
• Developed Test Cases to cover overall quality assurance testing.
• Executed the Test cases for Crystal Reports.
• Maintained Test Logs and Reports in Quality Center.
• Involved in rebuild testing of the BI Reports from Cognos to Crystal Reports.
• Involved in understanding of business processes to learn business requirements.
• Conducted System testing for each phase of the application.
• Involved in preparing Test Scripts and Test cases based on the functional specifications.
• Executed backend testing of the application by writing SQL queries.
• Used Defect Tracking System Rational Clear Quest to report bugs found in different testing stages.
• Executed Test Procedures and documented Test Results.
• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Executed jobs through sequencer for better performance and easy maintenance.
• Involved in performance tuning of the jobs.
• Used T-SQL for validating the data generated at OLAP server.

Environment: Informatica, Crystal Reports, Quality Center, SQL*Plus, SQL, Rational Clear Quest, Oracle 8.0, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, Windows 95, Korn Shell scripting.