Datawarehouse Developer/ETL Architect

Overview

Hybrid
Depends on Experience
Accepts corp to corp applications
Contract - Independent
Contract - W2
Contract - 1 Year(s)
No Travel Required

Skills

Business Intelligence
Computer Science
DBMS
Data Warehouse
Datawarehouse
Datawarehouse Developer
ETL
HDFS
Hadoop
Linux
MPP
RDBMS
UNIX
database design
problem - solving
problem - solving skills
trouble - shooting

Job Details

  • Our data captures the who, what, when, where and why of how our clients use Company products. As the Enterprise Data Warehouse and Business Intelligence team, we are responsible for ingesting and preparing massive amounts of data for reporting, dashboards, self-service and advanced analytics. The data will also be used to drive new businesses within Company by providing new insights.
  • What's in it for you?
  • Are you motivated to build robust and scalable systems to handle petabytes of data, with billions of new data points being ingested daily? As a hands-on ETL architect and developer you will be working with traditional and modern technologies to enhance our capabilities to analyze large volumes of data with complex business rules. You will work with the business to elicit requirements and implement them in an agile fashion. Our environment combines traditional warehouse technologies, MPP databases, Hadoop, and other technologies.
  • Need to have:
  • 5+ years of experience with DBMS, ETL tools
  • Advanced SQL capabilities are required. Knowledge of database design techniques and experience working with extremely large data volumes is a plus.
  • Programming experience in Python
  • Scripting experience using Shell
  • Familiarity with Hadoop ecosystem (HDFS, Spark)
  • Strong problem-solving skills and trouble-shooting skills
  • BA, BS, MS, PhD in Computer Science, Engineering or related technology field
  • Nice to Have:
  • Knowledge of RDBMS, MPP systems
  • Familiarity with ETL tools like Informatica
  • Experience with Airflow for orchestration
  • Experience with creating and maintaining BAS services
  • Experience working in a UNIX or Linux development environment

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.