Develop SQL Server Integration Services (SSIS) programs to support the data integration of a global supply chain planning application from o9 Solutions with multiple ERP and operations IT applications.
Requirements
- Microsoft SQL Server Integration Services (SSIS) knowledge and demonstrated experience required.
- Knowledge of designing and developing data transformation solutions using a variety of SSIS components (Data Flow Task, Data Flow transform tasks, Data Flow containers, Foreach Loop containers, Script components using C).
- Familiarity with building SQL database objects (tables, views, stored procedures).
- Familiarity with project deployment model, use of project and package parameters, and Integration Services Catalog (including Environments) preferred.
- Experience with Oracle E-business Suite (EBS), Baan/Infor, o9 Solutions preferred, but not required
- Must be proficient with Microsoft Office and Microsoft Project
- Knowledge of supply chain and operations (manufacturing, packaging and warehousing) is preferred, but not required.
Responsibilities
- Develop SQL Server Integration Services (SSIS) programs to support the data integration of a global supply chain planning application from o9 Solutions with multiple ERP and operations IT applications.
- Reviews user requirements for new applications or enhancements to existing applications and performs analysis, design, development, testing, installation, and training related to the application developed.
- Analyze requests from users for new systems, new programs, program changes, etc. and recommend necessary action
- Design new systems and modifications to existing systems to meet user requirements.
- Write new or modify existing programs according to specified systems designs.
- Test new or modified programs to ensure that they conform to design. Develop test data for use in program testing
- Write documentation of system changes in conformance with department standards
Other
- Excellent written, oral, and interpersonal communication skills.
- Excellent time management
- Highly self-motivated, self-directed, and attentive to detail.
- Ability to effectively prioritize and execute tasks in a high-pressure environment.
- Extensive experience working in a team-oriented, collaborative environment
