BUSINESS INTEGRATION DEVELOPER II

Description

ESSENTIAL FUNCTIONS AND DUTIES: 

INTERFACE DEVELOPMENT

1. Develop, test, document and maintain inbound and outbound data interfaces.
2. Create and modify SSIS (SQL Server Integration Services) packages.
3. Create and modify processes in our Managed File Transfer system (GoAnywhere)
4. Create processes in our business integration application (Cleo Clarify).
5. Follow and adhere to Century’s development processes and standards.
6. Take steps to improve the security and controls in place to protect the data received and transmitted.
7. Thoroughly test all work before releasing code to production by developing and executing test plans and scenarios including data design, tool design, data extract/transform.
8. Improve the quality of Century’s Interfaces by fully utilizing the tools at your disposal and by evaluating and suggesting new tools to incorporate into our environment.
9. Work with Analysts and Business Users to translate functional specifications into technical designs for implementation and deployment.
10. Assist in training of new Business Integration developers.

T-SQL DEVELOPMENT

1. Understand database concepts as well as the implications of different database designs.
2. Ability to develop well designed reusable database objects.
3. Create and modify tables, stored procedures, views, triggers and indexes.
4. Continually review and improve performance of stored procedures and SQL Queries.
5.  Conduct code review of other Business Integration Developers’ T-SQL development work to ensure consistent methodologies are followed and to make recommendations where necessary.

REPORT DEVELOPMENT AND MAINTENANCE

1. Design, develop and maintain corporate standards for VMS® reports and scheduled SSRS reports with the primary goal of delivering professional formatted reports that contain accurate and complete data to internal and external stakeholders.
2. Develop and maintain reports as per project, task and helpdesk ticket specifications. 
3. Take steps to improve the security and controls in place to protect the data contained in each report.
4. Improve the quality of Century’s Reporting Services by fully utilizing the tools at your disposal and by evaluating and suggesting new tools to incorporate into our environment.

SUPPORT

1. Monitor the Interface Summary Report as well as the GoAnywhere and Cleo processing servers for exception events and take necessary steps to resolve the immediate issue and then implement changes to avoid the same event in the future.
2. Responsible for updating and closing assigned tasks/helpdesk tickets within Tempero©.
3. Responsible for updating the Business Integration documentation.
4. 24 hours a day, 7 days a week support for all interfaces.

Requirements

 PROFESSIONAL QUALITIES

1. Teamwork
2. Generate enthusiasm among team members.
3. Facilitates effective team interaction.
4. Acknowledges and appreciates each team member's contributions.
5. Proactively seek opportunities to assist others on projects.
6. Customer Interaction
7. Communicate effectively with clients to identify needs and evaluate alternative business solutions with project management.
8. Continually seek opportunities to increase customer satisfaction and deepen client relationships.

************************************************************************************************

Century Distribution Systems Inc. is an equal opportunity employer and is committed to compliance with all applicable laws prohibiting employment discrimination.  All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity or expression, pregnancy, age, national origin, disability status, genetic information, protected veteran status, or any other characteristic protected by law.

All applications will be used exclusively for selection purposes and handled confidentially by authorized personnel only.  Your application may also be considered for other suitable positions within Century Distribution Systems Inc.