Vacancy caducado!
ETL Developer / Architect of Application Modernization and EnhancementsNew York City, NYJoin our Talent NetworkChenega Technical Innovations is currently seeking talented individuals to add to our Talent Network.ETL Developer / Architect of Application Modernization and Enhancements Summary: TheETL Developer / Architect of Application Modernization and Enhancements is a key contributor to the success of the New York City Department of Education program for CTI. TheETL Developer / Architect of Application Modernization and Enhancements is a part of a dynamic team supporting the Information Technology initiatives and projects supporting over 1.1 million children across 1800 schools. The ETL Developer / Architect of Application Modernization and Enhancements collaboratively supports parents, educators, school communities, and external stakeholders to improve student achievement and ensure that every child graduates from high school prepared for college, a career, and a future as a productive, critically thinking adult.Duties and Responsibilities: Manage requirements gathering and analysis for new and existing projects.Support Microsoft SQL Server 2012/2014/2016 databases across all environments.Support Microsoft SQL Server 2012/2014/2016 replication feature widely used by different applications.Support Oracle DBs across all environments.Support Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance.Implement and support Microsoft Clustering Services both on the SQL Server and System levels.Install and configure Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers.Monitor Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance.As an expert, create, design, manage and troubleshoot SSIS and DataStage packages.Monitor and troubleshoot ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools.Utilize SQL in creating, designing managing and troubleshooting in Microsoft SQL Server and Oracle.Maintain error and system maintenance logs.Perform OLAP and OLTP data modeling with the ERWIN data modeling tool.Support Operational data model and data mapping.Support the development and maintenance of DIIT/STARS data dictionary.Manage and support DB2 relational system and troubleshoot issues on the DB2 System.Administer DB2 Connect, DB2 Gateway in different ETL set up.Other duties as assignedMinimum Qualifications: 8+ years of experience with the following:DataStage and SSIS ETL DevelopmentComplex ETL Job ArchitectureRDBMS Concepts and Writing Complex Stored Procedures and SQL in Oracle and MS SQL ServerPerforming Complex Tasks/Work with Little or No SupervisionFull Lifecycle Staging, ODS, Data Mart and DWH Experience in ETL Data Integration in Large Scale ProgramsShell/Power Shell/Bash Script Program Development2+ years of experience in the following:Design and Code Interfaces to DOT NET, XML, and MS Dynamic CRMJoin our Talent Network
Vacancy caducado!