Job Description

Job Title: INTEGRATION DEVELOPER

Labor Category: PRG3

Location: 100% Remote

Scheduled Work Hours: Normal business hours, Monday through Friday, 35 hours/week (not including mandatory unpaid meal break after 6 hours of work)

Job Type: Contract

Pay Rate: $70 - $80 per hour

SCOPE OF SERVICES

OTI’s Office of Data Analytics (ODA) works with City agencies and their data to help serve New Yorkers more equitably and effectively. This work takes three main forms: analyzing data to improve City agency operations; making Open Data more accessible to all New Yorkers; and advancing citywide data infrastructure, integration, and sharing. ODA seeks a Java Developer role to ensure the efficient and successful implementation and support of complex data engineering solutions for City agencies. This resource should demonstrate a solid understanding of industry-standard implementation methodologies using data integration engineering technologies, tools, and processes

TASKS:

• The application developer is expected to be a key resource for the building of Java-based front-end, back-end applications.
• Develop custom code and web services that allow seamless integration between systems.
• Contribute to new technology projects as assigned and provide operations and maintenance support for existing applications.
• Unit test newly developed code and support system testing efforts.
• Troubleshoot errors, defects, and other system issues.
• Create and maintain excellent documentation (including data dictionaries, source-to-target maps, and database policies and guidelines) and source code repositories.
• Responsible for working with City’s Cyber Command unit to follow and complete the application security accreditation process.

MANDATORY SKILLS/EXPERIENCE

Note: Candidates who do not have the mandatory skills will not be considered.

• 8+ years of experience with application development using Java Spring Boot Framework.
• Extensive knowledge of service-oriented architecture using SOAP and RESTful web services.
• 8+ years of experience in writing SQL.
• 8+ years of experience in copying, transferring, manipulating, and automating data operations that were manual processes.
• Experience with tools and components of MDM (Master Data Management).
• In-depth knowledge of SQL and other database solutions.
• Experience developing cloud-ready applications.
• Experience with RabbitMQ.
• Experience with WSDL creation.

DESIRABLE SKILLS/EXPERIENCE:

• Experience using ETL tools.
• Experience using Oracle 10g/11g, SQL Server and/or a database appliance.
• Knowledge of metadata-driven enterprise reporting platforms.
• Knowledge of Python, JavaScript frameworks like Vue.js, React.js, Node.js, express.js.
• Knowledge of one or more programming languages.
• Experience with 3-tier architecture.
• Experience with Oracle, Microsoft SQL Server, MySQL, RDS, PostgreSQL.
• Experience working hands-on in cloud-based platforms such as AWS, Microsoft Azure, and Snowflake is a plus.
• Experience with an agile, iterative development process and version control tools such as Git, GitHub, and Subversion.