NHL League

NHL League Careers

ETL Developer with National Hockey League in New York City , NY

National Hockey League jobs
Sports Jobs in New York City , NY
Technical Services: Network Administration/Services
Apply with MVP Access
Want to improve your application?

Learn More

SUMMARY 
The National Hockey League (New York City) is looking for a seasoned ETL Developer with hands-on experience with Talend.  This ETL Specialist will be responsible for the development and enhancement of their Fan Data Warehouse.  In this role, you will be interacting with stake holders, business analysts, and other developers on the refinement and integration of customer data from various sources, ensuring that source data can be integrated and represented properly.
 
ESSENTIAL DUTIES 
  • Ability to create and manage sophisticated Talend workflows that import, validate, and cleanse data from various sources including relational databases, .csv files, and feeds (e.g. JSON, XML).
  • Test and troubleshoot workflows by using the debugging functionality provided with Talend Open Studio.
  • Develop guidelines and standards for ETL usage, manageability and maintainability.
  • Profile and understand the various source data available, including structured and unstructured web/mobile activity data.
  • Work closely with business and technical teams to understand, document, design, develop, code, and test ETL processes.
  • Establish and maintain working relationships with technical and architectural team members across the technology organization.
  • Ownership and maintenance of all existing and future ETL jobs for external data sources.
  • Validate ETL jobs against business use cases.
  • Develop and deploy all post-production enhancements.
  
QUALIFICATIONS 
The ideal candidate will possess the following:  
  • 5+ years of hands-on ETL development experience. (Talend/Informatica/DataStage)
  • Ability to implement ETL best practices to provide strong end-to-end solutions.
  • Experience with data loads into relational databases a must. (Oracle/Teradata/SQL Server/My SQL)
  • Advanced SQL experience (Nested Queries, Complex Joins, Analytic Functions) a must.
  • Solid understanding of Data Modeling and Data Warehousing principles.
  • Experienced in testing, debugging, and tuning of any ETL bottlenecks.
  • Experience in Real Time processing and Big Data tools like Hive, Spark a plus.
  • Experience with Talend MDM 6.x a plus.
  • Experience with Hadoop/HDFS clusters a plus.
  • Experience with SAP BW/SAP HANA/SAP Hybris is a plus.
  • Experience with Tableau is a plus
  • Strong verbal and written communication skills.
  • Must be a self-starter and adaptable to changes in priorities.
  • Strong problem-solving skills.
  
When applying, please be sure to include a cover letter with your salary expectations for his role.  We thank all applicants for their interest in this opportunity, however only qualified candidates selected for an interview will be contacted.  NO EMAILS OR PHONE CALLS PLEASE. 
 
 

Job Questions:

  1. How did you hear about this job?

  2. This position is in NYC. If necessary, are you able to relocate at your own expense? (The NHL does not pay relocation fees.)

  3. Do you have the legal right to work in the United States?

  4. What are your salary expectations for this position?

  5. What Cloud Solutions, if any, do you have experience with? Please explain.

  6. How many years of ETL Development experience do you have?

  7. On a scale of 1 to 5 (5 being an expert), do you have solid understanding of Relational and Dimensional Models and ETL methodologies?

  8. On a scale of 1 to 5 (5 being an expert), how would you rate your knowledge of industry standard ETL Tools ? Talend, Informatica preferred but please specify.

  9. Have you worked on any other ETL Tools other than Talend or Informatics? If so, which tools?

  10. How many years of SQL Development experience do you have? What databases have you worked on? (MySQL and Teradata preferred).

  11. Do you have at least 5 years of advanced SQL experience?

  12. If so, on a scale of 1 to 5 (5 being an expert), how would you rate your knowledge of SQL?

  13. Do you have experience creating Unix Shell scripts? If so, on a scale of 1 to 5 (5 being an expert), how do you rate your expertise in Unix shell scripting?

  14. Do you have experience with SAS? If so, on a scale of 1 to 5 (5 being an expert), how do you rate your expertise in SAS?

  15. Do you have experience using Python scripting? If so, on a scale of 1 to 5 (5 being an expert), how do you rate your expertise in Python?

  16. Do you have experience using OLAP cubes? If so, on a scale of 1 to 5 (5 being an expert),how do you rate your expertise in OLAP cubes?

  17. Do you have experience using Tableau cubes? If so, on a scale of 1 to 5 (5 being an expert),how do you rate your expertise in Tableau?

Apply with MVP Access
Want to improve your application?

Learn More