Integrations Developer, 311 - Administrative Services (1063)

  • Full-time
  • Certification Rule: Rule of 3
  • Exam Type: Position Based Test
  • Work Hours: Regular
  • Job Code and Title: 1063-IS Programmer Analyst-Senior
  • Fill Type: Permanent Civil Service
  • Eligible List Type: Combined Promotive and Entrance

Company Description

The San Francisco 311 Customer Service Center (SF311) connects residents and visitors with easy access to government services and information through the phone, web, and mobile. SF311 strives to simplify and improve work processes and remove barriers for requesting service or information. SF311 prides itself on innovation and hard work and has handled over 21 million calls since its launch in 2007 and over 65% of service requests are submitted via self-service options.

THIS IS A POSITION BASED EXAM

Job Description

We are looking for an experienced developer to help us connect processes and data to improve City services using Oracle Cloud Services.

Working with a team of analysts, you will build the services that connect the wide range of applications used by City agencies and their partners. The SF311 integration HUB distributes and tracks work based on rules and process that are constantly changing to improve performance and interoperability. You will focus on cloud architecture, application integration, and cloud application development using Oracle's Cloud Integration Platform (OIC), Oracle PaaS technologies, Oracle application, Oracle databases, On-premises Apps, CRM applications and 3rd party systems. You'll create and manage workflow that augments service request data to increase efficiency.

Essential duties include, but are not limited to:

  • Design, develop, test, and maintain applications on Oracle Integration Cloud (OIC)
  • Oversee all phases of the software development lifecycle (SDLC)
  • Work closely with other team members to support processes and translate requirements to technical design.
  • Develop and expose SOAP and RESTful based web services
  • Perform technical design, development, and testing of resources created.
  • Debug and maintain existing projects.
  • Develop and deploy application customization and changes.
  • Parse unstructured XML for access to and incorporation of XML instance data
  • Create and configure data sources for integration data exchange
  • Create and update tables in databases; create SQL for queries and updates
  • Ensure correct balance of new development and support for existing systems
  • Monitor systems for errors, provide technical and operational support by working with technical teams in maintaining system operations.

Nature of Work: Nature of Work: Full-time, usually Monday through Friday, 9:00 am – 6:00 pm. Teleworking may be allowed up to 3 days/week but applicant must be able to meet the City's telework policies and management reserves the right to cancel at any time. Additionally, this position will require applicant to be available to work occasional weekends and holidays whenever necessary to provide outreach sessions as necessary.

Qualifications

MINIMUM QUALIFICATIONS

Education:
An associate degree in computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in computer science or a closely-related field.

Experience:
Three (3) years recent and verifiable experience in development of software applications or system integrations. Experience must be within the last six years.

Substitution: Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in computer science or a closely related field.

Notes:

  1. One (1) year full-time employment is equivalent to 2000 hours (2000 hours of qualifying work experience is based on a 40-hour work week). Any overtime hours that you work above forty (40) hours per week are not included in the calculation to determine full-time employment.
  2. Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
  3. The above minimum qualifications reflect special conditions associated with the position(s) to be filled.  They may differ from the standard minimum qualifications associated with this class code.

DESIRABLE QUALIFICATIONS
The stated desirable qualifications may be used to identify job finalists at the end of the selection process when candidates are referred for hiring.

  • Experience with Oracle Integration Cloud (OIC)
  • Experience with Oracle SOA Suite (BPEL, XML, WSDL/XSD, Adapters)
  • Experience with Oracle Service Bus (OSB) implementation
  • Knowledge working with Integration frameworks (REST, SOAP, FTP and Messaging)
  • Experience programming in Java
  • Experience in writing database queries and procedures for applications integration
  • Collaboration, teamwork, and relationship-building skills.

VERIFICATION OF EDUCATION AND EXPERIENCE:

Applicants may be required to submit verification of qualifying education and experience at any point in the application, examination and/or departmental selection process. Falsifying one’s education, training, or work experience or attempted deception on the application may result in disqualification for this and future job opportunities with the City and County of San Francisco. For more information on verification, please visit the following link: http://www.sfdhr.org/index.aspx?page=20#verification

All work experience, education, training and other information substantiating how you meet the minimum qualifications must be included on your application by the filing deadline. Information submitted after the filing deadline will not be considered in determining whether you meet the minimum qualifications.

Resumes will not be accepted in lieu of a completed City and County of San Francisco application.

Applications completed improperly may be cause for ineligibility, disqualification or may lead to lower scores.

Additional Information

SELECTION PROCEDURE:
Candidates must pass all phases of this examination in order to be ranked on the eligible list.

Minimum Qualification Supplemental Questionnaire (MQSQ): Candidates will be required to submit an MQSQ at any point in the application, examination or departmental selection process. The MQSQ will be used to evaluate if the applicant possesses the required minimum qualifications. Applicants are required to also complete the Preliminary Questions with their application. It is essential that applicants provide complete information in identifying their education, experience and training. Any experience or education field that lists see resume will not be accepted.

Oral/Performance Examination (Weight: 100%): Candidates deemed qualified will be invited to participate in an Oral/Performance examination designed to measure their relative knowledge, skill and ability levels in job-related areas which may include, but is not limited to the following: ability to develop complex integration services, understand business requirements and determine the best option for integration, write database queries and procedures for applications integration; knowledge of Integration frameworks, Java/JEE and web applications architecture, development, and debugging and tuning; human relations ability; oral communication ability.

Qualified candidates will be notified of the date, time, location and type of exam format in their exam appointment notification.

CERTIFICATION RULE: The certification rule for the ranked eligible lists resulting from this examination will be Rule of Three Scores. The department may administer additional position-specific selection procedures to make final hiring decisions.

Eligible List/Score Report: A confidential eligible list of applicant names that have passed the civil service examination process will be created and used for certification purposes only. An examination score report will be established, so applicants can view the ranks, final scores and number of eligible candidates. Applicant information, including names of applicants on the eligible list, shall not be made public unless required by law. However, an eligible list shall be made available for public inspection, upon request, once the eligible list is exhausted or expired and referrals resolved. The eligible list/score report resulting from this civil service examination process is subject to change after adoption (e.g., as a result of appeals), as directed by the Human Resources Director or the Civil Service Commission.  

The duration of the eligible list resulting from this examination process will be 6 months and may be extended with the approval of the Human Resources Director 

Terms of Announcement:
This is a Position Based Test conducted in accordance with Civil Service Rule 111A. Applicants must be guided solely by the provisions of this announcement, including requirements, time periods and other particulars, except when superseded by federal, state or local laws, rules or regulations.  Clerical errors may be corrected and, if so, an amended note will be posted on this official job announcement. 

The terms of this announcement may be appealed under Civil Service Rule 111A.35.1. The standard for the review of such appeals is ‘abuse of discretion’ or ‘no rational basis’ for establishing the position description, the minimum qualifications and/or the certification rule.  Appeals must include a written statement of the item(s) being contested and the specific reason(s) why the cited item(s) constitute(s) abuse of discretion by the Human Resources Director.  Appeals must be submitted directly to the Executive Officer of the Civil Service Commission within five business days of the announcement issuance date.

Specific information regarding this examination process are listed below.

  • Application Re-Issued: Wednesday, January 5, 2022 for CONTINUOUS application; may close at anytime.
  • Application Deadline on Reissuance: January 14, 2022
  • Application Opening - Wednesday September 29, 2021
  • Application Deadline - Monday, November 29, 2021 (11/22/21).
    Amended to Continuous application until we have sufficient qualified application; may close at anytime.  Applicants are encouraged to FILE IMMEDIATELY. (10/18/21)
  • Examination Plan for this recruitment consists of an Oral/Performance weighted at 100% of the candidates exam score.  Candidates must pass all phases of exams to be ranked on the eligible list (PBT-1063-114859).
  • Eligible List duration resulting from this examination process will be six (6) months.
  • Certification Rule for the eligible list resulting from this examination will be Rule of Three Scores.
  • Exam Type: Combined Entrance and Promotive
  • SR Link: https://smrtr.io/7JxLF

Additional Information Regarding Employment with the City and County of San Francisco:

All your information will be kept confidential according to EEO guidelines.

Exam Analyst Information: If you have any questions regarding this recruitment or application process, please contact the exam analyst, Angie Ignao at [email protected].

CONDITION OF EMPLOYMENT:  All City and County of San Francisco employees are required to be vaccinated against COVID-19 as a condition of employment.  For details on how it is applicable to your employment, please click here.

The City and County of San Francisco encourages women, minorities and persons with disabilities to apply. Applicants will be considered regardless of their sex, race, age, religion, color, national origin, ancestry, physical disability, mental disability, medical condition (associated with cancer, a history of cancer, or genetic characteristics), HIV/AIDS status, genetic information, marital status, sexual orientation, gender, gender identity, gender expression, military and veteran status, or other protected category under the law.

Privacy Policy