ETL Developer

Phoenix, AZ 85027

Employment Type: Perm Job Category: SQL Developer Job Number: 19220

Work with designated team to identify, design and implement solutions for extraction and integration of data to and from operational system and the data warehouse for the purposes of reporting, decision support and analysis.

Position Responsibilities:
  • Work with business users to understand and document business and technical requirements to drive design and development
  • Collaborate on the design of physical structure and implementation of database objects
  • Document and build physical database objects from table, column, index and view definitions
  • Develop scripts for the creation of the physical data warehouse tables, views and macros
  • Adhere to data security and protection policies
  • Monitor and troubleshoot Extract-Transform-Load (ETL) and system performance, including optimization and tuning of data loads
  • Understand job and activity schedules to promote optimal performance, maximize availability and minimize data latency and data load duration
  • Provide off hours on-call support to resolve production issues within the stated service level agreement
  • Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations
  • Perform additional duties as assigned
  • Proactively seek opportunities to broaden and deepen knowledge base and proficiencies and share acquired skills with team members through formal and informal channels
  • Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations
  • Ability to multi-task, prioritize workload and communicate timelines clearly      

Position Qualifications:
  • Bachelor’ s degree required
  • 2-3 years’ experience as an ETL developer in data warehouse / business intelligence environment
  • Strong knowledge of data warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes and dimensional modeling
  • Experience with system integration across multiple systems and platforms utilizing various technologies such as ODBC, FTP, Window, Unix/Linus, and AS400
  • Experience working with high volume databases with partitioned data, performance and tuning
  • Experience working with cross functional development, QA, test and production teams
  • Proven track record of meeting project deadlines and delivering high quality consulting service
  • Excellent analytical skills and a proactive approach to problem solving
  • Strong SQL development skills, including complex joins, aggregations, analytical functions, derived tables, stored procedures, triggers and macros
  • Strong application development and programming skills such as SAS, Window batch scripting, Unix/Linux shell scripting or other procedural programming
  • Strong written and verbal communication skills

Send an email reminder to:

Share This Job:

Related Jobs:

Login to save this search and get notified of similar positions.