We provide IT Staff Augmentation Services!

Sr. Etl/qa/dwh Tester Resume

Nyc, NY

PROFESSIONAL SUMMARY:

  • Over 7 years of IT experience in Quality Assurance and Software Testing of various business applications in Client/Server environments, Web based applications, Data Warehousing and Business Intelligence solutions.
  • Excellent working knowledge of System Development Life Cycle (SDLC), Software Testing Life Cycle (STLC) and Defect Life Cycle.
  • Knowledge on the phases of agile methodology and traditional Waterfall methodology.
  • Experienced in Functional testing, System testing, Application testing, Performance testing, Integration testing, Regression testing, Black Box testing, Stress Testing, Smoke testing, Recovery testing, Reports testing, browser compatibility testing, UAT and GUI testing.
  • Expertise in writing Test Plans, Test Strategy, Test Procedures, Use Cases, Test cases, Test scripts, RTMs, Defect status reports and Test Summary report.
  • Proficiency in Defect management, including Defect creation, modification, tracking, and reporting using Industry standard Tools like HP Quality Center and Rational Clear Quest.
  • Expert in writing complex SQL queries for back - end and Reports data validations.
  • Adept on database query tools such as TOAD, SQL Navigator, SQL Assistant and SQL Plus and SQL Developer.
  • Experience in maintaining the test environments; involved in requesting the deployments, requesting data loads, data base backups, restarting the servers, troubleshooting issues.
  • Tested several complex Reports generated by IBM Cognos, Business Objects BOXI, Micro Strategy including Dashboards, Summary reports, Master detailed, Drill down and Score cards.
  • Experience in testing the reports for both cosmetic static content and data validations as per Report specification documents.
  • Experience on UNIX commands and Shell Scripting.
  • Thorough knowledge on data warehouse testing strategies including - Data Analysis, Data Cleansing (Scrubbing), Data Validation and Verification, Data Conversion, Data Migrations and Data Mining.
  • Expert level skills in testing Enterprise Data Warehouses using Informatica Power Center, DataStage, Ab Initio and SSIS ETL tools.
  • Expertise in testing reconcile (initial) and delta (daily) loads.
  • Experienced in using the Oracle SQL* Loader features for loading the data from Flat Files to Data Base tables for Bulk Loading.
  • Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.
  • Excellent interpersonal, communication, documentation and presentation skills.

TECHNICAL SKILLS:

Operating Systems: Windows 2000/NT/XP/Vista, UNIX (Linux, Sun Solaris, IBM AIX)

Languages: SQL, PL/SQL, XML, HTML

Automation Tools: QTP

Scheduling Tools: Autosys, Control M

ETL Tools: Informatica 9x, 8x, Ab Initio (GDE 1.15, Co>Op 2.15), SSIS, Data Stage

Query Tools: Toad 7.4/8.3.6, SQL Query Analyzer, SQL Plus, SQL Studio Manager, SQL Loader

Databases: Oracle 11g, SQL Server, DB2, Teradata

PROFESSIONAL EXPERIENCE:

Confidential, NYC, NY

Sr. ETL/QA/DWH Tester

Responsibilities:

  • Worked with Business analysts to understand Business/System requirements in order to transform business requirements into functional test cases.
  • Developed Data warehouse ETL test cases using data dictionary/mapping documents to validate data integrity, data transformation covering mapping, transformations and business rules.
  • Used ALM/Quality Center for writing Test Plan, Test Cases development, test script writing, Test case execution & Defect Tracking
  • Involved in the error checking and testing of the ETL procedures & programs Informatica session log.
  • Strong ability in developing advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements.
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Created slides for explaining data flow and process flows using PowerPoint and Microsoft Visio
  • Tested data and format of the reports and the universe
  • Used all Teradata utilities including Fast Load, Multi Load, Fast Export, SQL Assistant, BTEQ & TPUMP
  • Loaded data to different databases using SQL scripts and maintained a repository for data loading scripts.
  • Validated the Data warehouse ETL Informatica scripts for data conditioning, transformation, validation and loading.
  • Performed smoke and sanity testing while deploying the reports from Dev system to QA to prod box.
  • Tested Sets, Metrics, Productive Analysis and Enterprise Performance Management (Scorecard and Dashboard).
  • Involved in understanding the service request and making the relevant changes to the Business Objects universe and reports functionality.
  • Designed and developed UNIX shell scripts as part of the ETL process to automate the process of loading, pulling the data for testing ETL loads.
  • Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
  • Tested Canned/Ad-hoc reports using Business Objects Reporter functionalities.
  • Performed data validation by writing SQL queries and creating ad hoc reports using desktop intelligence and web intelligence
  • Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects.
  • Written several shell scripts using UNIX Korn shell for file transfers, archiving the existing files, catalog creation, error log creations and log file cleanup process.

Environment: Data warehouse ETL Informatica 9.1, Teradata 13, Teradata SQL Assistant, .Net, Business Objects Enterprise XI R3, Business Objects Designer, HP ALM/Quality Center.

Confidential, Edgewood, NY

QA Engineer

Responsibilities:

  • Extensively involved in Developing Test Plans, Test Scenarios, Test Strategies and Test Cases with inputs from the assigned Business Analysts.
  • Responsible for validation of Target data in Data Warehouse and Data Marts which are Transformed and Loaded using ETL Informatica Power Center.
  • Developed test scripts based upon business requirements and processes, in line with defined workflows and use cases. Processed transactions from system entry to exit. Tested functionality across applications and workflows.
  • Built a library of test cases for regression testing and automated them using QTP
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata,
  • Involved in validating SSIS and SSRS packages according to functional requirements.
  • Involved in testing designing and development of Data warehouse environment.
  • Expertise in writing SQL Statements in database to make sure whether the data is populated in Data Mart/Data warehouse According to Business Rules.
  • Worked on Autosys for Batch Processing ETL, PL/SQL subprograms and performed backend testing.
  • Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for reporting purposes.
  • Written and executed the functional and regression test script using Test Script QTP.
  • Involved with ETL test data creation/Identified for all the ETL mapping rules.
  • Stimulated several production cycles. Worked with data validation, constraints, record counts, and source to target, row counts, random sampling and error processing.
  • Tested reports developed by Business Objects Universes for both Adhoc & Canned Reporting users of Business Objects XI R3
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Involved in extensive DATA validation on data marts by using SQL queries.
  • Developed test reports and participated in testing prioritization and archived test results and user signoff
  • Used TOAD Software for Querying ORACLE.
  • Validated Business Objects reports by running the SQL queries based on the business rules.
  • Wrote Complex SQL queries to validate the standard reports, Dashboards and Business objects Universes.
  • Validated BO Reports, Dash boards and Universes like Fields present in the report are as agreed in the specifications, Drill down features, Column headings for business sense and familiarity, Display of units along the column headers, Presence of graphs, Report Descriptions, special features like alerts, filters, extraction criteria.
  • Ran workflows created in Informatica by developers then compared before and after transformation of data generated to ensure that transformation was successful.
  • Experience in testing Business Report developed in Business Objects XIR2
  • Prepared and ran regression scripts, shell scripts and performed sanity tests and end-end testing.
  • Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
  • Performed the tests in both the SIT, QA and contingency/backup environments

Environment: Informatica Power center 8.6 (ETL), Business Objects XIR3, HP Quality Center, Rational Clear Quest, Rational Clear Case, QTP,SQL SERVER,SSIS, Toad for Oracle, ORACLE 9i, Unix, Autosys, Windows XP.

Confidential, Eden Prairie, MN

QA Analyst/ Tester

Responsibilities:

  • Created test case scenarios, executed test cases and maintained defects in internal bug tracking systems
  • Developed and executed various manual testing scenarios and exceptionally documented the process to perform functional testing of the application
  • Wrote Complex SQL queries and PL/SQL subprograms to support the test case results, SQL performance tuning.
  • Managed multiple OLAP and Data warehouse ETL projects for various testing needs.
  • Performed extensive Data Validation, Data Verification against Data Warehouse
  • As a Data warehouse ETL Tester responsible for the business requirements, ETL Analysis, ETL test and design of the flow and the logic for the Data warehouse project using Informatica.
  • Tested and validated the Business Objects reports by running similar SQL queries against the source system(s).
  • Creating and executing SQL queries to perform Data Integrity testing on an Oracle Database to validate and test data using TOAD/Exceed.
  • Tested several Informatica Mappings to validate the business conditions.
  • Performed Backend testing by writing SQL queries and running PL/SQL scripts in TOAD.
  • Design and execute the test cases on the application as per company standards and tracked the defects using HP Quality Center
  • Involved in writing Test scripts for various test scenarios using QTP tool and in creation of Automation frame work.
  • Written Test Cases for ETL to compare Source and Target database systems.
  • Tested ad hoc and canned reports for Business objects.
  • Identifying duplicate records in the staging area before data gets processed
  • Extensively written test scripts for back-end validations
  • Interacting with senior peers or subject matter experts to learn more about the data

Environment: Informatica 8.6.1, Business Objects, Quality Center, QTP, Jira, Teradata SQL Assistant 6.0, Oracle SQL Developer 9i/10g, PL/SQL, MySql, Agile, IBM DB2.

Confidential, Tampa, FL

ETL/QA Tester

Responsibilities:

  • Participate as DE team member to understand changes to the design of database to test the optimum throughput.
  • Tested procedures, functions, triggers, log alerts and batch job generated log files, and user errors.
  • Involved in the error checking and testing of the Data warehouse ETL procedures and programs Informatica session log.
  • Validated the Data warehouse ETL Informatica scripts for data conditioning, transformation, validation and loading.
  • Developed test scripts using SQL and PL/SQL according to the mappings and rules specified in mapping document.
  • Tested complex PL/SQL packages and validated data to verify source to destination as per business logic
  • Designed the Data Driven tests in Quick Test Professional (QTP) script to validate with different sets of test data.
  • Tested a number of complex Data warehouse ETL Informatica packages for initial and daily data loads
  • Developed and Executed Test Plan & Test Script in Quality Center.
  • Used Business Objects OLAP Intelligence to natively access and analyze OLAP servers
  • ETL Informatica process was used to extract data from different source systems to loaded one DB system, generated test cases and test plans to test point to point data conversion and counts and column mapping mechanism. Performing smoke test by running QTP scripts.
  • Tested ad hoc and canned reports for Business objects.
  • Experience in working with Logical model of the business flow, and Entity relationships, constraints and build test cases before the release build is ready.

Environment: Informatica Power Center 8.6.1, BI Business Objects, HP Quality Center 9.2, QTP, VISIO, Teradata V2R6, TOAD, Teradata SQL Assistant 6.0, Oracle 9i/10g, PL/SQL, Agile, IBM DB2.

Hire Now