Security Clearance Jobs for Defense and Intelligence Careers

Questions? Call Us 888-725-6997


View Job

ETL Developer / Architect

ABBTECH Professional Resources Inc. | Brooklyn NY 11201 USA | Full Time | Posted: 07/13/2020

Job Descriptiontop

ETL Developer / Architect (# LB19053)

Brooklyn, New York 11201

No clearance required but must pass background check to be placed


This is for a proposal, but interviews will come from whom is found in this search.  Interviews are expected to be done in 6 – 10 weeks.  Start dates will follow soon after. 


Scope of Work:


  • 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 in the following: 

o   DataStage and SSIS ETL Development

o   Complex ETL Job Architecture

o   RDBMS Concepts and Writing Complex Stored Procedures and SQL in Oracle and MS SQL Server

o   Performing Complex Tasks/Work with Little or No Supervision

o   Full Lifecycle Staging, ODS, Data Mart and DWH Experience in ETL Data Integration in Large Scale Programs

o   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



  • This is an excellent opportunity that provides plenty of growth potential with fantastic on-the-job learning and mentorship.
  • ABBTECH also offers Medical, Dental, Vision, sick leave, paid holidays, vacation time, and 401K benefits for all full-time employees.
  • ABBTECH offers weekly pay.


Please send updated resume to:

Katherine Ransom

National Technical Recruiter

ABBTECH Professional Resources

Mobile Phone – 571-748-8385

Texting - 571-348-4903


ABBTECH is an EOE/Minorities/Women/Disabled Individuals/Veterans


Job Detailstop

Location Brooklyn, NY, 11201, United States
Categories Professional
Sec Clearances Other

Location Maptop

Contact Informationtop

Contact Name Katherine E. Ransom
How to apply A resume is required to apply to this job. Applications are sent to employer via email. Click on the link below and follow instructions.
Apply Click Here (apply to job)
Primary Phone 703-489-0263
Job Code LB19053