*please send the resumes to **[email protected]* *Job Title: Oracle Apps Consultant*
*Location: San Jose, CA* *Duration: 6 months* *Requirements:* *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, Workflow, Discoverer, OAF, XML Publisher Working experience of the core modules including basic setups under FIN and SCM- at least 3 modules under FIN and SCM Working experience of the core modules including basic setups under HRMS and CRM - at least 3 modules under HRMS and CRM *Oracle SQL* 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 to understand and implement Date time Functions, Advanced Sub queries, 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 Regards, *__________________* *Nandu* e*NFLUENCE IT Services Pvt. Ltd.* 7699 Mayfield Ave, Elkridge, MD-21075 Mail id : [email protected] P: 410-705-6565 x 1361, F: +1 410 777 8451 www.enfluenceit.com *Ymail : nandu.recruiter86* -- You received this message because you are subscribed to the Google Groups "OracleD2K" 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/oracled2k. For more options, visit https://groups.google.com/groups/opt_out.
