*Sr./Lead Data Centric Testing* *Schaumburg, IL*
*Job Description:* Experience in Data Warehouse ETL Testing; Very Good SQL knowledge & Data Base management skills; Communication and client management; Able to independently perform test lead role and coordinate with offshore for test planning, test case preparation & execution deliverables; Reporting & Test Summary knowledge Skill and Experience Details: -->Application Testing(L3)-Should be able to differentiate the different testing phases like UnitIntegration, System, Acceptance, Regression testingand should be capable to perform these tests with the help of ready-test cases.Should understand Test Plans, Requirement TraceabilityMatrix, Orthogonal Array Tool.Should be able to do metrics analysis and reliabilityanalysis effectively with DFA tool. -->Data Centric testing(L3)-Should ve able to write SQL statements involving complex joins and groupingShould be able to understand the data model Should be able to create test planbased on Mapping document Ability to test at least one ETL (like Informatica orData Stage) or BI tool (like BO or Crystal Reports) Ability to use a testingmanagement tool -->Quality Center(L1)-Able to use Quality Center at an user level. Understanding of all thenavigations and features in QC. Ability to use QC as a Test management tool. -->DB2 SQL(L4)-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 Basics, Indexes and Basic Access Methods Basics,Introduction to the Optimizer Basics, Gathering Statistics Basics Adv SQLBasics: Able to understand and implement Datetime Functions, AdvancedSubqueries, Hierarchical Queries,DDL & DML Extensions, Transaction ManagementTools Level 1 usage Adv SQL & SQL Tuning Techniques: Ability to implementTunning Concepts/Techniques like Explain Plan, Access method, Generateperformance analysis snapshots, Index analysis, Gather Statistics, Using VisualExplain, SQL Access Advisor Adv SQL Tuning: Mastering in resolving ComplexPerformance issues through Advanced SQL Tuning Techniques -->Data Centric testing(L1)-Awareness of Data Centric testing *Thanks,* *Jay Chauhan* *Technical Recruiter, **e**Team, Inc. **“**ACCELERATED HIRES**”* *efficiency. synergy. expertise* *732-248-1900 X 522* <732-248-1900%20X%20522>* (T)* *908-757-0800* <908-757-0800>* (F)* [email protected] <[email protected]> www.eteaminc.com -- You received this message because you are subscribed to the Google Groups "Associate Programs" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/associate_programs. For more options, visit https://groups.google.com/groups/opt_out.
