Job Title: PL/SQL Developer
Work Location: Pittsburgh PA
Duration: 06-12 month contract
Job Responsibilities:
This is an application development role within the Enterprise Applications Record to Report (R2R) Forecasting and Analytics (FA) application support area of the USS Business Service Center (BSC). This position will work with the R2R FA team at the Muriel Street location primarily focused on developing and maintaining backend SQL and PL/SQL code for an Oracle Operational Data Store. This ODS is a component of USS’s Hyperion Costing Analytics (HYC) solution. R2R FA needs expert level SQL and PL/SQL skills to support and develop changes to the Oracle ODS. Though not a DBA role, assignments would also include creating and modifying Oracle table, view and index structures.
Major responsibilities:
Analyze, design, develop, test, and implement solutions as part of the R2R FA systems development team.
Develop and maintain complex and optimized Oracle SQL, PL/SQL packages, stored procedures and functions.
Develop and maintain logical design of Oracle tables, views, indexes.
Work with R2R Application Architects and other team members to understand the application’s functional needs and requirements
Provide feedback on and adhere to delivery dates.
Identify potential process improvements and provide technical recommendations where appropriate.
Candidate Qualifications
College degree: Yes - Bachelors in Computer Science, MIS or related field of study.
Years of Work Experience: The candidate must have a minimum of 6 years of progressively more complex development experience with Oracle SQL and PL/SQL in a large scale information system environment.
Technical Skills Required
Proven experience and expertise in designing and developing complex and optimized Oracle PL/SQL packages, stored procedures and functions is a must.
Proven experience and expertise in designing and developing complex and optimized SQL code.
Proven experience and expertise in logical design and modification of Oracle database tables, views, indexes.
Proven experience and expertise in large volume, batch processing environment.
Ability to work independently from both detailed technical specifications and broader functional specifications depending upon the scale and complexity of assignment.
Prepare documentation of program development, modifications to code, testing in compliance with standard operating procedures and SOX requirements.
Personal Skills Required:
Develop comprehensive test plans, scripts and cases and perform unit and comprehensive testing to ensure overall functionality and technical quality of deliverables
Troubleshoot and debug technical issues and problems, monitor progress against plan, and communicate status to Leads
Must be able to communicate effectively, work in a team environment and think analytically.
Additional Skills not required but would be a plus:
Strong SQL tuning skills
Knowledge of Data Warehousing concepts
Familiarity with Oracle Data Integrator (ODI) or similar ETL tool
Familiarity with Hyperion Essbase or other multidimensional OLAP processing
Bachelors in Computer Science, MIS or related field of study.
Local candidates preferred. Immediate interview and placement!
Job details are sourced from the employer's original posting.
Open job postingAbout the company
360 IT Professionals is a Software Development Company based in Fremont, California that offers complete technology services in Mobile development, Web development, Cloud computing and IT staffing. Merging Information Technology skills in all its services and operations, the company caters to its globally positioned clients by providing dynamic feasible IT solutions. 360 IT Professionals work along with its clients to deliver high-performance results, based exclusively on the one of a kind requirement. Our services are vast and we produce software and web products. We specialize in Mobile development, i.e. iPhone and Android apps. We use Objective-C and Swift programming languages to create native applications for iPhone, whereas we use Android Code to develop native applications for Android devices. To create applications that work on cross-platforms, we use a number of frameworks such as Titanium, PhoneGap and Jquery mobile. Furthermore, we build web products and offer services such as web designing, layouts, responsive designing, graphic designing, web application development using frameworks based on model view controller architecture and content management system. Our services also extend to the domain of Cloud Computing, where we provide Salesforce CRM to effectively manage one’s business and ease out all the operations by giving an easy platform. Apart from this, we also provide IT Staffing services that can help your organization to a great extent as you can hire highly skilled personnel’s through us. We make sure that we deliver performance-driven products that are optimally developed as per your organization’s needs. Take a shot at us for your IT requirements and experience a radical change.