We provide IT Staff Augmentation Services!

Qa/ Etl Tester Resume

Mc Leav, VA

PROFESSIONAL SUMMARY:

  • Over 5 years of experience as an ETL Tester and Software Quality Analyst with experience in Confidential, 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 Data Analysis, Design, Development, Implementation and Testing of Data Warehousing using Data Conversions, Data Extraction, Data Transformation and Data Loading ( ETL).
  • Experience in preparation of Test Cases and to ensure detailed test process wrote Test Scripts.
  • Experience in preparation of test data to test the functionality of Informatica Sources Mappings and Targets.
  • Hands on experience working and Agile Methodology.
  • Extensive Experience in creating Test Cases, Test scripts, Test Strategies and Test.
  • Plans based on FSD's, BRD's & Use Cases Experience in testing Business Intelligence reports generated by various BI Tools like Cognos, microstrategy, ssrs.
  • Strong Business and Functional exposure on various business applications including Financial and Confidential .
  • Flexible, resourceful, and self - motivated and can work as a team and independently.

WORK EXPERIENCE:

QA/ ETL TESTER

Confidential - MC LEAV, VA

RESPONSBILITIES:

  • Tested Informatica ETL mappings that transfer data from source systems to the Data Mart.
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic
  • Involved in Teradata SQL Development, Unit Testing and Performance
  • Expertise in utilizing Oracle utility tool SQL and expertise in Toad for developing Oracle applications.
  • Written several complex validating Cognos Reports
  • Performed Teradata SQL Queries, creating Tables, and Views by following
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Analyzed business requirements, data mapping specifications and developed Test Plans, Traceability Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using Quality center.
  • Used Toad for query Oracle, SQL and SQL Management studio for SQL Server
  • Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
  • Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes.
  • Used Toad for query, SQL Assistant and SQL Management studio for SQL Server
  • Generated Cognos reports target view and validating to match user requirements
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Participated in defining and executing test strategies using agile methodology
  • Created complex SQL queries for querying data against different data bases for data verification process
  • Good working experience in Oracle, Unix Shell Scripting
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting Coordinating data movement and validation with third party vendors.
  • Used Toad for, SQL Assistant for Teradata and SQL Management studio for SQL Server
  • Managed and executed the test process, using Agile Methodology

Environment: Informatica, Cognos, SQL, Quality center, Oracle, Teradata, Agile.

SQL/ ETL TESTER

Confidential - IRVINE

RESPONSABILITIES

  • Expertise in utilizing Oracle utility tool SQL and expertise in Toad for developing Oracle applications
  • Hands on experience working in V-Model and Agile Methodology.
  • Performed Back end testing by writing SQL statements like Join, Inner Joins, Outer joins and Self Joins using Rapid SQL.
  • Writing and Executing Test cases and defect tracking using Quality Center.
  • Used Toad for query Oracle, SQL Assistant for and SQL Management studio for SQL Server
  • Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like Quality Center / ALM, SharePoint
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Tested several Data warehouse ETL Informatica Mappings to validate the business conditions.
  • Worked with business team to test the reports developed in Cognos and executed the test process, using Methodology.
  • Tested ETL mappings that transfer data from Oracle source systems to the Data Mart.
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices
  • Involved in validating the batch processes such as Informatica and UNIX Scripts scheduled using Autosys.
  • Developed SQL queries to test the data after uploading vehicle, buyer, and saler information into Autotrader
  • Helped the System test lead in developing the Test Plan and Testing Strategy for ETL/BI Managed and executed the test process, using Agile Methodology.

Environment: Informatica, Cognos, SQL, Quality center, Oracle, Teradata, Agile’

ETL TESTER

Confidential -NORRTHBROOK, IL

RESPONSABILITIES:-

  • Worked on Data Stage to resolve production issues perform testing and debugging of mappings and reports Extraction of test data from tables and loading of data into SQL tables
  • Tested several reports detailing price/volume trends and expense variance over previous periods by using micro strategy
  • Developed SQL scripts to test business logic from source to target.
  • Used JIRA to state requirements, test plan, test cases, and update test run status for each iteration and to report the defect
  • Have worked with technologies including: XML, Java, Hermes JMS, SOAP UI, ASP, VB, Oracle, SQL Server and IBM Mainframes
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using ETL tools and Data Stage
  • Performed extensive Testing by writing complex SQL Queries in DB2 to test the different scenarios in the application.
  • Participated in defining and executing test strategies using agile methodology.
  • Matrix, Test Cases, Expected Results and Prioritized tests for the applications for various modules using JIRA.

Environment: Data stage, Microstrategy, Oracle, DB2, Jira, SQL, Agile.

TESTER

Confidential

RESPONSABILITIES:

  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using Data Stage
  • Extensively used MicroStrategy for report generation.
  • Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.
  • Good understanding of FACT and Dimension tables. Very strong in SQL and PL/SQL, extensive hands on experience in creation of database tables, triggers, sequences, functions, procedures, packages, and SQL performance-tuning.
  • Reported bugs and tracked defects using JIRA
  • Used SQL for Querying the DB2 in UNIX environment
  • Working knowledge in Agile/Scrum (using Rational Team Concert - IBM), Waterfall and Iterative SDLC methodologies.
  • Validated various Reports, Custom filters, Prompts, Custom groups, Consolidations and Drill paths developed in MicroStrategy.

Environment: Data stage, Microstrategy, Oracle, DB2, Jira, SQL, Agile

Hire Now