We provide IT Staff Augmentation Services!

Etl Qa Analyst Resume

2.00/5 (Submit Your Rating)

Cleveland, OH

PROFESSIONAL SUMMARY:

  • Over 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.
  • Experience using query tools for Oracle, Teradata, Sybase, DB2 and MS SQL Server to validate reports and troubleshoot data quality issues.
  • Experience in Pharmaceutical, Financial, Banking, Brokerage, and Securities industries
  • Extensive testing ETL experience using Informatica 8.6.1/8.1/7.1/6.2/5.1 (Power Center/ Power Mart) (Designer, Workflow Manager, Workflow Monitor and Server Manager)
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
  • Experience in Dimensional Data Modeling using Star and Snow Flake Schema.
  • Extensive knowledge and experience in producing tables, reports, graphs and listings using various SAS procedures and handling large databases to perform complex data manipulations.
  • Experience in testing and writing SQL and PL/SQL statements.
  • Expert in writing Test Plan, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.
  • Tested the reports generated by OBIEE and verified and validated the reports using SQL.
  • Extensive experience in testing and implementing Extraction, Transformation and Loading of data from multiple sources into Data warehouse using Informatica.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
  • 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.
  • Has expertise in Test Case Design, Test Tool Usage, Test Execution, and Defect Management.
  • 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.
  • Good experience in Cognos & Business Objects Reports testing
  • Experience in Performance Tuning of SQL and Stored Procedures.
  • Experience in all phases of Software Development life cycle.
  • Application Data warehousing experience in Banking, Pharmaceutical and Insurance.
  • Performed Unit, Integration and System Testing.
  • Good analytical and problem solving skills.
  • Team player wif excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
  • Expert knowledge in UNIX shell scripting (Korn shell/Bourne shell)
  • Team oriented and ability to understand and adapt to new technologies and environments faster. Good at analysis and troubleshooting.
  • Excellent analytical, programming, written and verbal communication skills.

TECHNICAL SKILLS:

Data Warehousing: Informatica 8.6.1/8.1/7.x, Data Stage 8.x

Reporting Tools: Business Objects, OBIEE, XIR3, Cognos 8 Suite, Crystal Reports

Data Modeling: Star-Schema Modeling, Snowflake-Schema Modeling, FACT and dimension tables, Pivot Tables, Erwin

Testing Tools: Win Runner, Load Runner, Test Director, Mercury Quality Center 9.1, ALM 11

RDBMS: Oracle 9.1.0/8i/7.x, MS SQL Server 6.5/7.0, 2000, UDB DB2, Sybase, SQL Server 12.0/11.x, MS Access 7.0

Programming: UNIX Shell Scripting, Korn Shell, C Shell, Bourne Shell, Bash, SQL, SQL*Plus, PL/SQL, TOAD, C++

Web Technologies: JavaScript, HTML 4.0, and DHTML, Java, J2ee

PROFESSIONAL EXPERIENCE:

Confidential, Cleveland, OH

ETL QA Analyst

Responsibilities

  • Analyzed business requirements to identify testable requirements.
  • Used HP Quality Center to track and report system defects and bugs, writing modification request for the bugs in the application and helped developers to track the problem and resolve the technical issues.
  • Wrote SQL queries to validate that actual test results match wif expected results check the naming standards, data integrity and referential integrity.
  • Validating the load process of ETL to make sure the target tables are populated according the data mapping provided that satisfies the transformation rules.
  • Writing complex SQL queries using Case Logic, Intersect, Minus, Sub Queries, Inline Views, and Union in Oracle.
  • Designed, updated and reviewed Test Cases.
  • Involved in coordinating the Black box testing for the data warehouse by checking ETL procedures/mappings.
  • Involved in Integration testing, Functional testing and Regression testing.
  • Validated data in source and target databases using SQL scripts.
  • Tested the modified STMs due to source system updates.
  • Involved in conducting data validation and data integration tests.
  • Involved in integration testing for comparing the results from source data to the target data.
  • Validated the data in TEST and QA Environments.
  • Performed Data Driven Testing for multiple sets of data.
  • Performed Regression, Integration testing of the application.
  • Executed complex SQL queries & validated data against source tables and datamart tables.
  • Data mismatches & issues reported to Business Analyst as Defects.
  • Closely worked wif the developers to resolve the issues and defects.
  • Created sql scripts to test many different business critical path and complete end-to-end data driven test.
  • Created test scripts to do positive / negative tests.
  • Used database tool, Toad to analyze data and execute SQL queries.
  • Involved in Daily/Weekly Project status Meetings.

Environment: Informatica 8.6, Toad for Oracle 9.1.0, Quality Center 9.0, ALM 11, SQL

Confidential, Portland, OR

ETL Tester

Responsibilities:

  • Prepared extensive set of validation test cases to verify the data
  • Developed Test Plan and Test Cases using HP Quality Center to test the application for the new code.
  • Studied and understood the Data warehouses, and functionally analyzed the application domains, involved in various knowledge transfers from dependent teams understand the business activities and application programs and document the understandings for internal team referencing.
  • Prepared the test plans and test cases for different functionalities involved in the application.
  • Used Quality Center as the test management tool for the maintenance of the test cases and to track the defects.
  • Coordinated wif Release Management team in getting our jobs executed in Test environment (Autosys)
  • Performed the Smoke, Functional testing, Ad Hoc testing and Regression testing of the application.
  • Involved Extensively during UAT testing of various functionalities along wif the implementation team, resolved the issues and problems.
  • Submitted Status and Test Evaluation Reports to Project Lead on daily basis and Constantly updated test deliverables
  • Execute and analyze complex test cases and compare the results wif expected results and product requirements.
  • Promoted Unix/Informatica application releases from development to QA and to UAT environments
  • Performed Regression Testing of the effected test cases to confirm that the defect has been resolved when defect corrections are delivered in a build.
  • Extensively tested several OBIEE reports for data quality
  • Written several SQL statements. Tested the output of Statements from sql vs. ETL output.
  • Involved in backend testing for the front end of the application using SQL Queries in Teradata data base.
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Performed all aspects of verification, validation including functional, structural, regression, load and system testing
  • Queried databases using SQL queries in TOAD and SQL Server Management Studio to validate the data loaded into target tables.
  • Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications.
  • Report testing: Extensive experience wif Reporting Tools like OBIEE
  • Performed front-end testing on OBIEE Executive Dashboard portal
  • Performed data analysis and data profiling using SQL and Informatica Data Explorer on various sources systems including Oracle and Teradata
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • scheduled various etl batch processes using Autosys
  • Used TOAD Software for Querying ORACLE and Used WinSQL for Querying DB2..
  • Experience in loading from various data sources like Teradata, Fixed Width and Delimited Flat Files.
  • Extensively used Control - M to schedule the jobs and run the scheduled jobs at specific time.
  • Involved in Data Extraction from Teradata and Flat Files using sql assistant.
  • Interacted wif Users to understand the bugs in Business Reports generated from OBIEE
  • Involved in extensive DATA validation using SQL queries and back-end testing

Environment: Quality Center 10.0, OBIEE,Oracle 10g, Informatica 8.6.1/8.1, Teradata V2R6, Teradata SQL Assistant 12.0, Autosys, UNIX, Control-M job Scheduler

Confidential, Atlanta GA

ETL QA Tester

Responsibilities:

  • Responsible for Business analysis and requirements gathering.
  • 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.
  • Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • Written several shell scripts using UNIX Korn shell for file transfers and clean up process.
  • Tuned ETL jobs/procedures/scripts, SQL queries, PL/SQL procedures to improve the system performance
  • Tested all OBIEE Dashboards according to the requirement
  • participated in manual functional testing and automation using Autosys
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Wrote SQL and PL/SQL scripts to perform database testing and to verify data integrity.
  • Extract data from Mainframe data sets to compare against Target Values.
  • Reported bugs and tracked defects using Quality Center 10.0
  • Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked wif data quality issues.
  • Executed the Test Scripts in TOAD and documented the results in RTM.
  • Involved in testing of Universes from different data sources like Oracle/SQL Server.
  • Used various @Functions like @Prompt (for user defined queries), @Where (For creating conditional filters), and @Select.
  • Involved in Writing Detailed Level Test Documentation for reports and Universe testing.
  • Tested the reports like Drilldown, Drill Up and Pivot reports generated from OBIEE
  • Involved in data warehouse testing by checking ETL procedures/mappings.
  • Performed the tests in both the SIT, QA and contingency/backup environments
  • Performed all aspects of verification, validation including functional, structural, regression, load and system 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.
  • Tested SQL to extrapolate data from the Autosys database to populate a spreadsheet
  • Experience in data analysis and data testing and verified fields present in the reports are as agreed in the ETL specifications
  • Responsible for Extracting and Importing clinical data like prescription, adverse event records, laboratory records from Oracle database and other sources into SAS datasets using SAS/ACCESS SQL Pass-Through facility, Proc Import and Import Wizard.
  • 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
  • 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
  • Extracted data from Oracle and upload to Teradata tables using Teradata utilities FASTLOAD.
  • Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
  • Tested several data migration application for security, data protection and data corruption during transfer
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.
  • 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.
  • Involved in the error checking and testing of the ETL procedures and programs Informatica session log.
  • Analyzed the data and applied relevant transformations and verified that the source data types are correct.
  • Involved in creating source target mappings based on the Technical Design requirements.
  • Used different sources for Input.
  • Extensively used Mercury Quality Center (TEST DIRECTOR) and Created Test Cases in the TEST PLAN according to the specification
  • Tested all OBIEE Dashboards according to the requirement
  • Applied appropriate validation rules and created graph parameters to check the validations are correct so that the graph should stop.
  • Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
  • Created lookup files where necessary for validation of critical enterprise codes, lender identifiers and service numbers.
  • Compared the data sets resulted from the databases Oracle and SQL Server using the tool, Toad for Data Analysts.
  • Involved in testing the OBIEE reports by writing complex SQL queries.
  • Created different user defined functions for applying appropriate business rules
  • Worked on test data and completed unit testing to check all business rules and requirements are met. Also tested for negative data to check that the job fails on any critical error.

Environment: Quality Center 10.0, SQL, TOAD, PL/SQL, OBIEE, Informatica Power Center,, XML Files, Flat Files, Teradata V2R6, Autosys, Teradata SQL Assistant 12.0, COBOL II, UNIX, Oracle 10G, DB2, Shell Scripting, PERL

Confidential, San Leandro, CA

DWH/Backend 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
  • External interactions wif NSCC, DTCC, NFS and various fund companies in which MMLISI is associated.
  • Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies wat data will be extracted from an internal data warehouse, transformed and sent to an external entity.
  • Involved in Teradata SQL Development, Unit Testing and Performance Tuning
  • Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
  • Created the test environment for Staging area, loading the Staging area wif data from multiple sources.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mapping
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Written several complex SQL queries for validating Cognos Reports.
  • Tested several stored procedures.
  • Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
  • 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 wif 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 wif business team to test the reports developed in Cognos
  • Tested whether the reports developed in Cognos are as per company standards.
  • 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.
  • Responsible for creating test cases to make sure the data originating from source is making into target properly in the right format.

Environment: Informix, DB2, Java, Cognos, SQL, Teradata V2R6 (MLOAD, FLOAD, FAST EXPORT, BTEQ), Teradata SQL Assistant 6.0, XML, TOAD, IBM AIX 5.3, UNIX, Shell Scripting, WINSQL, Ultra edit, Oracle 8i/9i, DB2, SQL Server 2000, Mainframe, SunOS 5.8, XML, DTS, ERWIN, Windows XP, Quality Center 9.0

Confidential, Manhattan, New York

Database Tester/Analyst

Responsibilities:

  • Created PL/SQL procedures, triggers, views, functions.
  • Gathered information about the transaction process, planning and development of the various screens.
  • Responsible for designing database tables and writing SQL & PL/SQL procedures, functions.
  • Developed various forms (screens) and some complex reports.
  • Generated expected liability sheet containing loan no, name, amount disbursed, no of installments, gestation period.
  • Written complex SQL queries for each level of data validation.
  • Involved in creating both positive and negative test data to cover all business scenarios
  • Involved in developing detailed test plan, test cases and test scripts for Functional, Security and Regression Testing.
  • Written Test Scripts based on the Business requirements and executed Functional testing and data validation, data reconciliation wif defect correction and retesting, followed by regression and performance testing.
  • Involved in extensive DATA validation using SQL queries and back-end testing
  • Used SQL for Querying the DB2 database in UNIX environment
  • Generated daily transaction reports wif transaction no, loan no, borrower's address, particulars, credit, debits liability.

Environment: Oracle 7.x, Visual Café, Rational Rose, Clear Case, Clear Quest, Windows 2000

We'd love your feedback!