We provide IT Staff Augmentation Services!

Sr. Etl/qa/dwh Tester Resume

2.00/5 (Submit Your Rating)

WI

PROFESSIONAL SUMMARY

  • 7+ 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
  • Solid Back End Testing experience by writing and executing SQL Queries
  • Excellent testing experience in all phases and stages of Software Testing Life Cycle and Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling
  • Expertise in creating Test Plan documents and developing test strategy documents and preparing the Traceability Matrices
  • Highly experienced in all levels of Testing such as Black Box Testing, Positive Testing, Negative Testing, Integration Testing, ETL Testing,Functional Testing, System Testing, Regression Testing, Stress Testing, User Acceptance Testing (UAT) and GUI Testing.
  • Good understanding of Database Management Systems like Oracle, SQL Server, Teradata, DB2.
  • Expertise in designing the test scenarios and scripting the test cases in order to test the application
  • Expert in PERL, UNIX Shell Scripting & SQL writing for several technology needs
  • Involved in Developing Data Marts for specific Business aspects like Marketing & Finance
  • Creation of test data and Automation of test cases for system and analyzing bug tracking reports
  • Expertise Shell Scripting experience on UNIX, Linux and Windows environment
  • Generated Test Scripts executed Smoke Test, Functional Testing, ETL Testing and RegressionTesting.
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting
  • Experience in UNIX shell scripting and configuring cron - jobs for ETL Loads
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using ETL tools like Informatica and Data Stage
  • Good working experience inOracle, Unix ShellScripting
  • Extensively strong on databases including Oracle, MS SQL Server, and Teradata
  • Strong in testing Stored Procedures, Functions, Triggers and packages utilizing PL/SQL
  • Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with UNIX shell wrappers, KSH and Oracle PL/SQL programming
  • Involved in generating Test Scripts using Quick Test Pro (QTP) for different transactions to execute Functional Testing, Regression Testing and Acceptance Testing
  • Experience in testing and writing complex SQL, T-SQL and PL/SQL statements to validate the database systems and for backend database testing

TECHNICAL SKILLS:

Languages: SQL, PL/SQL, C and C++ Concepts, PERL, Test Script Language (TSL),CSS, HTML, VBScript, JavaScript, Shell Scripting

Databases: Oracle 10g/9i/8i, SQL 2005/2008/12, MS Access 2008, Teradata V2R6, DB2 UDB 8.2/8.1, Informix

Reporting Tools: Business Objects XIR2/6.5.1/6.0/5.1.x/4.0 (Supervisor, Designer, Reporter), Cognos 8.0 Series, Crystal Reports, Hyperion Reports 7.x/2.x

Tools: TOAD, Win SQL, Teradata SQL Assistant, BTEQ, XML Spy 2008

Operating Systems: Windows (95, 98, 2000, NT, XP), UNIX

Tools: MS-Office suite (Word, Excel, Project and Outlook)

Testing Tools: Mercury (Quality Center, Win Runner, Load Runner, Quick Test Professional, Performance Center, VU Scripting, Business Availability Center) Rational Test Manager, Rational Robot, RequisitePro, RUP, UML, MS Project, MS Visio & Visual Source Safe

ETL Tools: Informatica 8.1/7.1.2/6.1.X (Repository Manager, Designer, Workflow Manager, and Workflow Monitor), Web Intelligence, Essbase Excel Add-in, DataStage 7.1/8.x, Ab Initio

PROFESSIONAL EXPERIENCE

Confidential, WI

Sr. ETL/QA/DWH Tester

Responsibilities:

  • Involved in understanding Logical and Physical Data model using Erwin Tool
  • Prepared the guides for UAT
  • Prepared Execution procedure document format to prepare the Test cases based on mapping document.
  • Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
  • Ensured that the mappings are correct and Conducted data validation testing
  • Executed Black Box Testing, Positive Testing, Negative Testing, Integration Testing, ETL Testing,Functional Testing, System Testing, Regression Testing, Stress Testing, User Acceptance Testing (UAT)
  • Day-to-day Cognos administration activities like monitoring Scheduled jobs like Cube refresh,
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with business analyst and developers in setting up test data
  • Developed and executed Informatica Workflows and verified the results.
  • Extensively used Informatica Workflow monitor to see session log files and monitor performance of the Workflows.
  • Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP
  • Worked on Commercial lines Property and Casualty Insurance including both policy and claim processing and reinsurance.
  • Verify the ETL process by running the Informatica workflows (both from Informatica Workflow Manager and through UNIX scripting), monitor the status in Informatica Monitor and verify logs
  • Performed Black Box, Positive, Regression and Negative testing for all the assigned processes
  • Executes the test suite to identify regressions and unexpected side effects
  • Performed black box/functional testing, regression testing on Application Under Test
  • Worked with business team to test the reports developed in Cognos
  • Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
  • Extensively test the reports for data accuracy and universe related errors
  • Experience testing data conversions and migrations in cross platform scenarios Informatica power center
  • Performed Teradata SQL Queries, creating Tables, and Views by following Teradata Best Practices.
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning
  • Tested several dashboards and deployed them across the organization to monitor the performance
  • Used SQL tools to run SQL queries and validate the data loaded in to the target tables
  • Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
  • Performed Functional Testing, Regression Testing, Volume, and Stress testing
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • Tested several Cognos Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Written extensive UNIX Shell scripting for error logging, cleanup, data archiving & job scheduling
  • Preparing manual test cases and test data for Scenarios
  • Manually conducted Positive/Negative and Smoke Testing.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Implemented SDLC, QA methodologies and concepts in the Project
  • Tested whether the reports developed in Cognos are as per company standards.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Created and executed Test scripts for system validation and user acceptance testing (UAT)
  • Did database backup and recovery mechanism using PERL
  • Used PERL for automating all the types of modules at a time and Responsible for testing the reports according to client’s requirement using Cognos.
  • Created ETL execution scripts for automating jobs
  • Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ and TPUMP
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Tested Analytical Data Mart (ADM) of Oracle system and Stored Procedures
  • Tested Operation Data Store process of ODS/DWL product
  • Used workflow manager for session management, database connection management and scheduling of jobs

Environment: Informatica 9.1, XML, XSLT, XPath, property and casualty, XQuery, SQL Server 2008, ALM/Quality Center 11, DTS, SSIS, T-SQL, SQL, Teradata 13.0, Oracle 11g, PL/SQL, IBM DB2, Cognos 8.4, PERL, MS Access, Flat Files, Korn Shell Scripting

Confidential, Charlotte, NC

ETL/QA/DWH Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
  • Created test data for testing specific Membership functionality
  • Performed Functional, Negative, Positive, Integration, Regression, Ad hoc, End to End, Smoke and
  • User Acceptance Testing
  • Experience in testing many multi-layer data warehouse on Unix, Windows and Teradata systems
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments as required
  • Extracted certain column of data from a number to files using PERL
  • Used PERL for automating all the types of modules at a time
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with PERL for file manipulations, text processing, data parsing and Converted SQL queries results into PERL variable
  • Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
  • Extraction of test data from tables and loading of data into SQL tables
  • Extracted certain column of data from a number to files using PERL
  • Used PERL for automating all the types of modules at a time
  • Created test scripts using LoadRunner tool and performed interface, functionality, and regression testing on new builds of the software
  • Written several complex SQL queries for validating Cognos Reports
  • Responsible for Data mapping testing by writing complex SQL Queries using WINSQL
  • Experience in creating UNIX scripts for file transfer and file manipulation
  • Validating the data passed to downstream systems
  • Worked with data validation, constraints, source to target row counts
  • Developed automated Test Scripts using QTP
  • Involved in Smoke Testing, Functional Testing, Positive testing, Negative Testing, Regression Testing, Database Testing and Webservices Testing
  • Involved in Data Extraction from Teradata and Flat Files using sql assistant.
  • Used data conversion to Protect the data and prevent data loss
  • Strong in writing sql queries and makes table queries to profile and analyze the data in MS Access
  • Created macros to automate the process of refreshing the data in MS Access
  • Provided technical support and coaching to team members about functionality of MS Access
  • Worked with Data Extraction, Transformation and Loading (ETL)
  • Involved in testing data mapping and conversion in a server based data warehouse
  • Involved in testing the UI applications
  • Involved in Security testing for different LDAP roles
  • Worked with business team to test the reports developed in Cognos
  • Used Quality Center to track and report system defects
  • Involved in testing the XML files and checked whether data is parsed and loaded to staging tables

Environment: Informatica 8.6.1, Informix, DB2, Java, Cognos, SQL, SQL Server 2008, PERL, Teradata 12, XML, XSLT, XML Spy 2008, IBM AIX 5.3, UNIX, Shell Scripting, QTP,WinSQL, Ultra editor, Rumba UNIX Display, Quality Center 9.0

Confidential, NYC, NY

QA Analyst/Data Warehousing Tester

Responsibilities:

  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
  • Develop test plans based on test strategy. Created and executed test cases based on test strategy and test plans based on ETL mapping document
  • Written complex SQL queries for querying data against different data bases for data verification process
  • Performed UAT testing
  • Involved in developing test cases to test Teradata scripts (Bteq, Multiload, fast load).Updated the status of the testing to the QA team, and accomplished tasked for the assigned work to the Project Management team regularly
  • Designed the data flow diagrams using VISIO
  • Prepared the Test Plan and Testing Strategies for Data Warehousing Application
  • Preparation of technical specifications and Source to Target mappings
  • Extensively used SQL programming in backend and front-end functions, procedures, packages to implement business rules and security
  • Written test cases to test the application manually in Quality Center and automated using Quick Test Pro
  • Analyzed SQL code to ensure Business Objects queries the correct data from the database
  • Defects identified in testing environment where communicated to the developers using defect tracking tool Mercury Test Director
  • Developed scripts, utilities, simulators, data sets and other programmatic test tools as required executing test plans
  • Proficient experience in different Databases like Oracle, SQL Server, DB2 and Teradata
  • Tested a number of complex ETL mappings, mapplets and reusable transformations for daily data loads
  • Extensively used Informatica power center for extraction, transformation and loading process
  • Creating test cases for ETL mappings and design documents for production support
  • Setting up, monitoring and using Job Control System in Development/QA/Prod
  • Extensively worked with flat files and excel sheet data sources. Wrote scripts to convert excel to flat files
  • Scheduling and automating jobs to be run in a batch process
  • Effectively communicate testing activities and findings in oral and written formats
  • Reported bugs and tracked defects using Test Director 6.5
  • Worked with ETL group for understating mappings for dimensions and facts
  • Extracted data from various sources like Oracle, flat files and SQL Server
  • Worked on issues with migration from development to testing
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic

Environment: PERL, UNIX Shell Scripting, Oracle, Informatica Power Center 8.1,Teradata, QTP, SQL *Loader, Cognos 7.0 Series, Oracle8i, SQL Server 2000, Erwin 3.5, Windows 2000, TOAD 7, PL/SQL

Confidential

ETL/QA Analyst

Responsibilities:

  • Involved in Design and development of test plans based on high-level and detailed designs
  • Analyzed the use cases given by the business analysts and developed test cases using them
  • Responsible for complete manual testing of application under test (UAT)
  • Written complex SQL queries for data validation and to verify the extract rules
  • Tested several Datastage ETL jobs and ran on UNIX for loading purpose and checking the log files
  • Performed manual testing on various modules of the Application
  • Generates functional test cases that capture actual code behavior as a deployed application is exercised
  • Did extensive backend testing using SQL, UNIX and PL/SQL
  • Written PERL scripts for text processing, database connectivity & data parsing
  • Written complex SQL queries for data validation and data verification
  • Parameterizes test cases for use with varied, controlled test input values (runtime-generated, user-defined, or from data sources)
  • Worked with Data Completeness, Data Transformation, Data Quality, Integration testing, UAT and Regression testing for all ETL feeds
  • Monitors test coverage and achieves high coverage using branch coverage analysis
  • Tests individual methods, classes, or large, complex applications
  • Tracks how test results and code quality change over time
  • Conducted performance and load testing using Load Runner
  • Analyzed, reported and kept track of defects using Test Director

Environment: Datastage 6.5, Windows NT, Shell Scripting, MS-Office Tools, SQL, PL/SQL, XML, XSLT, Web Services, SOAP, Manual Testing, Test Director, Load Runner, Oracle, Java, Servlets and Java Script

We'd love your feedback!