* Hi BusinessPartners,
Hope you are doing great! Looking for PL/SQL Reports Developer in Marlborough, MA –6+ Months - Please share resumes to [email protected] There are 3 openings now WILL HIRE FROM A PHONE SCREEN 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? The individual will be working with the rapid solutions team to deliver information delivery solutions and enhance existing Oracle reports for Fixed Income Investment business. In addition, the responsibilities will include designing and development of very efficient PL/SQL functions, stored procedures. Database design and performance tuning experience is a must. The candidate should have demonstrable experience with software development practices. Professional systems design and excellent verbal and written skills are necessary. The candidate should be well-versed in PL/SQL, Oracle Reports and Oracle BI suite of products. Prior knowledge of financial industry and investment processes is a strong plus. Experience in working with XML and JSP/JAVA/HTML is a strong plus. Work requires good mathematical skill and an excellent problem solving acumen with ability to work in a fast paced dynamic team oriented environment. Daily Activities • Organize and document the information collected from business analyst, system architect and designers, and developers, to facilitate the company-wide publication of project information, and to enhance system support efficiency. Based in Boston • Activities include but are not limited to: contributing to design sessions, coding, code reviews, unit testing, integration testing, supporting beta testing, bug fixes and documentation. Keys to the Position: · Oracle Reports 11g experience, preferably with reports migration experience from 6i to 11g. Oracle Reports experience is a Must · Candidates need to be strong with PL/SQL as well but Reports will be the focus · Oracle BI Publisher and Answers experience is a plus. · Database Tuning as well working on the Unix platform · Excellent verbal and written communication skills. · This is a very fast passed, high exposure position. Having the right technical skills is not enough. The candidate must be able to interact with others. · Last year this group wrote 67 new complex reports and made enhancements to 100 others. There are 450 reports that this group supports · This will be based in Boston · Please do not send candidates that have an oracle Financials background unless they have worked with Oracle BI Publisher and Answers and have strong Reports 6I experience. Minimum Requirements: · Oracle OBIEE Desired 6+ months · Oracle Reports (6i and 11g) Required 2-3 · Oracle PL/SQL Programming & Perl Required 3 · Database Design and Performance tuning Required 3 · Unix Systems Knowledge Required 3 · JAVA/JSP/XML/HTML Desirable 2-3 · Financial Industry Experience 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.
