We provide IT Staff Augmentation Services!

Sr. Etl Tester Resume

5.00/5 (Submit Your Rating)

Hopkins, MN

SUMMARY

  • 8+ years of IT experience in the Analysis, design, development, testing and Implementation of Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications
  • Experience using query tools for Oracle, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
  • Solid Back End Testing experience by writing and executing SQL Queries.
  • Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
  • TEMPHas expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • Experience in UNIX shell scripting and configuring cron - jobs for Informatica sessions scheduling.
  • Good working experience on SOAP UI for testing and validating various web services used in the application.
  • Used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide- ETL Solution using Informatica and SSIS.
  • Well versed wif ETL procedures to load data from different sources like Oracle, flat files, XML files into DWH using Informatica Power Center
  • Extensively tested OLAP applications and good knowledge on end to end testing of OLAP databases.
  • Experience in Data Migration testing and Web Interface testing.
  • Testing the source and target backend databases for conformance to specifications
  • Expertise in Testing Complex Business rules by creating mapping and various transformations.
  • Experience in testing XML files and validating the data loaded to staging tables.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Expertise in ELT tool TALEND for automating the Integration.
  • Log issues dat are linked to both requirement and test cases in HP ALM.
  • Strong working experience on DSS (Decision Support Systems) applications, and Extraction, Transformation and Load (ETL) of data from Legacy systems using SSIS.
  • Experience in Financial, Banking, Brokerage, and Securities industries.
  • Testing ETL experience using Informatica (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Wrote complex SQL Testing scripts for Backend Testing of the data warehouse application
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
  • Extensively worked on Informatica PowerCenter tools- Mapping Designer, Workflow Manager, Workflow Monitor.
  • Experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
  • Bug reporting, Bug tracking was done using various Bug reporting tools like Quality center, PR Tracker, Visual Intercept, TSF and various in house tools.
  • Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
  • Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad for developing Oracle applications.
  • Worked on Dimensional modeling, Data cleansing and Data Staging of operational sources using ETL processes.

TECHNICAL SKILLS:

Testing Tools: Quality center, Test Director, Win Runner, Quick Test Pro, Load Runner, Rational Clear Quest, Rational Robot

Languages: Java, .NET, XML, HTML, SQL, TSL, Java Script, VB Script

Operating Systems: Windows, UNIX, LINUX

Databases: MS Access, Teradata, SQL Server, Oracle, Sybase, Informix, DB2

ETL Tools: Informatica Power Center, SSIS, Data stage, SSIS

Browsers: Internet Explorer, Netscape Navigator, Fire fox

Bug Tracking Tool: Rational Clear Quest, PVCS Tracker, Bugzilla, Quality center

GUI Tools: Soap UI, Visual Basic

BI Tools: Microstrategy, Cognos, Business objects, Crystal Reports, SSRS, SSAS

PROFESSIONAL EXPERIENCE

Confidential, Hopkins, MN

Sr. ETL Tester

Responsibilities:

  • Analysis of Business requirements & Design Specification Document to determine the functionality of theETLProcesses.
  • Executed UNIX Shell Scripts for Batch Job Execution.
  • Written several UNIX scripts for running test loads for regression testing purpose.
  • Used multiple data providers, Master/Detail, cross tab, Charts.
  • Tested Business objects reports and Web Intelligence reports.
  • Extracted Data from Teradata using Informatica Power CenterETLand DTS Packages to the target database including SQL Server and used the data for Reporting purposes
  • Involved in the error checking and testing of theETLprocedures and programs Informatica session log.
  • Tracked and reported the bugs wif HP ALM/Quality center.
  • Extensively worked on Mercury Test Center and ran various scenarios and scheduled them.
  • Involved in automation of test cases using QTP/UFT.
  • Tested theETLInformatica mappings and otherETLProcesses (Data Warehouse Testing).
  • Written various Unix Shell Scripts for Scheduling the job in production like check file script, load script, complete script, and DQ script.
  • Involved in developing the UNIX scripts for Informatica Workflows using parameter files and monitoring the workflows on testing environment.
  • Involved in requirements gathering and analysis in support of data warehousing efforts and data quality analysis for cleansing and developedETLspecifications.
  • Written UNIX Scripts to manipulate test data and input files.
  • Participated in bug triage meetings wif developers to validate the severity of the bug and responsible for tracking of the bug life cycle using Test Director.
  • Created various User Defined Functions for script enhancements and to verify the business logic.
  • Wrote complex SQL scripts in DB2 for testing data quality and validation.
  • Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status

    Environment: Informatica, QTP/UFT, Oracle, TOAD, SQL Server, HP ALM/Quality center, UNIX, Agile, Windows, Autosys, Business objects, XML, XSLT, SOAPUI, Web Services, MQ Messaging, PL/SQL, Test Director.

    Confidential, Baltimore, MD

    ETL Tester

    Responsibilities:

    • Analyzed the Functional requirements using Detailed Design Document.
    • Coordinated and controlled testing project at every step of the quality cycle from test planning through execution to defect management.
    • Created Data warehouse test plans, UAT plans, test cases based on theETLmapping document and functional design documents.
    • Wrote/Maintained QTP/UFT automated scripts for Web based application using advanced VB Scripting.
    • Performed additional data validation using custom SQL scripts.
    • Supported the extraction, transformation and load process (ETL) for a Data Warehouse from their legacy systems using Informatica.
    • Extensively used SQL queries to perform database validation and also automated the SQL scripts for re-usability.
    • Analyzed the data mapping and developed test scenarios to verify the data migration from different data sources.
    • Tested theETLInformatica mappings and validated transformation and involving business Logic.
    • Worked wif data analysts to understand Informatica mappings and workflows.
    • Tested several reports generated by OBIEE included dashboards, impact assessment and productivity tool /PPT
    • Created User Acceptance Test (UAT) plan and executed the product test cases wif customers in determining the functionality of the application and also performed production verification.
    • TestedETLmappings to extract and load data from different databases such as Oracle, SQL Server, XML files and flat files and loaded them in to Oracle.
    • Used Mercury HP ALM/Quality center to formulate test plan, execute test cases and performed defect management
    • Developed Requirements Traceability Matrix (RTM) to track the test cases and requirements during the QA Testing Phase

      Environment: HP ALM/Quality Center, Informatica, QTP/UFT, SQL Server, PL/SQL, OBIEE, Oracle, UAT, XML, Windows and MS Excel

      Confidential, Richmond, VA

      ETL Tester

      Responsibilities:

      • Involved in Business analysis and requirements gathering.
      • Written the SQL scripts to validate ETLs developed by SSIS.
      • Validated SSISETLmappings and transformations like joiner, update strategy and lookup.
      • Analyzed the data using SSIS Data Profiler giving Statics of the data like null values, maximum, minimum and average values.
      • Utilize various SSIS components like Lookup, Join, Rollup and Reformat to process data.
      • Experience in preparing the traceability matrix, test scenarios and test cases.
      • Involved in preparation of Requirement Traceability Metrics (RTM), Software Metrics,
      • Defect Report and requirement traceability using Quality center.
      • Analyzed test cases for automation and created scripts for regression testing using QTP Automated Test cases for the purpose of regression testing.
      • Tested data migration to ensure dat integrity of data was not compromised.
      • Experienced in writing complex SQL queries for testing data in oracle targets.
      • Prepared test data to validateETLrules wherever necessary.
      • Accessed source files from UNIX environment.
      • QTP was used to generate automated Test scripts for functionality and GUI Testing.
      • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
      • Written several complex SQL queries for validating Business objects Reports.
      • Write SQL queries to validate Drilldown and Cross-Tab reports.
      • Validated reports cosmetic like color, size in Business objects reports.
      • Reviewed the test cases written based on the Change Request document.
      • Preparation of System Test Results after Test case execution.

      Environment: Oracle, SSIS, Quality center, QTP, DB2, SQL, UNIX, Toad, Business objects, MS Office, Windows XP.

      Confidential, MANHATTON, NY

      ETL Tester

      Responsibilities:

      • Involved in Test plan and Test case preparation.
      • Prepared reusable function in QTP to use across the automation scripts
      • Involved in Installation testing and Transformation of XML documents using XSLT.
      • Experienced in writing complex SQL queries for extracting data from multiple tables.
      • Review the test cases written based on the Change Request document.
      • Preparation of System Test Results after Test case execution.
      • Interacting wif developers for the Bug Fixes and Problem resolution.
      • Involved in preparing Daily status report Proficient wif various SSIS Parallelism and Multi File System techniques.
      • Defect Report and requirement traceability using Quality center.
      • Strong experience wif Multifile (MFS) and Serial File (SFS) process, Parallel processes using SSIS.
      • Tested the entire compliance reports generated using Microstrategy BI tool by validating the data in the report against the database according to the requirement specifications using SQL.
      • Tested the migration of reports from Microstrategy.
      • Provided weekly management status reports.
      • Executed SQL Queries to check table updates and data retrieval
      • Conducted Data Driven Testing using different sets of external data
      • Reporting defects to development team through the Test Director.
      • Involved in Test Summary Report preparation
      • Used SQL for Querying the DB2 database in UNIX environment.

        Environment: Oracle, DB2, QTP, Test Director, Quality Center, XML, XSLT, SQL, PL/SQL, Unix, Test Cases, Test Scripts, Test Plan, Traceability Matrix, SSIS, Microstrategy.

        Confidential, San Antonio, TX

        ETL Tester

        Responsibilities:

        • Worked wif cross-functional teams to manage defects, compile test results and communicate issues, risks and status on a timely basis to ensure solution meets the business requirements
        • Involved in Functional testing, business requirement testing, data requirement testing, regression testing, system integration testing, data validation, and non-functional testing
        • Analyzed the EDW mapping documents, Dimension tables and fact tables
        • Wrote SQL queries to do the column level verification of the Dimension and Fact tables
        • Involved in testing the data warehouse for both the initial load and the incremental loads of the target
        • Extensively used SQL statements to query the Oracle Database for Data Validation and Data Integrity
        • Involved in the Informatica up-gradation testing to make sure dat the existing, updated and new workflows are working as expected when migrated to Informatica from Informatica 8.6. Created and documented the test plan for the same.

          Environment: Quality center, Informatica, Oracle, TOAD, SQL Developer, UNIX, Windows XP,Internet Explorer, SQL, JIRA, OBIEE, SPOTFIRE,ETL

We'd love your feedback!