Job Summary:
CooperVision is a leading global manufacturer of contact lenses committed to improving the way people see each day. The Sr. Programmer Analyst - SSIS role involves developing SQL Server Integration Services (SSIS) programs to support data integration for a global supply chain planning application, requiring knowledge of enterprise integration architecture and integration technologies.
Responsibilities:
โข 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
โข Write any necessary user documentation (report descriptions, user procedures, operations procedures)
โข Train users in operation of new or modified systems.
โข Aid in preparation of time and cost estimates for program development.
โข Analyze requests and write program specs for Jr. Programmers and contractors.
โข Provide programming support on-site or by phone as required for all shifts
โข Maintain awareness of technological developments in computer hardware and software systems
โข Provide timely and concise summaries of project status to manager
โข Communicates and applies project standards.
โข Consistently delivers high-quality services to the user community.
โข Plan and lead testing, implementation, training, support and documentation activities for local projects
โข Assist other developers โ internal and external โ through provision of functional specifications and technical walk through.
Qualifications:
Required:
โข 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#).
โข 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 (Waterfall & Agile like methods) and software quality assurance best practices and methodologies.
โข Familiarity with building SQL database objects (tables, views, stored procedures).
โข 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.
โข Ability to produce exceptional quality output.
โข 8 or more years of experience in designing, developing, implementing systems using Microsoft SQL Server Integration Services (SSIS).
โข Five years of experience in System Design preferably in an ERP environment.
โข Must be proficient with Microsoft Office and Microsoft Project.
โข Bachelorโs degree in computer science, Information Technology, Engineering, or related experience.
Preferred:
โข Familiarity with project deployment model, use of project and package parameters, and Integration Services Catalog (including Environments)
โข Experience with Oracle E-business Suite (EBS), Baan/Infor, o9 Solutions
โข Knowledge of supply chain and operations (manufacturing, packaging and warehousing)
Company:
CooperVision is one of the worldโs leading manufacturers of soft contact lenses and related products and services. It is a sub-organization of The Cooper Companies. Founded in 1980, the company is headquartered in Fairport, USA, with a team of 5001-10000 employees. The company is currently Late Stage.