*SSIS Developer W .Net F2F in Brooklyn, NY * *Location –Brooklyn, NY 11201 - (LOCAL CANDIDATES ONLY- in person interview will be required)*
*Duration – 2 years + possible extensions* *This is a 7 hours/day or 35 hours/day project* 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 & Regards* Sunny Mehta Sage Group Consulting Inc. Direct: 732-784-6481 Office: 732-767-0010 Extn: 601 Email: sme...@sagetl.com GTalk: sunny.recruiter2012 | Skype: sunnymehta89| Yahoo: sunnymehta89 -- You received this message because you are subscribed to the Google Groups "USITCV" group. To unsubscribe from this group and stop receiving emails from it, send an email to usitcv+unsubscr...@googlegroups.com. To post to this group, send email to usitcv@googlegroups.com. Visit this group at https://groups.google.com/group/usitcv. For more options, visit https://groups.google.com/d/optout.