SUMMARY

• 6+ years of IT experience working as ETL and BI Tester involved in Business Intelligence testing and ETL testing on various Data Warehouse Environments in multiple domains.
• Experience in full Software Development Life Cycle (SDLC), analysis, design, testing, implementation and maintenance in data warehousing environment.
• Having in depth technical experience of Software Test Life Cycle, Water Fall and Agile methodologies.
• Good Experience in QA Methodology and Validations to ensure industry standards.
• Experience in UNIX shell scripting and Informatica sessions scheduling.
• Experience in gathering functional requirements from users and designing data model for ETL.
• Extensively worked in HP Quality Center and JIRA to perform testing and analysis.
• Experience performing Unit testing, Regression testing, and GUI testing.
• Proficient experience in different Databases like MS SQL, Oracle, SQL Server, DB2 and Teradata.
• Good exposure working and coordinating with on shore and off shore team.
• Experienced in automation testing using HP and Rational test tools HP Quick Test Pro (QTP) and UFT.
• Performed end to end ETL testing and validation using source and target data mart in source system and target system.
• Testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
• Hands on experience in manual testing and automation testing using HP ALM/QC, JIRA and QTP.
• Extensive experience in the ETL testing, manual testing and Business Intelligence Applications.
• Strong working experience on data warehousing applications, directly responsible for the Extraction, Transformation and Loading of data from multiple sources into Data Warehouse
• Experience in writing of test cases, test scripts and test procedures.
• Experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Datawarehouse using Informatica.
• Identifying and tracking performance issues and defects during testing.
• Performed BI testing using reporting tools Cognos Dashboards and Business Objects.
• Experienced with coordinating cross - functional teams, project management and presenting technical ideas to diverse groups & proven ability to implement technology-based solutions for business problems.
• Experience in Data Analysis, Data Extraction, Data Integration, Data Testing and Data Cleansing.
• Excellent communication skills, team player, quick learner, organized, hard working.

TECHNICAL SKILLS

Data Warehousing: Informatica, Data Stage, SSIS.

Reporting Tools: Business Object, Cognos, Crystal Reports, SSAS, SSRS, Micro Strategy

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

Testing Tools: Win Runner, Load Runner, Test Director, HP Quality Center, Rational Tools, Selenium, Bugzilla, JIRA

RDBMS: Oracle, MS SQL Server, DB2, Sybase, Teradata, MS Access

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, 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, Hyperion

Databases: Netezza

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

ETL QA Tester

Responsibilities:

• Interact with Business users on Testing needs and technical specifications document, High-level design document, Source to target mapping document.
• Perform Backend Testing like Functional Testing, Regression Testing.
• Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data Warehouse project.
• Based on the business requirements, created Test Plan, Test Cases, and Test Script documents to test the Business Objects
• Responsible for system testing, regression testing, and end to end testing, UAT testing and also production run testing.
• Performed extensive data validations against Data Warehouse.
• Worked with Informatica Power Center and tested numerous mappings.
• Responsible to verify Web services API request, response data validations in REST, SOAP protocols.
• Coordinated all QA activities and enhancements using Agile Methodology.
• Worked on Informatica Power Center tool - Source Analyzer, warehouse designer, Mapping Designer, Mapplets Designer and Transformation Developer.
• Extensively used Informatica power center for extraction, transformation and loading process.
• Extensively worked Agile Scrum methodologies of the application and involved in System Integration testing, Smoke, Functional, Regression and User Acceptance Testing.
• Involved in designing of Test Plan, Identifying Test Scenarios and Executing the Test Cases.
• Conducting Retesting with multiple sets of test data using Data Driven Approach.
• Performed tests on various features of agile process.
• Used HP ALM Quality Center to track and report system defects.
• Verified the back-end reflection in the data mart by establishing connection to the database and by executing SQL queries both in manual and automation process.
• Writing Test cases and test scenario's on multiple applications to validate data end to end source to target.
• Created and maintained the business complex reports using the Business Objects Reporting Module as per user requirements
• Use SQL, PL/SQL to validate the Data going in to the Data Ware House.
• Used Source to target (STM) mapping document to perform ETL testing for end-to-end flow of data.
• Very good understanding on Data warehouse concepts, end-to-end ETL flow and BI methodologies.
• Wrote complex SQL, PL/SQL Testing scripts for Backend Testing of the Data Warehouse application.
• Attended daily SCRUM meeting and provide team with test results and performance improvements needed.
• Provide support to team for functional requirement issues.
• The reports that were created in Business Objects were testing by running the SQL statements
• Implemented defect management, automated regression testing, performance testing, requirement review, code review, release management.
• Involved in Test cases to test different scenarios including positive and negative testing.
• Logged defects for improper requirements and harness issues respectively.
• Worked on Agile methodology with team of ETL Database testers.
• Use HP Quality Center for defect tracking, fixing the defect and updating the status of the defect.
• Wrote SQL views in schematic layer to test data Mart inbound to reports.

Environment: Informatica Power Center, Agile, Business Objects, HP ALM/QC, Oracle, QTP/UFT, Teradata, UAT, Microsoft Visual Studio, XML Files, SQL, PL/SQL.

Confidential, Atlanta, GA

ETL BI Tester

Responsibilities:

• Translating client's strategic vision into technical solutions and application identification.
• Used HP Application Lifecycle Management (ALM) for uploading test cases, Data Scenario's and procedure documents for different departments.
• Involved in the error checking and testing of the ETL programs using Informatica session log and workflow logs.
• Have tested several complex reports generated and Business Objects including dashboards, summary reports, master detailed, drill down and score cards
• Created test cases and executed test scripts using HP ALM/Quality Center.
• Involved in Data Warehouse testing by checking ETL procedures/mappings.
• Validated the data flow from Source to Target tables by verifying the mappings and transformations in ETL Tool, Informatica.
• Involved in writing Complex SQL PL/SQL Scripts in querying SQL Server, Teradata and Oracle.
• Performed smoke batch end to end to ensure proper data flow from source to target.
• Worked on tracking defects and fixing the defects as needed for multiple applications.
• Worked in automatic test scenarios and validated data Mart.
• Worked with Business Object’s Team to test reports.
• Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
• Involved in User acceptance testing UAT and wrote multiple test cases.
• Wrote complex SQL Queries to validate data Mart in SQL Server and Teradata SQL Assistant.
• Attend weekly Project Status Meeting with Team, QA Manager, and worked closely to define Test Strategy, Gap Analysis, Risk, and Test Dependency.
• Wrote Complex SQL queries to validate the standard reports, Dashboards and Business Objects Universes.
• Attended daily SCRUM meeting and provide team with test results and performance improvements needed.
• Reviewed the ETL mappings (Informatica) to ensure the transformation rules are applied correctly.
• Extraction of test data Mart from tables and loading of data into T-SQL tables.
• Automated functional, GUI and Regression testing by creating scripts in QTP/UFT.
• Worked on Clear Quest to log defects and track resolution till the closing of defect after retesting.
• Tested the ETL with XML as source and tables in the data warehouse as target.
• Tested application and filed defects using Quality Center/ALM.
• Used T-SQL for Querying the DB2 database in UNIX environment.
• Responsible for testing packages using (ETL) to verify data completeness, data transformation, data quality, integration testing, UAT and regression testing.
• Writing scripts for data cleansing, data validation, data transformation for the data coming from different source systems.
• Involved in writing complex queries, testing and review sessions.
• Ensure strict adherence to committed deadlines as per project implementation schedule.
• Worked with offshore team for performing needed testing and analysis as per user requirement.

Environment: Informatica, HP QC/ALM, Oracle, UAT, DB2, QTP/UFT, Business Objects, Teradata, Oracle, SQL, PL/SQL, T-SQL, XML, UNIX.

Confidential, Charlotte, NC

ETL SQL Tester

Responsibilities:

• Interacted with Business users to gather testing needs and data Mart flow from source to target.
• Involved in test plan, writing test scenarios and executing test cases as per user requirement.
• Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
• Validated data Mart using different parameterized techniques and plans to perform analysis.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures, and Macros.
• Used Informatica ETL tool to perform ETL testing and validating end-to-end flow of data with Informatica.
• Performed data validation testing after the ETL process using Informatica.
• Involved in writing ANSI SQL functions, Stored Procedures within Composite Data type.
• Used SQL for Querying the DB2 database in UNIX environment.
• Tested several Informatica Mappings to validate the business conditions.
• Extracted data from various sources like Oracle, flat files and SQL Server.
• Worked with offshore team for performing needed testing and analysis as per user requirement.
• Reported bugs and tracked defects using Quality Center.
• Preparing manual test cases and test data for Scenarios.
• Written several complex SQL queries for validating Cognos Reports.
• Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
• Prepared the guides for UAT Production readiness for entire ETL testing efforts.
• Created SQL Queries using SQL*Plus for dropping indexes prior to the load graph execution to be able to perform direct loads on the database tables.
• Assisted in promotion of code and Unix Shell scripts from UAT to Production.
• Worked with ETL group for understating mappings for dimensions and facts.
• Involved in Smoke testing of application during releases and performed testing.
• Worked with business team to test the reports in Cognos.
• Performed User Acceptance testing (UAT) to ensure on end-to-end functionality process.
• Based on the requirements created Functional design documents and Technical design specification documents for transformation and loading purpose.
• Performed Unit testing and Integration testing on the mappings in various schemas.
• Worked with offshore team for performing needed testing and analysis as per user requirement.

Environment: Informatica, UAT, DB2, Quality Center, Oracle, Cognos, UNIX, SQL, PL/SQL, Teradata, XML.