ETL Lead Developer

Guitar Center   •  

Westlake Village, CA

5 - 7 years

Posted 268 days ago

This job is no longer available.

Requirements

ETL Lead - Purpose of the job

As the ETL Lead, you would be responsible for all of the Data Warehouse related Design, Development and BAU Support across the Enterprise.

Required Notes To Hit:

  • Responsible for all aspects of ETL Development, improvements and operations, data model and architectural design, and implementation
  • Lead or participate in business meetings to capture requirements, provide status updates and document the requirements
  • Collaborate, lead, and manage the productivity of the project tasks and work of the offshore team
  • Perform code review of offshore to ensure the quality and efficiency of the code is in alignment with project requirement
  • Knowledge and alignment to enterprise data modeling and data architecture standard methodologies established for Guitar Center, Inc
  • Ensure all aspects of software development are in compliance to SOX and PCI policies for all phases of SDLC and Change Management
  • Lead or assist with application/hardware upgrade and system maintenance support
  • Perform ongoing daily production support tasks, review daily exception email, ad-hoc requests and provide on-call support
  • Additional duties as assigned.
  • Bachelor's Degree is required, preferably in Computer Sceince, MIS or similar.
  • 5+ years of experience ETL process design/development, data modeling, data integration and data migration process design and performance tuning
  • 3+ years of resource management and offshore resource management
  • Expertise in Enterprise Data Warehouse SDLC, standards, and methodology
  • Ability to code/update/tune very complex SQL queries
  • Experience with MPP data warehouse technology, IBM Netezza is helpful
  • Experience with ETL tools, IBM InfoSphere DataStage is helpful
  • Experience in Agile methodologies and implementation is helpful

To join our band you'll need the following experience:

  • Bachelor's Degree is required, preferably in Computer Sceince, MIS or similar.
  • 5+ years of experience ETL process design/development, data modeling, data integration and data migration process design and performance tuning
  • 3+ years of resource management and offshore resource management
  • Expertise in Enterprise Data Warehouse SDLC, standards, and methodology
  • Ability to code/update/tune very complex SQL queries
  • Experience with MPP data warehouse technology, IBM Netezza is helpful
  • Experience with ETL tools, IBM InfoSphere DataStage is helpful
  • Experience in Agile methodologies and implementation is helpful

2577