We provide IT Staff Augmentation Services!

Etl/ Qa/ Sql Tester Resume

Richmond, VA

SUMMARY:

  • Around 7+ years of experience testing Web, Client - Server Systems and Applications, Data Warehouse, Database, for various Industries
  • Experienced in analyzing Business Requirements and Specifications. Worked with Development team and Business Analysts to analyze the test scenarios and ensure that test requirements are correct and complete
  • Experience in defining Testing Methodologies; creating Test Plans and Test Cases, Verifying and Validating Application Software and Documentation based on standards for Software Development and effective QA implementation in all phases of Software Development Life Cycle (SDLC)
  • Performed Backend Database testing on Oracle and MS SQL Server databases, used SQL, PL/SQL queries.
  • Good understanding of ETL Test Processes and Test Methodologies.
  • Extensive experience with the Bug tracking systems, source code/version control systems, bugs reporting, root cause analysis, documenting the test results, meeting the delivery schedules.
  • Proficient in Data warehouse and Backend application Testing Life cycle.
  • Involved in rebuild testing of the BI Reports from Confidential to Crystal Reports
  • Strong understanding of Test Methodologies and Test Plans in Project Life Cycles.
  • Experience in preparing Test strategy, Developing Test plan, Test cases, and Writing test Scripts by Decomposing business Requirements and Developing Test scenarios to support quality deliverables.
  • Experience in UNIT Testing, Integration Testing, System Testing Functionality, Regression, Performance Testing and User Acceptance Testing.
  • Expertise in Developing PL/SQL Packages, Stored Procedures/Functions, triggers.
  • Expertise in utilizing Oracle utility tool SQL*Loader and expertise in Toad
  • Good experience in Data Modeling using Star Schema and Snow Flake Schema and well versed with
  • Extensive Working experience in applying Relational Database concepts, Entity Relation diagrams and Normalization concepts.
  • Very good understanding of Data Warehousing concepts, Data Analysis, Data Warehouse Architecture and Designing.
  • Validating data present in the Confidential Reports
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing in a corporate-wide-ETL Solution using Informatica.
  • Ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame
  • Application Data warehousing experience in Banking, Prime Brokerage, Financial, Retail and Insurance.
  • Worked with Automation tools such as QTP for functional, Test Director and Quality center to track the defects.
  • Performed Unit, Integration and System Testing.
  • Good analytical and problem solving skills.
  • Team player with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.

TECHNICAL SKILLS:

ETL Tools: Informatica 8.6.1, Ab Initio (GDE 1.15, Co>Op 2.15)

Databases: Teradata V2R6, Oracle 10g/9i/8i/7.3, MS SQL Server 6.5/7.0/7.5/2005, Sybase12.0/11.0, MS Access

BI/Reporting Tools: Confidential BI 8.0

QA Tools/Bug Reporting: QTP 9.5/9.2/9.0, Rational Clear Quest, Test Director, HP Quality Center, PVCS Tracker, Remedy Tool, MS Access, Bugzilla, Siebel Service Request

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

Operating Systems: Windows, MS-DOS, UNIX, LINUX

Languages: PL/SQL, T-SQL, SQLChange Mgt Tools: Quality Center 10/9.2

PROFESSIONAL EXPERIENCE:

Confidential, Richmond, VA

ETL/ QA/ SQL Tester

Responsibilities:

  • Involved in understanding Logical and Physical Data model using Erwin Tool
  • Prepared the guides for UAT.
  • Extensively used Informatica power center for ETL process.
  • Executed the Test cases for Crystal Reports and Confidential
  • 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
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with business analyst and developers in setting up test data
  • Developed several SQL queries for data retrieval from TERADATA and used every utility available in including MLOAD, FLOAD, FAST EXPORT, BTEQ AND TPUMP.
  • Day-to-day Confidential administration activities like monitoring Scheduled jobs like Cube refresh
  • Extensively used Informatica power center for extraction, transformation and loading proces
  • Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
  • Extensively test the reports for data accuracy and universe related errors
  • Worked on notices and validated PDF notices after executed in RQM
  • Used T-SQL for Querying the SQL Server database for data validation and data conditioning.
  • Written several complex SQL queries for validating Confidential Reports
  • 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.
  • Involved in Unit testing and integration testing of Informatica mappings
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • 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.
  • Worked with business team to test the reports developed in Confidential
  • Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
  • Implemented SDLC, QA methodologies and concepts in the Project
  • 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
  • Tested whether the reports developed in Confidential are as per company standards
  • 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
  • Created ETL execution scripts for automating jobs
  • Tested multi browser application manually and executed in RQM
  • 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.
  • Executed the Test cases for Confidential Reports.
  • Used workflow manager for session management, database connection management and scheduling of jobs

Environment: Informatica 9.1, Confidential, XML, XSLT, XPath, XQuery, SQL Server 2008, ALM/Quality Center 11, DTS, T-SQL, SQL, Teradata 13.0, Oracle 11g, PL/SQL, IBM DB2, Rational Quality Manager (RQM), PERL, MS Access, Flat Files, Korn Shell Scripting

Confidential, Atlanta, GA

ETL/ Data warehouse 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.
  • Used PERL for automating all the types of modules at a time and Responsible for testing the reports according to client’s requirement using Confidential
  • Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate-wide-ETL Solution using Informatica
  • Worked with PERL control structures & Regular Expressions for substitutions based on matches
  • Worked with business analyst and developers in setting up test data
  • Automated and scheduled the Informatica jobs using UNIX Shell Scripting.
  • Extensively tested several Confidential reports for data quality, fonts, headers and cosmetic.
  • Writing complex SQL queries for data validation for verifying the ETL Mapping Rules
  • Extensively test the reports for data accuracy and universe related errors
  • Worked on notices and validated PDF notices after executed in RQM
  • 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.
  • Involved in testing the Confidential reports by writing complex SQL queries
  • Validated the data of reports by writing SQL queries in PL/SQL Developer against ODS
  • Involved in user training sessions and assisting in UAT (User Acceptance Testing)
  • 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
  • Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
  • Implemented SDLC, QA methodologies and concepts in the Project .
  • Tested several Confidential Reports for several business needs including Dashboards, Drill-Down, Master-Detailed, Aggregated, KPI’s and Web Reports.
  • 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
  • Review all functional business applications and specifications.
  • Reviewed Informatica mappings and test cases before delivering to Client
  • Design and analyze all ETL job edition.
  • Validating BEX Reports and Confidential Reports.
  • Created ETL execution scripts for automating jobs
  • Tested multi browser application manually and executed in RQM
  • 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
  • Analyze performance and monitor work with capacity planning

Environment: Oracle 11g, SQL Server 2008,, Informatica, Confidential, SQL,, PL/SQL, IMS, DB2, Stored Procedures, QTP, Quality Center 10.0, Autosys, MS Office Suite, SSRS, HTML, JAVA, JSP, JavaScript, Clear Case, RUP, TOAD, Requisite Pro.

Confidential, Atlanta, GA

ETL/ QA Tester

Responsibilities:

  • Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded
  • Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Developed unit test cases, configured environments and prepared test data for testing.
  • Wrote PL/SQL /Complex SQL queries for system testing.
  • Identified various facts and dimensions from the dimensional logical model with approximately 10 facts, 120 dimensions with more than 500 attributes.
  • Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.
  • Created Short-cut joins, aliases and contexts to make the universe loops free.
  • As QA Tester, performing responsibilities with both the functionality and back end testing.
  • Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
  • Worked with Production environment to resolve several data issues.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
  • Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
  • Tested and worked on creating open document reports for business.
  • 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
  • Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Validated format of the reports and feeds.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Worked on issues with migration from development to testing.
  • Validated cube and query data from the reporting system back to the source system.
  • Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
  • Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
  • Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
  • Extensively involved with backend testing by writing complex SQL queries.
  • Worked closely with the development teams to replicate end user issues.

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

Confidential, East Providence, RI

Backend Tester

Responsibilities:

  • Performed data quality test to determine whether processed data is correctly extracted, transformed and loaded
  • Tested all data reports published to Web including dashboards, summarized, master-detailed and KPI’s.
  • Worked as ETL Tester responsible for the requirements / ETL Analysis, ETL Testing and designing of the flow and the logic for the Data warehouse project.
  • Developed unit test cases, configured environments and prepared test data for testing.
  • Wrote PL/SQL /Complex SQL queries for system testing.
  • Identified various facts and dimensions from the dimensional logical model with approximately 10 facts, 120 dimensions with more than 500 attributes.
  • Worked on Requirements Traceability Matrix to trace the business requirements back to logical model.
  • Created Short-cut joins, aliases and contexts to make the universe loops free.
  • As QA Tester, performing responsibilities with both the functionality and back end testing.
  • Wrote SQL, PL/SQL Testing scripts for Backend Testing of the data warehouse application.
  • Worked with Production environment to resolve several data issues.
  • Experience in integration of various data sources with Multiple Relational Databases like Oracle, SQL Server, MS Excel, MS Access and Flat Files.
  • Develop ETL test plans based on test strategy. Created and executed test cases and test scripts based on test strategy and test plans based on ETL Mapping document.
  • Tested and worked on creating open document reports for business.
  • 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
  • Experienced using query tools for Oracle to validate reports and troubleshoot data quality issues.
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Validated format of the reports and feeds.
  • Effectively communicate testing activities and findings in oral and written formats.
  • Worked with ETL group for understanding Ab Initio graphs for dimensions and facts.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Designing and creation of complex mappings using SCD type II involving transformations such as expression, joiner, aggregator, lookup, update strategy, and filter.
  • Optimizing/Tuning several complex SQL queries for better performance and efficiency.
  • Created various PL/SQL stored procedures for dropping and recreating indexes on target tables.
  • Worked on issues with migration from development to testing.
  • Validated cube and query data from the reporting system back to the source system.
  • Designs and directs the preparation of test data; prepares test data, documents detailed results, provides regular and ad-hoc test reports.
  • Experience in data analysis and data testing. And verified fields present in the reports are as agreed in the ETL specifications.
  • Execute the Unix Shell Scripts to Know the Backend Batch Jobs Status
  • Extensively involved with backend testing by writing complex SQL queries.
  • Worked closely with the development teams to replicate end user issues.

Environment: Ab Initio (GDE 1.12, Co>Op 2.12), EME, SQL *Loader, XIR2, PL/SQL, SQL, Stored Procedures, Test Cases, Test Scripts, Test Plan, Oracle8i/9i, SQL Server 2000/2005, Erwin 3.5/4.1, Windows 2000, TOAD 7

Hire Now