We provide IT Staff Augmentation Services!

Etl Tester Resume

Charlotte, NC

SUMMARY:

  • Over 5 years of experience as an ETL Tester and Software Quality Analyst with experience in Healthcare, Banking and Retail domain.
  • Proficient in performing ETL, BI and backend manual testing.
  • Experience with Initial and Incremental load testing within ETL Testing.
  • Strong working experience in the D Confidential Analysis, Design, Development, Implementation and Testing of D Confidential Warehousing using D Confidential Conversions, D Confidential Extraction, D Confidential Transformation and D Confidential Loading.
  • Experience in preparation of Test Cases and to ensure detailed test process wrote Test Scripts.
  • Experience in preparation of test d Confidential to test the functionality of Informatica Sources Mappings and Targets.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects.
  • Strong Business and Functional exposure on various business applications including Financial and Healthcare.
  • Strong D Confidential Querying/SQL and UNIX Shell Scripting skills. Possess excellent skills in Manual Testing and automated testing.
  • Writing and Executing Test cases and defect tracking using Quality Center.
  • Extensively involved in smoke testing, user acceptance testing, functional testing, integration testing, d Confidential base testing and regression testing.
  • Experience in processing and validating d Confidential in flat files as well as in DB tables.
  • Highly experienced with different RDBMS and No SQL DB such as Oracle, MS SQL Server, Hadoop, MongoDB, Casendra, Talend, Terad Confidential and MySQL
  • Adept in writing SQL scripts required for testing various ETL and backend processes.
  • Compatible to work in agile environment.
  • Excellent concept of ETL, D Confidential warehousing and BI applications integration.

PROFESSIONAL EXPERIENCE:

ETL Tester

Confidential, Charlotte, NC

Responsibilities:

  • Tested the reports generated by SQL Server reporting services (SSRS) and checked as they are as per the Organization standards.
  • Involved in generating Test Scripts using QTP/UFT for different transactions to execute Regression Testing and Acceptance Testing.
  • Tested d Confidential migration to ensure that integrity of d Confidential was not compromised.
  • Responsible for coordinating Integration testing, UAT and Regression testing with Business Consultants and Offshore team members, as applicable.
  • Developed Test Plan, Test Cases, Test D Confidential and Test Summary Reports and followed Water fall / EDM Maintenance process.
  • Worked with SSRS XML export on the reports and with ranking values in the XML.
  • Tested several D Confidential warehouse ETL Informatica Mappings to validate the business conditions.
  • Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and Confidential Mainframes.
  • Used Rapid SQL for executing the SQL commands.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting
  • Creating, Deploying and managing Reports through SQL Server Reporting Services (SSRS) and generating pie charts.
  • Performed end - to- end testing of applications and coordinated with other teams.
  • Involved in extensive D Confidential validation using SQL queries and back-end testing.
  • Used version one for assigning the task and raise the defect and close the defects
  • Used Doors tool for mapping the SRS documents with the test cases in HP ALM
  • Worked on issues with migration from development to testing
  • Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing

Environment: Informatica, D Confidential warehouse, UNIX, Windows NT, Agile, SSRS, HP QTP, Oracle, SQL, T-SQL, Toad, XML, XSD

ETL Tester

Confidential, OH

Responsibilities:

  • Involved in understanding Logical and Physical D Confidential model using Erwin Tool
  • Prepared Execution procedure document format to prepare the Test cases based on mapping document.
  • Ensured that the mappings are correct and Conducted d Confidential validation testing
  • Worked with business analyst and developers in setting up test d Confidential
  • Tested several D Confidential warehouse ETL Informatica Mappings to validate the business conditions.
  • Extensively tested several MicroStrategy reports for d Confidential quality, fonts, headers & cosmetic
  • Writing complex SQL queries for d Confidential validation for verifying the ETL Mapping Rules
  • Extensively test the reports for d Confidential accuracy and universe related errors
  • Used Toad for query Oracle, SQL Assistant for Terad Confidential and SQL Management studio for SQL Server
  • Used T-SQL for Querying the SQL Server d Confidential base for d Confidential validation and d Confidential conditioning
  • Tested several dashboards and deployed them across the organization to monitor the performance
  • Used SQL tools to run SQL queries and validate the d Confidential loaded in to the target tables
  • Monitored the workflow transformations in Informatica work flow monitor
  • Preparing manual test cases and test d Confidential for Scenarios
  • Developed test plans, test cases and test scripts for d Confidential validation testing.
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Huge experience on testing MicroStrategy Reports. Validated the underlying SQL query, Report layout and the naming conventions against the requirement, Formatting Properties like alignment, scroll bar, decimal places etc., Export/ Print functionality.
  • Created ETL execution scripts for automating jobs
  • Involved in extensive D Confidential validation using SQL queries and back-end testing
  • Used workflow manager for session management, d Confidential base connection management and scheduling of jobs

Environment: Informatica, XML, XSLT, XPath, XQuery, MICROSTRATEGY, SQL Server, ALM/ HP Quality Center, SQL, TOAD, Terad Confidential SQL Assistant, Oracle, PL/SQL

ETL Tester

Confidential, RI

Responsibilities:

  • Involved in meetings to discuss the findings in the executed tests and decide the next steps.
  • Developed and Performed execution of Test Scripts manually to verify the expected results.
  • Validated that application meets requirements and functioning as per the technical and functional specifications.
  • Tested the functionality and performance of web services using SOAP UI.
  • Used Quality Center to state requirements, test plan, test cases, and update test run status for each iteration and to report the defects.
  • Worked on issues with migration from development to testing
  • Involved in recording change requests on the Change Requests.
  • Created Requirement Traceability Matrix by mapping the requirements with test cases to ensure that all requirements are covered in testing
  • Interacted with the Business users to identify the process metrics and various keys dimensions and measures.
  • Involved in testing the MicroStrategy reports by writing complex SQL queries.
  • Developed the detail ETL Test Plan, Test Resource Utilization and Close Down document for multiple products.
  • Ensured d Confidential integrity and verified all d Confidential modifications and calculations during d Confidential base migration using Informatica.
  • Developed complex queries to test the reports developed.
  • Involved in testing the XML files and checked whether d Confidential is parsed and loaded to staging table
  • Performed Terad Confidential SQL Queries, creating Tables, and Views by following Terad Confidential Best Practices
  • Generated Cognos reports using Oracle target view and validating to match user requirements
  • Tested the d Confidential and d Confidential integrity among

Environment: Informatica, Oracle, SQL, PL/SQL, SOAP, SOAP UI, UNIX, Terad Confidential, ALM/HP Quality Center 11, TOAD, MICROSTRATEGY, MS Excel, Agile, XML.

Hire Now