Beschreibung
Data Centric testing(L3)-Should ve able to write SQL statements involving complex joins and grouping Should be able to understand the data model Should be able to create test plan based on Mapping document Ability to test at least one ETL (like Informatica or Data Stage) or BI tool (like BO or Crystal Reports) Ability to use a testing management tool.
Testing Concepts(L2)-Debugs software products through the use of systematic tests to develop, apply and maintain quality standards for company products. Develops and executes software test plans. Analyzes and writes test standards and procedures. Maintains documentation of test results to assist in debugging and modification of software. Analyzes test results to ensure existing functionality and recommends corrective action. Consults with development engineers in resolution of problems. Works on problems of relatively complex scope, through general usage of standard programming concepts and principles and application of own judgment. Works as a fully contributing team member, under broad supervision/guidance. Expected to further build upon domain knowledge and technical/proprietary skills to reach levels of expertise. May guide new members in the team to help them scale up faster.
Oracle SQL(L3)-SQL Constructs Ablility to understand and implement Data Types, Basic SQLSELECT Statements, Restricting and Sorting Data, Single-Row Functions, Joins, Aggregate and Group Functions, Sub-Queries, Creating & Managing DB Objects, Manipulating Data (DML), Constraints, Views SQL Query Tuning Basics: Understanding of SQL Tuning concepts like SQL Statement Processing Basics, Explain Plan Basics, SQL Trace and TKPROF Basics, Indexes and Basic Access Methods Basics, Introduction to the Optimizer Basics, Optimizer Hints Basics, Optimizer Hints Basics, Gathering Statistics Basics Adv SQL Basics: Able tounderst and implement Datetime Functions, Advanced Subqueries, Hierarchical Queries, DDL & DML Extensions, Transaction Management Tools Level 1 usage AdvSQL & SQL Tuning Techniques: Ability to implement Tunning Concepts/Techniques like Explain Plan, Access method, Generate SQL Trace and TKPROF report, Forcing Index Hints, Gather Statistics, Managing Optimizer Statistics, Using Indexes, Using Plan Stability, Using Application Tracing Tools, SQL Access Advisor