Reporting Developer (29785)

Position will design and implement complex reports, import/export Oracle data, manipulate and reformat data as necessary to meet business requirements. Position should be able to write queries and stored procedures, write data to and from Oracle tables, use data modeling tools, and have an understanding of relational databases. Experience using Oracle (insert version here) or later preferred and SQL experience is a must. 

Write SQL/PL-SQL functions, procedures, and triggers
Work with client and development team to design and code medium to high complexity reports
Work with client and development teams to design and code data ETL’s (Extract, Transform and Load) from disparate data sources to Oracle 11g database tables.
Communicate to clients, developers and management on developed designs, reports, data ETL’s, etc.

EXCELLENT written and verbal Communication skills.
Undergraduate degree.
5-7 years of equivalent of relevant experience working in an IT environment
5-7 years of experience developing in PL/SQL with Oracle.  Expert skill analyzing and writing PL/SQL. Ability to use advanced features such as ref cursors and built in packages. Also needs expert skill analyzing and writing complex SQL Statements using multi table joins, exist clauses, etc. Ability to tune SQL
2-3 years of experience Open Cobol: Ability to analyze and modify Open Cobol modules
2-3 years of experience with Oracle Reports 11g.  Expert skill modifying and creating complex (non base table) forms and complex reports.
2-3 years working in TOAD
2-3 years of experience using Linux Korn shell.  Ability to analyze, modify and create Korn Shell scripts
Advanced level interpreting business/reporting requirements, analyzing data, and interpreting the results
Advanced knowledge Developer Code review: Ability to defend code and logic in a formal code review.

- "All your information will be kept confidential according to EEO guidelines".
- All candidates who are authorized to work in US are encouraged to apply.

- Most of our positions require Candidate to clear the Background check prior to commencing the assignment.

SOURCER ASSIGNED: Pete Tylor; Email: pete dot tylor at idealforce.com

Disclaimer:

The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified. All personnel may be required to perform duties outside of their normal responsibilities from time to time, as needed.