Title Sr ETL Back-End Developer
Position Sr ETL Back-End Developer
Position ID 02132018MIS
Location Washington, DC
Date Posted 2018-02-13
Description

Title: Sr. ETL Developer/Back end development
Duration: Full time Regular Hire
Location: Washington, DC
Visa: USC/ GC
Experience required: 10 + Year
Mode: F2F

Description: 
The ETL developer will be primarily responsible for implementing ETL processes that populate schemas using a variety of source data on multiple SQL Server 2014 data warehouse implementations supporting multiple products. They will also participate in the requirements gathering process and assist with designing the business process dimensional models.

Required Experience & Skills

Requirements:

  • 10+ years of Experience as a Developer
  • Expertise with Netezza NZSQL, NZPLSQL, External Tables
  • Expertise with Oracle SQL Loader and Data Pump
  • Proficient with Oracle Database Administration on 11g/12c
  • Proficient in SQL development and tuning query performance
  • Proficient with Netezza ETL development including NZLOAD
  • Proficient with Distribution, Zone Maps, CBT
  • Proficient in loading various file formats into an Oracle or MPP database such as Netezza
  • Extensive experience extracting and loading complex XML files
  • Extensive experience with Python
  • Experience with developing, tuning and debugging stored procedures, functions, packages
  • Experience with Unix and Linux shell scripts, and Perl scripts
  • Experience in performance tuning of SQL queries, indexes, partitioned tables, disk I/O, memory, and CPU
  • Experience working with APIs written base on REST/JSON or other technologies
  • Functional knowledge of SAS
  • Familiarity with DataStage 9.1
Education Bachelors or Master’s degree from an accredited institution.
Compensation MARKET
Position Type FULL TIME
Apply Now