The Lead Developer, ETL is responsible for the data integration to support the end-to-end process for streaming services. The streaming services integration includes but is not limited to: metadata, playlist data, OnDemand, direct licensor metadata, MDM integration, consumption, listen crunch and partner payment data. This position works closely with the ETL manager, business intelligence director, ETL and business intelligence developers, various business stakeholders to support and provide quality of delivery for data extraction, transformation and load needs through the development of new and/or enhancement of existing routines.
bachelor's degree or equivalent, relevant experience.
Minimum of 10 years of experience in ETL/ELT development in business intelligence/data integration projects.
Minimum of 10 years of data analysis and data quality.
10+ years of experience working with ETL tools like Informatica, Golden Gate, etc.
10+ years of experience working with Relational Databases such as Teradata, Vertica, Oracle, SQL Server, etc.
5+ years of experience working with Unix Shell Scripts.
Experience with data analysis, data architecture, data cleansing and data quality.
Experience with data integration tools like Informatica, Data Stage.
Experience with databases technologies like Oracle, Teradata and Vertica.
Ensure compliance with all applicable data privacy regulations and policies as they relate to both firm and client/contact data.
Experience in writing complex SQLs to analyze and troubleshoot the issues/problems.