This is Gaurav, working with SysMind. We have the below contract job opportunity with one of our direct clients and would like to check if you have any resources available. Please send across the resume of your consultants along with the contact information at the earliest to gna...@sysmind.com or call me at 609-897-9670 X2154
Role: Oracle Technical Consultant Location: San Jose ,CA Duration: 6+ Interview type: Telephonic/Skype Description: *Oracle Core Apps -* Understanding of all process flows Expert in 3-4 modules Know the setups and business implications of the setups Design Solutions Experienced in SQL,PL/SQL, D2K, Work flow, Discoverer, OAF, XML Publisher *Apps Functional Appreciation Core -* Working experience of the core modules including basic setups under FIN and SCM- at least 3 modules under FIN and SCM *Apps Functional Appreciation Non-Core-* Working experience of the core modules including basic setups under HRMS and CRM - at least 3 modules under HRMS and CRM *Essential Skill - 1. Oracle Core Tech* *Additional Skill- 1. Oracle- 2. Oracle SQL-* SQL Constructs Ability to understand and implement Data Types, Basic SQL SELECT 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 to understand and implement Date time Functions, Advanced Sub queries, Hierarchical Queries,DDL & DML Extensions, Transaction Management Tools Level 1 usage Adv SQL & 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 Gaurav Nagar Phone: 609-897-9670 x2154 Email: gna...@sysmind.com Fax: 609-228-5522 Address: 38 Washington Road, Princeton Jn, NJ 08550 -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at http://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/groups/opt_out.