Data Warehouse ETL Developer
New York, NY
Posted Apr 12, 2016 - Requisition No. 49430
Sales and Analysis is responsible for a 3 TB SQL Server data warehouse, which will grow to over 20 TB in size within the next 12 months. This houses some of the company's most important information, ranging from sales leads to marketing information, and is used to meet the daily needs of the Customer Analytics team. If someone wants to perform analysis on how successful a source is for sales leads, they come to us.
You will connect different types of data to help analyze product usage and marketing efforts. In addition to ensuring that there's no hiccup in daily processes, you will work with product owners to gather requirements, manage scope and craft a maintainable solution. We offer flexibility in the way that you solve problems, while maintaining our goal to create a better product.
You'll need to have:
- 5+ years of data warehousing experience
- A solid understanding of database concepts and data warehousing implementation
- Strong skills in MS SQL Server (stored procedures, performance tuning)
- Knowledge of Informatica
- Familiarity with Linux/shell scripting
- Very Large Database and DW Implementation experience
We'd love to see:
- MS SSIS experience
- MPP database experience (Greenplum)
- Data modeling skills (ERwin, ER/Studio)
- An understanding of BI Reporting Tools (Cognos, QlikView)
- Knowledge of the Hadoop ecosystem including HDFS, HBase, Hive, Sqoop or Spark
- Programming experience in Java, C++ or Python