Job Description

Under the direction of the TCUP Technology Enterprise Architect, performs integration and testing of existing enterprise information systems with information systems for the new train control system (TCUP).

** Examples of Important and Essential Duties:**

1. Works with stakeholders to understand system requirements.
2. Creates and documents interface specifications, technical documents, and diagrams.
3. Identifies data dependencies and map between systems.
4. Creates scripts for data transformation and migration.
5. Configures and tests APIs, middleware, and messaging systems.
6. Implements version control and change management processes.
7. Develops test plans and cases for integration scenarios.
8. Conducts unit and end-to-end testing to ensure components meet requirements.
9. Tests for scalability, reliability, and latency under different loads.
10. Simulates failure scenarios to verify error handling.
11. Coordinates with operations teams for integration activities.
12. Assists in deploying the integrated system.
13. Ensures rollback plans are in place during deployment.
14. Coordinates user acceptance testing with stakeholders.
15. Performs related duties as assigned.

Qualifications

** Minimum Qualifications**

1. An associate degree in computer science, computer engineering, information systems, 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 one of the fields above or a closely-related field]; AND

2. Five (5) years of experience analyzing, installing, configuring, enhancing, and/or maintaining the components of an enterprise network.

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 one of the fields above or a closely related field.

Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree.

Notes:

1. Applicants must meet the minimum qualifications by the final filing date unless otherwise noted.

2. One (1) year full-time experience 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 experience.

Desirable Qualifications:

The stated desirable qualifications may be used to identify candidates advancing to the interview process and/or to identify job finalist(s) at the end of the selection process when referred for hiring.

1. Experience using APIs (REST, SOAP, gRPC) for communication between systems.
2. Familiarity with message queues (Azure Service Bus, Azure Event Hub) and middleware for asynchronous integration.
3. Proficiency in at least one language (Python preferred; Java, C++, or JavaScript acceptable) to develop integration scripts, tools, or automation workflows.
4. Proficiency with object-oriented software design and implementation.
5. Ability to write scripts for data transformation, system configuration, or test automation (e.g., Bash, PowerShell).
6. Experience in developing software for real-time data streaming systems using asynchronous and multi-threaded design principles.
7. Experience with tools for integration testing, such as Postman (for API testing) or SoapUI.
8. Experience with HTTP/HTTPS, FTP.
9. Experience building relational or non-relational queries for distributed software architectures.
10. Experience mapping, cleaning, and transforming data during integration using ETL tools or custom scripts.
11. Experience generating requirements and testing against them.
12. Proficiency in Git for managing integration artifacts and test cases.
13. Technical expertise and knowledge of intelligent transportation systems.
14. Ability to work well with a multi-disciplinary, diverse workforce, including operations staff, maintenance technicians, technical professionals, and contractors.

Additional Information

** Verification:**

Applicants may be required to submit verification of qualifying education and experience at any point during the recruitment and selection process. More information can be found at: https://sfdhr.org/information-about-hiring-process#verification. 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.

** Selection Process:**

Applications will be screened for relevant qualifying experience. Additional screening mechanisms may be used to determine candidates' qualifications. Only those applicants who most closely meet the needs of the Agency will be invited to move forward in the selection process.

• Information About the Hiring Process
• Conviction History
• Employee Benefits Overview
• Equal Employment Opportunity
• Disaster Service Worker
• ADA Accommodation
• Right to Work
• Copies of Application Documents
• Diversity Statement

This recruitment may be utilized to fill similar positions in this classification at SFMTA.

For questions or inquiries, please contact the analyst, Tracy Pon at Tracy.Pon2@sfmta.com.

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

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.