Hi, Please find the requirement below and email resumes to va...@aclatinc.net
* * *Title: PL/SQL Reports Developer* *Location: Marlborough, MA* * * *Please answer these below 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 *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 Desirable 2 Best Regards * * *Venkat* Aclat Inc. 5 E. College Drive Suite 100, Arlington Heights, IL 60004 Office:847-577-3501 Ext 3504,www.aclatinc.com E-mail:va...@aclatinc.net -- You received this message because you are subscribed to the Google Groups "Oracle-Projects" group. To unsubscribe from this group and stop receiving emails from it, send an email to oracle-projects+unsubscr...@googlegroups.com. To post to this group, send email to oracle-projects@googlegroups.com. Visit this group at http://groups.google.com/group/oracle-projects. For more options, visit https://groups.google.com/groups/opt_out.
