ETL Developer / Architect

Manages requirements gathering and analysis for new and existing projects.
Supports Microsoft SQL Server 2012/2014/2016 databases across all environments.
Supports Microsoft SQL Server 2012/2014/2016 replication feature widely used by different applications.
Supports Oracle DBs across all environments.
Supports Microsoft Windows 2012 and 2016 Enterprise Servers including configuration and maintenance.
Implements and supports Microsoft Clustering Services both on the SQL Server and System levels.
Installs and configures Microsoft SQL Server 2012/2014/2016 and Microsoft Windows 2012 and 2016 servers.
Monitors Microsoft SQL Server activity on a proactive basis and tune the system for optimal performance.
As an expert, creates, designs, manage and troubleshoots SSIS and DataStage packages.
Monitors and troubleshoots ETL jobs daily using BCP, DTSRUN, SSIS and other Performance Monitoring tools.
Utilizes SQL in creating, designing managing and troubleshooting in Microsoft SQL Server and Oracle.
Maintains error and system maintenance logs.
Performs OLAP and OLTP data modeling with the ERWIN data modeling tool.
Supports Operational data model and data mapping.
Supports the development and maintenance of DIIT/STARS data dictionary.
Manages and supports DB2 relational system and troubleshoot issues on the DB2 System.
Administers DB2 Connect, DB2 Gateway in different ETL set up.

Project Specific Technical Requirements:

8+ years of experience with the following: DataStage and SSIS ETL Development Complex ETL Job Architecture RDBMS Concepts and Writing Complex Stored Procedures and SQL in Oracle and MS SQL Server Performing Complex Tasks/Work with Little or No Supervision Full Lifecycle Staging, ODS, Data Mart and DWH
Experience in ETL Data Integration in Large Scale Programs Shell/Power Shell/Bash Script Program Development
2+ years of experience in the following: Design and Code Interfaces to DOT NET, XML, and MS Dynamic CRM