We provide IT Staff Augmentation Services!

Etl Tester Resume

2.00/5 (Submit Your Rating)

Columbus, IN

SUMMARY

  • Having 8 years of experience on ETL/DWH, Manual and BI Reports Testing.
  • Good Exposure to Data Warehousing Concepts.
  • Hands on experience in writing and executing SQL Queries.
  • Good Experience in database testing and Oracle 10g.
  • Experience in different types of testing like Functional Testing, Regression testing Integration testing and Smoke Testing
  • Good knowledge in testing Facts and Dimensions based on mapping logic.
  • Having testing experience in Informatica Power Center tool and Microsoft Visual Studio SSIS tool.
  • Hands on experience in BI reports testing like Micro strategy (MSTR) and SSRS Reports.
  • Involved in preparing and reviewing Test Cases.
  • Working Knowledge on Defect Logging, Tracking and Analysis in HP Quality Center Test Management Tool. Extensive Experience in Quality Center which includes Uploading Requirement, Preparation of Test cases and uploading, Execution of Test Cases, Logging & tracking Defects, Preparation of Metrics and Preparing Status reports for test design Phase and Execution Phase
  • Sound Knowledge and experience in Metadata and Star schema/Snowflake schema. Analyzed Source Systems, Staging area, Fact and Dimension tables in Target Data Warehouse
  • Handle Defect triage meetings with Teams
  • Hands on Experience in Excel Macros, Testing Data records from Staging DB across Target DB
  • Skilled in understanding Business requirements and Designed documents.
  • Worked in Agile Methodology
  • Have hands on Experience in Test data preparation

PROFESSIONAL EXPERIENCE

Confidential - Columbus, IN

ETL Tester

Responsibilities:

  • Responsible for testing and reviewing of ETL mapping and transformation specifications based on the business requirements from various teams and the business teams.
  • Testing of ETL jobs that are scheduled for file transfers from Operational Data Stores to designated file systems/directories.
  • Reviewed the Business Requirement Document to understand the process and write Test Plan and Test Cases.
  • Formulate methods to perform Positive and Negative testing against requirements.
  • Conducted Smoke testing, Functional testing, Regression testing, Integration testing, and User Acceptance Testing (UAT) and Data validation testing.
  • Used Agile testing methodology for achieving deadlines in UAT.
  • Creating test cases for ETL mappings and design documents for production support
  • Monitoring and using Job Control System in QA
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using Informatica Power Center.
  • Validated data in between source and target after running Mappings by the Informatica developer team.
  • Writing SQL queries to validate the ETL process and BI Reports
  • Create traceability matrix
  • Participated in Test data preparation and TDM
  • Interactions with BA & Dev. Teams to resolve the issues.

Confidential - ST.Louis-MO

ETL Tester

Responsibilities:

  • Involved in functional study of the application.
  • Analyzed Business and Functional Requirement Specification documents and identified Test scenarios
  • As part of QA team was involved in implementation of ETL best practices.
  • Running the SSIS Packages for ETL process.
  • Verifying the data in target database after ETL process.
  • Prepared test data for testing.
  • Verifying the data which is loaded into target database.
  • Validating the Reports built through data validation and UI
  • Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the specification issues.
  • Performed Manual Testing of the application as well as identified the critical test scripts to be automated.
  • Participated in Test data preparation, Took part in preparing the Test data by analyzing the projected data
  • Managed data as per the application requirement so that the reports are accessed easily
  • Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the specification issues.
  • Defect Analyzing and Reporting in Quality Center
  • Conducted various management activities by analyzing and verifying test results, providing status reports.
  • Responsible to oversee day-to-day activities, provide support, and facilitate problem resolution for a team of Software Quality Assurance Engineers.
  • Assisted Business team with planning, coordinate and execution of User Acceptance Testing.

Confidential - GA

ETL Tester

Responsibilities:

  • As part of QA team was involved in implementation of ETL best practices.
  • Running the Workflows for ETL process.
  • Writing SQL queries.
  • Designing & executing test cases.
  • Verifying the data in target database after ETL process.
  • Defect Analyzing and Reporting in ALM.
  • Involved in Regression Testing.
  • Validating the Reports built through data validation and UI.
  • Participated in walkthroughs and reviewed the business requirements and followed with the Business Analysts and worked towards the resolution of the specification issues.
  • Involved in performing various levels of testing like Unit Testing, System testing, Integration testing and Regression testing.
  • Conducted various management activities by analyzing and verifying test results, providing status reports.
  • Responsible to oversee day-to-day activities, provide support, and facilitate problem resolution for a team of Software Quality Assurance Engineers.
  • Assisted Business team with planning, coordinate and execution of User Acceptance Testing.

Confidential

Tester

Responsibilities:

  • Understanding the end to end process flow of the project right from loading the source data into staging table.
  • Proactively identified and interacted with different teams to understand the system and collected the data for analysis.
  • Prepared understanding document, unit test cases and Functional test cases in all the phases
  • Validating the Field Mapping between the source systems with the Target system.
  • Validating the Reports built from SSRS Reporting tools through data validation and UI.
  • Running the Workflow/Packages for ETL process
  • Used Excel Macros to Match the data records across staging DB and Target DB
  • Writing SQL queries to validate the ETL process and BI reports.
  • Designing & Executing test cases.
  • Create traceability matrix
  • Verifying the data in target database after ETL process.
  • Developed, Reviewed & Executed Test Scripts.
  • Defect Analyzing and Reporting in ALM.
  • Interactions with BA & Dev. Teams to resolve the issues.
  • Involved in Regression Testing.
  • Took part in preparing the unprojected data by analyzing the projected data
  • Managed data as per the application requirement so that the reports are accessed easily
  • Handling client calls and solving issues with the clients.
  • Involved in Effort estimation process using Wide Band Delphi technique during the Test Planning phase
  • Was given the responsibility to mentor a group of junior associates (fresher’s) in the team. Use to train them with the required trainings, use to assign tasks and ensures completion in time

Confidential

Tester

Responsibilities:

  • Understanding the end to end process flow of the project right from loading the source data into staging table.
  • Proactively identified and interacted with different teams to understand the system and collected the data for analysis.
  • Prepared understanding document, unit test cases and Functional test cases in all the phases
  • Validating the Field Mapping between the source systems with the Target system.
  • Validating the Reports built from MSTR Reporting tools through data validation and UI.
  • Running the Workflow for ETL process.
  • Used Excel Macros to Match the data records across staging DB and Target DB
  • Writing SQL queries to validate the ETL process and BI reports.
  • Designing & Executing test cases.
  • Verifying the data in target database after ETL process.
  • Developed, Reviewed & Executed Test Scripts.
  • Defect Analyzing and Reporting in ALM.
  • Interactions with BA & Dev. teams to resolve the issues.
  • Involved in Regression Testing.
  • Took part in preparing the unprojected data by analyzing the projected data
  • Managed data as per the application requirement so that the reports are accessed easily
  • Handling client calls and solving issues with the clients.
  • Involved in Effort estimation process using Wide Band Delphi technique during the Test Planning phase
  • Was given the responsibility to mentor a group of junior associates (fresher’s) in the team. Use to train them with the required trainings, use to assign tasks and ensures completion in time

Confidential

Tester

Responsibilities:

  • Gathering of Requirements from various systems business users
  • Communicating with the business users to understand business requirements clearly
  • Involved in preparation of test cases
  • Participated in Test data preparation
  • Involved in Functionality Testing and Regression Testing
  • Testing manually all the Screens(UI) and for Privileges of user
  • Effective Coordination between Development team and testing team

We'd love your feedback!