* Hi BusinessPartners,
Hope you are doing great! Looking for PL/SQL Developer in Marlborough, MA – 6+ Months - Please share resumes to [email protected] WILL HIRE FROM A PHONE SCREEEN Keys to the Position: • This position will involve 60% development and 40% analysis • With Regards to the Development part of the role, 80% of the time the consultant will be responsible for Oracle PL/SQL development which includes performance tuning and analytical functions. The Manager is also looking for the candidate to have some Java and Datastage experience. The Manager needs them to have strong PL/SQL experience • Expert PL/SQL developer on UNIX - at least 7 years of experience • Candidates must have an MBA or Masters Degree in CS. This is a Must • Must have at least 3 years of financial services experience - This is a MUST • Candidates with some Java - This is a MUST • Analytical Functions exp - 5+ years This is a MUST • Client currently uses the 11g database, This is a MUST • Must know UNIX very well, will be required to write some scripts including Perl This is a MUST • Must be able to debug data issues. Not only create the fix, but have the Analysis skills to evaluate and make sure the issues do not happen again • May be asked to do code reviews for other consultants in this group • Experience with Data Stage/ETL tool desired • Must be a team player and be able to work in a friendly collaboritve environment. • Applicant must meet ALL of these requirements. Candidate needs to answer these questions, answers have to submitted along with resume 1 What is the difference between a Matrix and Matrix with group report? 2 Can you explain the difference between Group By and Partition By clauses? 3 What are the analytical functions available in Oracle? 4 What is the difference between Single and Correlated sub-queries? 5 What is query to get first day of the last quarter? 6. How can you tell if an UPDATE updated no rows, in SQL and PL/SQL? 7 Difference between DELETE, TRUNCATE and DROP? 8. Difference between Primary, Unique and Foreign keys? 9. How to debug PL/SQL code? 10. Explain the difference between implicit and explicit cursors? Thanks & Regards…. ? Lucky Sr Technical Recruiter Integrated Technology Strategies, Inc. 1140 Heartwood Drive | Cherry Hill | NJ 08003 Ph: 856-677-3043 | Fax: 856-494-1333 [email protected] | www.itstrategiesinc.com Gtalk : laxmikanthpawar Yahoo IM : laxmikanthpawar * -- You received this message because you are subscribed to the Google Groups "US_IT.Groups" 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/us_itgroups. For more options, visit https://groups.google.com/groups/opt_out.
