Job Description :
SQL Server SSIS Oracle PL/SQL Developer (Part Time 35hrs (05317)
Brooklyn, NY
24 Months
Job Description:
Develops and implements phases of the computerized system development life cycle, including conceptual design, software development, testing, deployment, and post-implementation enhancements of applications utilizing Visual Studio with SQL Server for data management and Active Directory for identity management, in accordance with Department of Education standards.
Analyze requirements and data access needs and propose file and screen designs. Deploys the applications to multiple environments, from development through Quality Assurance, Staging and Production, and conduct unit and integration testing.
Designs database tables utilizing import or export data from SQL Servers into other data sources on a daily basis through the development and coding of stored procedures and triggers, as needed.
Utilizes Microsoft Team Foundation Server (TFS) for source control, data collection, reporting and project tracking, testing and collaboration of project development.
Develops SQL Server Integration Services (SSIS) packages and Web Services.
Codes new objects (programs) in .net to meet the requirements of the Department of Education.
Conducts user acceptance review sessions and collaborates with other team members to perform debugging
Skils:
1. 84+ Months of experience with MS SQL Server, designing database tables, stored procedures and SQL Server Integration Services (SSIS) packages #of months
2. 48+ Months of experience planning, designing and implementing enterprise data architecture domains to ensure alignment of total Enterprise Architecture with business strategies, tools, guidelines, principles, policies and governance #of months
3. 84+ Months of experience developing data queries, data transformation and load jobs and data extracts in MS SQL Server and PL/SQL (Oracle
#of months
4. 48+ Months of experience with operational and analytical data warehouses and supporting all business requirements for business reporting. #of months
5. 48+ months of experience in the design of data handling and cleansing, standardization procedures and business transformation rules and logic. #of months
6. 24+ Months of experience with Interfaces between SSIS and web services, Enterprise Service Bus (ESB) and message Queue (MQ) Real Time services and batch systems. #of months
7. Bachelor’s Degree #of months
8. Any Microsoft or similar developer certifications #of months