IDEALFORCE has a CONTRACT position available immediately for Sr Oracle Reporting Developers to join our customer in Phoenix Arizona. This is an ONSITE position. Please find below additional details about this job. Kindly respond with your most up to date resume if you would like to pursue this opportunity. Client prefers LOCAL CANDIDATES for this position.
Job DescriptionPosition 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.
Skills Required
- Excellent written and verbal communication skills.
- Undergraduate degree.
- 5-7 years relevant IT experience.
- 5-7 years developing in PL/SQL with Oracle, including ref cursors and built-in packages.
- Expert skill analyzing and writing complex SQL statements and tuning SQL.
- Write SQL/PL-SQL functions, procedures, and triggers.
- 2-3 years experience with OpenCOBOL (analyze and modify modules).
- 2-3 years experience with Oracle Reports 11g (create and modify complex reports/forms).
- 2-3 years experience using TOAD.
- 2-3 years experience with Linux Korn shell; ability to analyze, modify, and create Korn Shell scripts.
- Design and code medium to high complexity reports.
- Design and code ETL processes from disparate sources to Oracle 11g tables.
- Experience using data modeling tools and understanding relational databases.
- Advanced ability to interpret business/reporting requirements, analyze data, and interpret results.
- Experience participating in and defending work during developer code reviews.
What We Do
Idealforce is a premier talent acquisition solutions provider that helps corporations find top-performing talent through innovative ways and technologies. The company offers unparalleled talent acquisition and management services, helping businesses find quality talent cost-effectively while assisting talented individuals in finding the best employers where their skills are recognized and rewarded.







