We provide IT Staff Augmentation Services!

Etl Qa Tester Resume

Boston, MA

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.

Hire Now