*

Hi BusinessPartners,

Hope you are doing great!



Looking for  PL/SQL Reports Developer in Marlborough, MA– 6+ Months - Please
share resumes to [email protected]



WILL HIRE FROM A PHONE SCREEN



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 Required 2



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.


Reply via email to