IDC: SQL DEVELOPER Victor, NY, Any visa except H1

Monday, July 24, 2023

SQL DEVELOPER Victor, NY, Any visa except H1

I hope you are doing well.

I am hiring a consultant for one of my client's requirements. The Job Description for the same is written below. If you find yourself comfortable with the requirement please reply back with your updated resume

Position: SQL DEVELOPER

Location: Victor, NY, United States

Duration: 12+ months

VISA; Any visa except H1

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: