Job Details

divh2Reporting Developer/h2pIDEALFORCE 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./ph3Job Description/h3pPosition 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./ppWrite 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 ETLs (Extract, Transform and Load) from disparate data sources to Oracle 11g database tables. Communicate to clients, developers and management on developed designs, reports, data ETLs, etc./ph3Qualifications/h3pExcellent 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./ph3Additional Information/h3pAll 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./ppSourcer assigned: Pete Tylor; Email: pete dot tylor at idealforce.com/ppDisclaimer: 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./p/div