We provide IT Staff Augmentation Services!

Dwh Qa Sql Tester Resume

San Jose, CA

PROFESSIONAL SUMMARY:

  • Over 8 years of IT experience in the Analysis, 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.
  • Extensively used ETL methodology for testing and supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution using Informatica
  • Experience in testing and writing SQL and PL/SQL statements.
  • Expert in writing Test Plan, Test Cases, Test Matrix, Traceability Matrix and Test Scripts.
  • Experience in testing Business Intelligence reports generated by various BI Tools like Cognos and Business Objects
  • 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.
  • Good experience in Data Modeling using Star Schema and Snow Flake Schema
  • 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 with excellent Organization and Interpersonal skills and ability to work independently and deliver on time.
  • 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:

Reporting Tools: MicroStrategy, Cognos, Crystal Reports, SSRS

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

Testing Tools: Win Runner, Load Runner, Test Director, ALM/Quality Center

RDBMS: Oracle, MS SQL Server, UDB DB2, Sybase, SQL Server, MS Access

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

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

PROFESSIONAL EXPERIENCE:

Confidential, San Jose, CA

DWH QA SQL Tester

Responsibilities:

  • Validating the messages flow in IBM MQ service bus from EDM to ESB
  • Validating the EDM and ESB integrations flow, work with downstream application to name few SAP, FoodStar, etc. provide the required input to them.
  • Validating developed software solutions using technologies such as SAP, Retalix, Informatica-MDM, BPM and JAVA Enterprise Service Bus service
  • Gather Test requirements from SME’s and BA’s and draw out a plan for releases of the requirements and enhancements for the application requested by the users and planning work for subsequent releases.
  • Creating a detailed Test Strategy and Test plan for the project, Design Test Scenarios for the requirements. Review the Test senarious with the SME’s and business users.
  • Validating the databases designed in Microsoft SQL server and ORACLE by utilizing SQL Server Management Studio and Informatica Power Center.f
  • Tested data quality for MDM, customer data integration and Match-Merge process
  • Performing User Acceptance Testing (UAT) from test case design to execution and defect tracking, reviewing, analyzing, and closing.
  • Experience installing and configuring IBM InfoSphere Change Data Capture, IBM WebSphere MQ for data replication subscriptions.
  • Strong understanding on Hadoop and various components such as HDFS, Map Reduce, HBase, Hive, Pig, Flume, Sqoop
  • Worked on Integration of Big data and cloud platforms Using Talend.
  • Involved in understanding Logical and Physical Data model using Erwin Tool
  • Setup HP ALM for the project with Users, access rights, folders structures, workflows and reports.
  • Analyze the changes to requirements throughout the project.
  • Tested the data acquisition, data transformation and data cleansing approach for the MDM implementation.
  • Worked on Hadoop Schema design, involved in file uploads from UNIX/LINUX file system to Hadoop Distribute File System Environment.
  • Develop the requirement traceability matrix to map the requirements to test cases, Defining test methodology to carry out the development schedule.
  • Allocate the Test scenarios & scripts to Test Analysts for Test design and Test execution. Review and finalyse the test cases and Test scripts that are designed.
  • Performed Installation, Implementation and Support using IBM Infosphere Data Mirror/Change Data Capture and Change Data Delivery.
  • Experience in managing and reviewing Hadoop log files.
  • Work with team to ensure test environments are setup and test data are available for test execution
  • Allocate the Test cases for Execution. Monitor and track the progress of Test execution and the various cycles involved.
  • Test newly developed features to ensure proper functioning prior to release to QA for multiple MDM processes
  • Implementing logical and physical data modeling with STAR schema using Erwin in Data Marts
  • Chair the Defect Triage meeting with the various stakeholders and resolving defect clarifications raised.
  • Interacting with onsite and offshore team in resolving their problems.
  • Regular interaction with the offshore team manager/leader and Quality Assurance using the proprietary tools.
  • Preparing and sending out the weekly status report to the client.

Enivironment: Solution Manager, SAP (FI/CO, SD, MM, WM), Retalix Product suite, SAP - TAO, HP ALM, HP Unified Functional Tester, HP - PC, Selenium scripting, Rational Functional Tester and Rational Performance Tester, Informatica Power Center, MSSQL, Oracle, IBM Infosphere, MQ/IIB

Confidential, Boston, MA

DWH QA SQL Tester

Responsibilities:

  • Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
  • 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 ALM/Quality Center
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • Experienced working with Customer Information Data Mart for business reporting thru MDM and Reference Data
  • Tested several complex reports generated by Cognos including Dashboard, Summary Reports, Master Detailed, Drill Down and Score Cards
  • Comparing/analyzing mainframe test data with the front end.
  • Build DataStage jobs on IBM Infosphere Information Server
  • Participate in developing test plans, including regression tests, for newly developed features in MDM
  • Involved in testing of Universes from different data sources like Oracle/SQL Server.
  • Tested Facets for Group Information, Enrolling Subscribers, adding members, Related Entities, Class/Plan definition, Premium Rate Tables and all.
  • 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
  • Expertise in Mainframe Performance Testing, Mainframe Batch Testing, Mainframe Load testing and Data Migration testing on Mainframes.
  • Extensively used Informatica power center for extraction, transformation and loading process.
  • Extensively written Teradata SQL Queries, creating Tables and Views by following Teradata Best Practices.
  • Strong Facets member, provider, claims and pricing validations and developed multiple SQL complex join queries.
  • Extensively tested several Cognos reports for data quality, fonts, headers & cosmetic.
  • Trained and mentored the team members at GST on IBM InfoSphere tools.
  • Development of automation Test scripts using Selenium WebDriver framework.
  • Help define and track Data Quality and Data Governance metrics for MDM
  • Worked with Unix for file manipulations, text processing, data parsing and Converted SQL queries results into Unix variable
  • Assisted in creating fact and dimension table implementation in Star Schema model based on requirements
  • Tested MDM platform roadmaps for current vs. future state
  • Involved in creating source target mappings based on the Technical Design requirements.
  • Used different sources for Input.
  • Performed back-end testing, database table manipulations of relational database systems by writing complex SQL queries manually.
  • Strong Informatica and data loading experience
  • Tested the configuration of Medicaid Claims and membership Sub-systems in Facets
  • Defined testing criteria, planned, created and executed test plans in a mainframe environment.
  • Resolved the issues related to IBM InfoSphere Suite products.
  • Tested the reports developed in Cognos against the database
  • Effectively communicate testing activities and findings in oral and written formats.
  • Reported bugs and tracked defects using Quality Center
  • Experience working with Siperian Hub MDM (Master Data management) for customer integration model and tested the same.
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Worked on issues with migration from development to testing.

Environment: Informatica Power Centre, ALM/Quality Center 11, SQL, PL/SQL, XML Files, Flat Files, Teradata, Teradata SQL Assistant, UNIX, Oracle, DB2, TOAD, Mainframe, Cognos, Control-M job Scheduler, IBM Infosphere, Shell Scripting

Confidential, Los Angeles, CA

ETL QA Tester

Responsibilities:

  • Involved in developing detailed test plan, test cases and test scripts using Quality Center for Functional and Regression Testing.
  • 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
  • Solid testing experience in working with SQL Stored Procedures, triggers, views and worked with performance tuning of complex SQL queries.
  • Extract data from Mainframe data sets to compare against Target Values.
  • Help define and track Data Quality and Data Governance metrics for MDM
  • Extracted data from various sources like Oracle, flat files and SQL Server.
  • Monitored the workflow transformations in Informatica work flow monitor
  • Used Facets to provide seamless transactions between the provider, members and the plan
  • Tested different master detail, summary reports, ad-hoc reports and on demand reports using Cognos Report Studio.
  • Built Automation Framework using Selenium WebDriver
  • 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 with non-transactional data entities for multiple feeds of reference data using Master Data Management
  • Manually performed User Acceptance Testing of FACETS implementation.
  • Tested several UNIX Shell Scripts and for connecting to database and for file manipulation of data
  • Identifying the Test Cases to be automated and developed automation test scripts using Selenium Web
  • Directly used backend servers, like Mainframes, DB2 and SQL Server for Backend Testing and other validations.
  • Created ETL test data for all ETL mapping rules to test the functionality of the Informatica Mappings.
  • Did source identification, data collection, data manipulation and normalization and rule administration for data consolidation using MDM
  • Extensively used Teradata load utilities Fast load, Multiload and FastExport to extract, transform and load the Teradata data warehouse
  • Written SQL scripts to test the mappings and extensively used Cognos for report generation
  • Responsible for different Data mapping activities from Source systems to Teradata
  • Queried Teradata Database and validated the data using Sql Assistant.
  • Worked on issues with migration from development to testing.
  • Experienced in writing test cases, test scripts, test plans and execution of test cases Claims data reporting(Cognos) using HP Quality Center
  • Experienced in data analysis using SQL, PL/SQL and many other queries based applications.
  • Involved in developing UNIX Korn Shell wrappers to run various dependency graphs.
  • 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.
  • Written test cases and completed unit test documentation.

Environment: Informatica Power Centre, XML, XSD, UNIX, Teradata, Cognos, Teradata SQL Assistant, Mainframe, SQL, PL/SQL, Oracle, DB2, T-SQL, TOAD, Quality Center

Confidential, NYC, NY

ETL QA Tester

Responsibilities:

  • Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center
  • Involved in Data mapping specifications to create and execute detailed system test plans.
  • Validated various MicroStrateg y reports such as ad hoc, grids, graphs.
  • 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.
  • Extraction of test data from tables and loading of data into SQL tables.
  • Developed and tested all the informatica mappings, sessions and workflows - involving several Tasks.
  • Tested both conditional formatting and threshold level testing for several reports developed in Microstrategy.
  • Tested the ETL Informatica mappings and other ETL Processes (Data Warehouse Testing)
  • 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.
  • Used Flume-ng to move data from individual data sources to Hadoop system
  • Involved in testing data mapping and conversion in a server based data warehouse.
  • Involved in testing the UI applications
  • Extensively used MicroStrategy for report generation.
  • Involved in Security testing for different LDAP roles.
  • 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: Informatica Power Centre, DB2, Java, SQL, Teradata, Microstrategy, Teradata SQL Assistant, UNIX, Shell Scripting, WINSQL, Oracle, DB2, SQL Server, XML, Windows XP, Quality Center,.

Confidential

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 with 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
  • Tested the Oracle Applications and Portals like Executive Dashboard, Drill Down, Summary Reports, Portal built on Oracle.

Environment: Oracle, Visual Café, Rational Rose, Clear Case, Clear Quest, Windows

Hire Now