ETL Architects - New York

Company: Athreya Inc
Other Job Openings at the Company: The company has other active jobs (2081)
Your Application: You have not applied yet
Location: New York, USA
Job Description:

Hi,

I hope you're doing well. We have an urgent requirement for ETL Architects with our state client in NYC. Please go through the below job description and send your updated resume to rakesh@athreyainc.com " target="_blank" rel="nofollow,noindex" onclick="trackEx(262447240,this)"> rakesh@athreyainc.com or call me at 732-582-4977 to discuss further.

Role: ETL Architects

Duration: 36 Months+

Location: NYC, NY

Job Description:

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 the Operational data model and data mapping. Supports the development and maintenance of the 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.

Skills/Experience:

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

Regards

Rakesh Sharma

Direct : (732) 582-4977

Email:  rakesh@athreyainc.com " target="_blank" rel="nofollow,noindex" onclick="trackEx(262447240,this)"> rakesh@athreyainc.com

ATHREYA INC.

100 Jersey Avenue, Suite# B-201,

New Brunswick NJ - 08901.

"Certified Minority Business Enterprise (MBE)"

"Certified Small Business Enterprise (SBE)"

"E-Verify Enrolled Employer"

URL:  www.athreyainc.com

STATEMENT OF CONFIDENTIALITY

The information contained in this electronic message and any attachments hereto are intended for the sole and exclusive use of the addressee(s), and contain confidential and/or privileged information. If you are not the intended recipient of this transmission you are hereby notified that any disclosure, copying, distribution or the taking of any action in reliance on the contents of this transmission is strictly prohibited. If you have received this in error, please notify the sender of this message immediately, and destroy all copies of this message and any attachments.

"There is no power on earth that can neutralize the influence of a high, simple, and useful life."

~ Booker T. Washington



Salary: Negotiable

Job Requirements:
Minimal experience: No experience


Jobs you may be interested in





    Tips You May Be Interested In