Direct Client Requirement :: Sr ETL Developer :: Brooklyn, NY

Hello,

 

Please go through the below requirement and let me know on recruiter@tcagroupmail.com if you are comfortable or not. 

 

Role: Sr ETL Developer   
Duration: About 24 months
Location: Brooklyn, NY

 

Only Local Candidates with GC/EAD-GC/USC

 

Job Description:
The New York City Department of Education is seeking (1) Senior ETL Developer to assist in the transition of a vendor managed application to a NYCDOE managed application, Special Education Student Information System (SESIS).

SESIS (Special Education Student Information System) is a case management customized vendor solution which is utilized by numerous personnel to manage over 200,000 Special Education Students in over 1600+ public and non-public schools.

The Senior ETL Developer will be responsible for, but not limited to, the following:

·                     Work with the DIIT (Division of Information and Instructional Technology) Data team to facilitate the implementation of SESIS Data Architecture

·                     Support the Vendor's analysis, design, build, test and documentation of the complex SESIS Data Conversion and Integration solutions

·                     Support user acceptance test activities for the SESIS Data Conversion and Integration solutions

·                     Design and develop ETL code using Microsoft SSIS ETL tool for the definition, development and testing of the processes and programs necessary to extract data from the various data sources

·                     Monitor vendor activities related to SESIS Data Conversion and Integration

·                     Perform vendor deliverable review and approval for SESIS Data Conversion and Integration

·                     Work with other data analysts, business users and IT professionals to ensure that data requirements are met with the highest degree of integrity and efficiency that is practical and cost effective

Ensure that documentation is captured, maintained, understood by and available to business and/or IT partners

·                     Participate in, or facilitate, business process and requirement sessions to ensure that the vendor fully understands the requirements and the data necessary to support those requirements

·                     Develop, Test and manage ETL jobs to specifications and design

·                     Escalate critical technical issues and potential problems as needed to the SESIS Project Manager to address any SESIS related issues in advance of deadlines

·                     Participate in focus group sessions as needed for information discovery.

 

Required Skills

·                     Demonstrated experience in designing and documenting conversion and interface specifications

·                     Extensive knowledge and experience in MS SSIS and .NET technology (must have)

·                     ETL design and development skills and technical documentation experience

·                     Proven knowledge/experience in ETL performance tuning

·                     Minimum of 8 years of experience with ETL and data quality tools

·                     Sound knowledge of SQL and RDBMS, including MS SQL Server and Oracle

·                     Proven ability to produce high quality, bug free and highly scalable work

·                     Excellent analytical skills, detail and process-oriented

·                     Proven ability to coordinate activities with business and technical teams

·                     Excellent communication skills

·                     Prior experience with Legacy data conversion and cleansing highly preferred

·                     Minimum of 8 years of experience with SQL, T-SQL, PL/SQL and SSIS in SQL Server and Oracle

Desired Skills

·                     Prior experience working on large IT vendor supplied Commercial Off the Shelf (COTS) deployment projects for the Education Dept. or Government.

·                     Education (K -12) experience, especially knowledge of Special Education is preferred.

·                     Knowledge and experience in managing data warehouse and ODS development design, analysis capability and deployment.

·                     Demonstrated experience in all facets of the Software Development Life Cycle using an iterative development approach such as Agile, including all forms of threat/risk assessment to ensure the software meets the goal of being secure for sensitive information.

Must be self-sufficient in Microsoft Office, Project and SharePoint Portal Services.  The successful candidate must possess the ability to build document templates and customize SharePoint portal services to the needs of the project.

 

Thanks,
Shalin
TCA Consulting Group Inc.
recruiter@tcagroupmail.com
Mobile: 704-954-8008