CooperVision, a division of CooperCompanies (NYSE:COO), is one of the world’s leading manufacturers of soft contact lenses. The Company produces a full array of daily disposable, two-week and monthly contact lenses, all featuring advanced materials and optics. CooperVision has a strong heritage of solving the toughest vision challenges such as astigmatism, presbyopia and childhood myopia; and offers the most complete collection of spherical, toric and multifocal products available. Through a combination of innovative products and focused practitioner support, the company brings a refreshing perspective to the marketplace, creating real advantages for customers and wearers. For more information, visit www.coopervision.com
Job Summary:
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. This is a contract position, and the successful candidate in this position will be expected to bring knowledge and experience with Microsoft SQL Server Integration Services (SSIS) and applying SSIS to develop data extraction-transformation-load function to create this integration.
Essential Functions & Accountabilities:
- Take direction from Senior Programmer SSIS Development for CooperVision on daily tasks and activities
- Write new or modify existing packages/projects 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
- Write any necessary user documentation (report descriptions, user procedures, operations procedures)
- Provide timely and concise summaries of project status to manager
Knowledge, Skills and Abilities:
- Microsoft SQL Server Integration Services (SSIS) knowledge and demonstrated experience required.
- Familiarity with project deployment model, use of project and package parameters, and Integration Services Catalog (including Environments) preferred.
- 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#).
- 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.
- Software development life cycle and software quality assurance best practices and methodologies.
- Proficient in SQL query writing and editing
- Familiarity with building SQL database objects (tables, views, stored procedures).
Work Environment:
Standard office environment
Experience:
- Minimum 2 years’ experience in designing, developing, implementing systems using Microsoft SQL Server Integration Services (SSIS)
- 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
Education:
- Bachelor degree in Computer Science, Engineering, or an equivalent combination of education and experience
Affirmative Action/Equal Opportunity Employer. Minority/Female/Disability/Veteran
Read Full Description