Please go through the below requirement and let me know on 
recrui...@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 
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 

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

·                     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 
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 
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 

·                     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 


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 

·                     Proven knowledge/experience in ETL performance tuning

·                     Minimum of 8 years of experience with ETL and data 

·                     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 
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.


TCA Consulting Group Inc.
Mobile: 704-954-8008

You received this message because you are subscribed to the Google Groups "Open 
Source Erp & Crm" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to open-source-erp-crm+unsubscr...@googlegroups.com.
To post to this group, send email to open-source-erp-crm@googlegroups.com.
Visit this group at https://groups.google.com/group/open-source-erp-crm.
For more options, visit https://groups.google.com/d/optout.

Reply via email to