Information Technology Generalist 2
Commonwealth of Pennsylvania
Dauphin County, PA
Come work for an exciting retailer who is one of the leading purveyors of wine and spirits in the United States. As a $2.5B retailer operating 600+ Fine Wine and Good Spirits retail locations as well as several wholesale locations, the Pennsylvania Liquor Control Board (PLCB) is looking for innovative IT professionals that have experience with Oracle Retail Merchandising Suite (RMS and SIM) or Oracle Enterprise Business Suite (EBS) of products. Candidates must be customer service oriented, energetic, willing to learn.
IMPORTANT: YOU MUST APPLY TO THIS VACANCY POSTING, MEET ELIGIBILITY REQUIREMENTS, COMPLETE THE SUPPLEMENTAL QUESTIONS AND RECEIVE A SCORE. YOUR SCORE IS ONLY VALID FOR THIS SPECIFIC VACANCY. ONCE THIS POSITION IS FILLED, YOUR SCORE IS NO LONGER VALID.
Work Hours: 8:30 am - 5:00 pm; Monday - Friday; 1 hour lunch
This position will provide technical work for the development and maintenance of the PLCB's Oracle Retail and Financial ERP application systems.
This position is responsible for the analysis, design, planning, development, testing, maintenance, and documentation of significant components of the PLCB's ERP system. Work includes applications development and maintenance responsibility for:
Oracle Retail Management Systems (RMS)
Oracle Retail Pricing Management (RPM)
Oracle Store Inventory Management (SIM)
Oracle EBS Order Management (OM)
Oracle Portals such as: Supplier Portal (including new item introduction, special order portal, special purchase allowance and online ordering portal (LOOP))
Appworx / One Automation interface run instructions and interface monitoring
Responsible for developing detailed functional specifications for system customizations, modifications, or workflow development based on business requirements. Writes code for PL/SQL update statements, modules and programs as required.
Provides level technical leadership to business owners regarding the highly complex Oracle system and other applications supported with guidance when needed from the BA4.
Analyzes, designs, constructs and tests programs for use in the Oracle systems.
Develops, executes, and documents unit, integration and user acceptance test scenarios and scripts as necessary (sometimes in conjunction with the technical operations team members).
Evaluates requests for system customization and determines if standard Oracle solutions are appropriate in lieu of custom development. Discusses findings with BA4 for concurrence.
Analyzes business requirements to determine appropriate system solutions.
Provides technical solutions to business owner requirements based on best system design practices.
PA residency requirement
– For more information on ways to meet PA residency requirements, follow the
and click on Residency
Minimum Experience and Training Requirements:
One year as an Information
Technology Generalist 1, Applications Developer 1, or Network Specialist 1; or two years of information technology experience that includes one year of technical information technology experience in applications development or applications maintenance, network operation or network maintenance, web site development or web site design, or other information technology support/administration services, and an associate's degree in any information technology field; or four years of information technology experience that includes one year of technical information technology experience in applications development or applications maintenance, network operation or network maintenance, web site development or web site design, or other information technology support/administration services; or a bachelor's degree in any information technology field; or an equivalent combination of experience and training.
This position requires a minimum of 13 months of full-time experience working with SQL.
Based on your answers to the supplemental application questions regarding education, you may be instructed to upload a copy of your college transcripts to your application
A resume needs to be submitted with your application. You may upload your document as an Attachment during the application process. You must still complete the application and answer the supplemental questions.
Must be able to perform essential job functions
Pennsylvania law (51 Pa. C.S. §7103) provides employment preference for qualified veterans for appointment to many state and local government jobs. To learn more about employment preferences for veterans, go to
and click the Veterans' Preference tab or contact us at
The Commonwealth of Pennsylvania is proud to be an equal opportunity employer supporting workplace diversity.
Score valid for this specific posting only
Score based on information reported on application and supplemental questions
Provide complete and accurate information or:
score may be lower than deserved
application processing may be delayed
disqualification may result
May only test
under this announcement
Email notice of test results provided
Further information on testing, assistance for persons with disabilities, veterans' preference, and other items can be obtained from:
: 2nd Level, Strawberry Sq. Complex, 320 Market St., P.O. Box 569, Hbg., 17108-0569; Telephone (717) 783-3058
: 110 North 8th St., Suite 503, Phila., 19107
: 411 Seventh Ave., Room 410, Pgh., 15219
Telecommunications Relay Service (TRS)
: 711 (hearing and speech disabilities or other individuals)
Share this job