Data Integration Developer
CHIEF INFORMATION OFFICE
440 N. BROAD STREET
PHILADELPHIA, PA 19130

Central Office

Job Number: 4600165901

Start Date:

Open Date: 10/11/2018

Closing Date: 10/17/2018

Job Summary
Designs and deploys complex applications to support a range of business units. Using a variety of languages to deliver integration solutions that drive key business processes, spanning typical business units (Human Resources, Finance), as well as unique and critical academic processes. Delivers integration solutions to both existing third party or home grown applications. Participates in the full software development cycle, including participation in developing best practices and helps set the technical direction.
Essential Functions

• Understands and supports a common coding methodology; understands object-oriented programming.
• Develops data intensive applications that span multiple technologies, languages or stacks.
• Develops solutions that exhibit best practices for operational stability, particularly solutions that have dependencies on external applications (homegrown, third party or SAAS).
• Provides support to other developers for database intensive applications; conversant in multiple database systems including Oracle, mySQL, PostgreSQL and Microsoft SQL Server.
• Evaluates third party applications for suitability and integration with existing systems.
• Analyzes code to increase operating efficiency and/or adapts applications to new requirements.
• Develops applications for internal customers, as well as extending existing applications to meet new requirements.
• Takes the lead in the integration design, development, implementation and support.
• Rapidly develops scope and estimates, as well as risk points for delivering complete technical solutions.
• Produces design specifications for projects of various sizes from functional requirements.
• Establishes documentation on coding standards; conducts code reviews to ensure developers are complying with set standards.
• Reviews software packages for deployment and ensures that they adhere to the appropriate operational policies.

Additional Functions

• May lead team projects.
• Serves in the Architecture Review Group when necessary.
• Supports production deployment, which occasionally requires off hours support.

Minimum Requirements

• Bachelor's degree from an accredited college or university.
• Five years of full-time, paid, professional experience in the programming field, at least three years of which have involved designing applications with relational databases utilizing at least two industry-recognized programming languages.
  

OR

• Any equivalent combination of training and experience determined to be acceptable by the Office of Human Resources and Information Technology.

Knowledge, Skills and Abilities
Demonstrated knowledge of:

• enterprise class application design.
• SQL and relational database management systems, including Oracle, my SQL, PostgreSQL, and Microsoft SQL Server.
• development in multiple environments (operating systems, browsers, etc.).
• UNIX/Linux systems.
• developing software interfaces and applications that allow two disparate systems to interact to facilitate a seamless business process.
• working with complex data analysis and data migrations, including source to target data mapping, transformation, transport and results reconciliation.
• the complete software development lifecycle (SDLC): gathering requirements, analyzing requirements, designing a solution approach; developing code, testing, deploying and maintenance and support.
• enterprise data warehouse.
• LDAP directories.
• application security practices and policies.

Demonstrated ability to:

• manage large scale and/or complex projects.
• work effectively as part of a development team.
• respond to emergency situations and to effect problem resolution processes.
• analyze and resolve complex problems.
• establish and follow development procedures.
• document code and create basic user documentation.
• represent a superior at meetings and conferences.
• present ideas effectively, both orally and in writing.
• establish and maintain effective working relationships.

Disclaimer
The above statements are intended to describe the general nature and level of work being performed by people assigned to this classification. They are not to be construed as an exhaustive list of all responsibilities, duties, and skills required of personnel so classified.

Additional Job Information: This is a non-represented position.

Interviews may be conducted to determine how well a candidate meets the established criteria. Please note that not all qualified candidates may be selected for an interview.