Senior Applications Developer

Full Job Description

Are you looking for an exciting career in which you can share your extensive information technology (IT) knowledge with staff to provide valuable services for the Commonwealth?

The Health and Human Services (HHS) IT Delivery Center provides end-to-end IT services to all staff in the Department of Human Services (DHS), the Department of Health (DOH), the Department of Drug and Alcohol Programs (DDAP), and the Pennsylvania Department of Aging (PDA).

We are searching for a Senior Applications Developer to coordinate the work of Applications Developers on the data warehouse development team.

This role has significant and specific responsibility for the highly advanced lead technical work in the analysis, planning, design, development, programming, testing, debugging, maintenance, and documentation of Extraction, Transformation, and Load (ETL) process.

Take your IT career up a notch with the Data Warehouse Development Unit!

Requirements

This position involves development of complex ETL using Informatica and the development of complex, multi-dimensional logical and physical data models, complex database queries, and business metadata. Technologies used are the Informatica PowerCenter tool, SQL language, and data modeling tools on an Oracle data warehouse database. Work involves providing high-level Enterprise Data Warehouse (EDW) support for all mappings and data in the data warehouse as well as serving as the lead for the Informatica software administration. You will serve as the lead developer on complex systems software development teams, ensuring the utilization and compliance with Software Engineering Processes (SEP) and Systems Development Life Cycle (SDLC) methods. You will also have the opportunity to lead and mentor junior level applications developers in the design, development, assembly, testing, and deployment of complex software use to support agency missions; as well as support and participate in total quality management, continuous quality improvement, team-based processes, and customer-focused service in all activities of Bureau of Information Systems (BIS).

Interested in learning more? Additional details regarding this position can be found in the position description.

Work Schedule and Additional Information:

• Full-time employment
• Work hours range from 7:30 AM to 5:00 PM, candidate may decide schedule. Lunch period will be based on selected work schedule 30 minute or 1 hour lunch, Monday - Friday

Telework: You may have the opportunity to work from home (telework) part-time, up to 3 days per week.

In order to telework, you must have a securely configured high-speed internet connection and work from an approved location inside Pennsylvania.

If you are unable to telework, you will have the option to report to the headquarters office in Harrisburg. The ability to telework is subject to change at any time.

Additional details may be provided during the interview.

• Salary: Selected candidates who are new to employment with the Commonwealth of Pennsylvania will begin employment at the starting annual salary of $77,379.00 (before taxes).
• You will receive further communication regarding this position via email. Check your email, including spam/junk folders, for these notices.

Qualifications

QUALIFICATIONS

Minimum Experience and Training Requirements:

• One year as an Applications Developer 2 or Computer Programmer 4 (Commonwealth job title or equivalent Federal Government job title, as determined by the Office of Administration); or
• Five years of information technology experience that includes three years of experience in applications development or applications maintenance; or
• Three years of information technology experience in applications development or applications maintenance, and an associate’s degree in any information technology field; or
• One year of information technology experience in applications development or applications maintenance, and a bachelor's degree in any information technology field; or
• An equivalent combination of experience and training.

Other Requirements:

• You must meet the PA residency requirement. For more information on ways to meet PA residency requirements, follow the link and click on Residency.
• You must be able to perform essential job functions.

How to Apply:

Resumes, cover letters, and similar documents will not be reviewed, and the information contained therein will not be considered for the purposes of determining your eligibility for the position.

Information to support your eligibility for the position must be provided on the application (i.e., relevant, detailed experience/education).

If you are claiming education in your answers to the supplemental application questions, you must attach a copy of your college transcripts for your claim to be accepted toward meeting the minimum requirements. Unofficial transcripts are acceptable.

Your application must be submitted by the posting closing date. Late applications and other required materials will not be accepted.

Failure to comply with the above application requirements may eliminate you from consideration for this position.

Veterans:

• 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 www.pa.gov/agencies/employment/how-to-apply.html and click on Veterans.

Telecommunications Relay Service (TRS):

• 711 (hearing and speech disabilities or other individuals).

If you are contacted for an interview and need accommodations due to a disability, please discuss your request for accommodations with the interviewer in advance of your interview date.

The Commonwealth is an equal employment opportunity employer and is committed to a diverse workforce.

The Commonwealth values inclusion as we seek to recruit, develop, and retain the most qualified people to serve the citizens of Pennsylvania.

The Commonwealth does not discriminate on the basis of race, color, religious creed, ancestry, union membership, age, gender, sexual orientation, gender identity or expression, national origin, AIDS or HIV status, disability, or any other categories protected by applicable federal or state law.

All diverse candidates are encouraged to apply.

Additional Information

• Completing the application, including all supplemental questions, serves as your exam for this position. No additional exam is required at a test center (also referred to as a written exam).
• Your score is based on the detailed information you provide on your application and in response to the supplemental questions.
• Your score is valid for this specific posting only.
• You must provide complete and accurate information or:
  • your score may be lower than deserved.
  • you may be disqualified.
• You may only apply/test once for this posting.
• Your results will be provided via email.