ETL Developer

Position Description:

RealNetworks, Inc. is a rapidly growing, cutting edge technology, web based digital music, online gaming and streaming company headquartered in Seattle, Washington. Real provides the universal platform for the delivery of any digital media from any point of origin, across virtually any network, to any person on any Internet-enabled device, anywhere in the world.The ETL Developer will be responsible for system development, implementation, and administration of all components that make up the Data Warehouse and Business Intelligence infrastructure, applications and related tools. The candidate must demonstrate knowledge of data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, SQL, end-user tools, database and SQL performance tuning. He/she will lead data warehousing projects, and is responsible for the overall technical solution meeting the Business Intelligence needs of the business customers. The candidate must be able to:• Analyze source system data structures and map them to target data warehouse schemas. Must have excellent skills in requirements analysis, data assessment, business process reengineering, and familiarity with data warehousing design concepts such as 3rd Normal Form and Dimensional modeling.• Design, create and tune physical database objects (tables, views, indexes) to support normalized and dimensional models. Maintain the referential integrity of the database.• Work with the ETL lead to formulate ETL approach and appropriately uses Teradata Tools and Utilities• Analyze application and data integration problems, provide solutions and recommend corrective actions.• Serve as a technical expert to the data warehouse project teams and key business individuals for support of applications, tools, data integration, and ad-hoc analytics.Essential Functions: % of Time1. ETL development using Teradata load utilities and stored procedures - 60%2. Logical & Physical Data modeling - 10%3. Post implementation support - 20%4. Unix shell scripting - 10%Knowledge, Skills, and Abilities:Minimum:- 3+ years of programming experience in Unix shell and Perl - 3+ Years experience in Teradata V2R5 or V2R6 RDBMS, SQL, BTEQ and load utilities - Ability to create detailed design documents- Excellent communications and interpersonal skills- Goal oriented and deadline driven- Excellent data analysis skills- Excellent research and problem solving skillsEducation, Certification, and/or Training:Minimum:- BA or BS (or equivalent) in Computer SciencePreferred:- Teradata and Microstrategy certification a plusMinimum Experience:- Experience with ecommerce and financial systems and web log based processing and reporting- Experience with data modelling concepts in a Teradata environmentRealNetworks, Inc., is proud to offer our full time employees an extensive benefits package; including vacation, medical, dental, vision, 401K, an employee stock purchase program and subsidized commuting options. Additional benefits include our charitable matching program, learning and development programs, employee wellness plans and more!

To Apply Visit RealNetworks, Inc.

Qualifications:

Please see above