Integrations Developer, 311 - Administrative Services (1063) @ City and County of San Francisco - San Francisco, CA

Job Overview

14 days ago

Integrations Developer, 311 - Administrative Services (1063)

City and County of San Francisco - San Francisco, CA

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.


  • Application Filing Deadline: January 14, 2022
  • Annual Salary: $101,270 – $127,478

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.



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.

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.


  • 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.
  • Applicants must meet the minimum qualification requirement by the final filing date unless otherwise noted.
  • 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.

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.


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:

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


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:

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

  • Information About The Hiring Process
  • Conviction History
  • Employee Benefits Overview
  • Equal Employment Opportunity
  • Disaster Service Worker
  • ADA Accommodation
  • Seniority Credit in Promotional Exams
  • Veterans Preference
  • Right to Work
  • Copies of Application Documents
  • Diversity Statement

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.

Similar Jobs

Looker Developer

FocusKPI Inc.

San Francisco, CA

Ensure optimal integration between Looker and Snowflake. This is a full-time contract position. Duration: Contract position with potential for extension or…

Sr. Technical Account Manager

Amazon Advertising LLC

San Francisco, CA

Identify key product architecture components, propose and help partners build solutions that unblock integrations. 2+ years of experience in Online advertising.

Sr Solutions Architect

Federal Reserve Bank of San Francisco

San Francisco, CA

We employ groundbreaking technologies using AWS native technologies which includes tools used for data integration, data modeling, and data analytics.

Sr.Quality Assurance Engineer

Amazon Data Services, Inc.

Cupertino, CA

Bachelor's degree and 10+ years practical test and automation experience. 10+ years of experience in SDET/QA/SQA or System Test roles within networking domain.

Sr. Manager, Software Engineering Services LLC

Sunnyvale, CA

4+ years of experience as a software developer. Established expertise in developer tools or software development lifecycle (SDLC) systems (continuous…

Software Dev Engineer - Test Services LLC

Sunnyvale, CA

2+ years of experience as a developer, QA Engineer, or as an SDET. The test software you will build should expose API defects in production level code as well…

Sr. Software Development Engineer, Alexa Internet

Alexa Internet

San Francisco, CA

Provide technical guidance and coaching to junior software developers. Set technical direction within the team and influence technical integrations with related…

Principal Solutions Architect, Alexa Auto Services LLC

Sunnyvale, CA

Coordinate, manage and report activities across a variety of internal teams, up to Amazon executive levels, to plan and lead the execution of integrations;…

Senior Software Engineer - SignUp

New Relic

San Francisco, CA

Build scalable and reliable services that drive our presence in new providers. Diagnose and solve problems in high-efficiency services and distributed systems…

JavaScript Software Engineer


Redwood City, CA

PubMatic’s cloud infrastructure platform for digital advertising empowers app developers and publishers to increase monetization while enabling media buyers to…

Salesforce Integration Lead


Sacramento, CA

Interface Analyst / Lead - work with state client's integration partners and project team to validate integration requirements, design interfaces and prepare…

Technical Instructor (Contractor)


San Francisco, CA

3+ years teaching both on-premise and SaaS data integration business applications. This role offers an incredible opportunity to contribute to all of our…

API Architect


San Jose, CA

As a Platform Architect on the API Design team you will be responsible for the design of the APIs supporting client user experiences on various channels (web,…

Package Specialist Oracle SCM Cloud

Peoplevisor LLC

Sunnyvale, CA

3+ years of developer experience with AMS & Implementation experience, this is for an OCI, cloud exp is must. Works collaboratively with project team and client…

TPM Manager - Metaverse VR Experiences


Burlingame, CA

Reality Labs (RL) is bringing together cutting edge research and engineering to deliver products and experiences for the future of immersive computing and…

Product Manager, Confluence Notifications


Mountain View, CA

Own and develop the Confluence notifications experience across all channels (web, mobile, email, third party integrations).

Product Manager, API & Apps User Experience


San Francisco, CA

Experience working on developer-facing products. Work with our other API & Apps squads to create a connected vision for a vibrant, healthy marketplace for…

Professional Services Architect, Global Services - Platform - 22909


San Francisco, CA

Be successful working with all levels of an organization from the C-suite down to individual developers and SRE’s. NET), databases and analytical tools.

Salesforce Architect - Remote


San Francisco, CA

Mentor and provide technical guidance to a team of Salesforce developers and administrators. Uphold Salesforce developer/architect credential/s and keep up with…

iOS Software Engineer


San Jose, CA

Proficient understanding of Git and familiarity with continuous integration. Knowledge of other web technologies and UI/UX standards.

Senior Software Engineer (Mobile)

Abbott Laboratories

Sunnyvale, CA

Provide technical guidance and leadership to other developers in the implementation and delivery of new features, platform enhancements and corrective actions.

Professional Services Architect, Global Services - Platform


San Jose, CA

Be successful working with all levels of an organization from the C-suite down to individual developers and SRE’s. NET), databases and analytical tools.

Head of Life Sciences Industry Americas


Santa Clara, CA

The individual for this role will have specific knowledge of leading innovations, workflows and integrations that enable the Life Sciences industry related to…

Sr. Software Engineer, Tech Lead - Salesforce


San Francisco, CA

Manages and administers Salesforce and its related integration touchpoints. Knowledge of Salesforce Integration Patterns, both batch and real-time, through…