ETL Developer III

US-TX-Arlington
Requisition ID
2017-30277
Employee Type
Full Time-Regular
Category
Information Technology

Overview

The ETL Developer III is responsible for extracting, transforming and loading (ETL) the data warehouse. The ETL Developer III will develop, maintain and support the enterprise data warehouse system and corresponding data marts. This team member will analyze and review complex object and data models and the metadata repository in order to structure the data for better management and quicker access. The Developer III will be competent to perform at the highest level for all phases of data warehouse technologies and loading techniques.

Responsibilities

JOB DUTIES:

  • Execute complex data loading techniques for all data warehouse load projects which includes extracting a desired subset of data, transforming and converting data, creating mappings from source tables to destination tables, and writing and loading the result data into a target database table.
  • Write moderately complex SQL code to extract, transform, and load data ensuring compatibility with all tables and customer specifications with limited supervision.
  • Facilitate and monitor data warehouse performance.
  • Work with various levels of software developers to load data into the data warehouse and identify potential problem areas in the source system.
  • Actively pursue areas of improvement for data loading techniques and/or population order.
  • Work with internal business clients to problem solve data loading or integrity issues.
  • Collaborate with the data modeling team to understand, interpret, and implement moderately complex data warehouse requirements.
  • Ensure metadata repository is accurate and updated regularly.
  • Perform data load monitoring and resolution.
  • Implement effective problem resolution action plans.
  • Troubleshoots and tunes existing data warehouse applications to ensure increased efficiency and process improvements.
  • Lead the creation, execution, and rearranging of sessions; monitoring the load times of sessions; and rearranging of processes to increase the efficiency and effectiveness of the loading process.

 OTHER IMPORTANT DUTIES

  • Guide and assist less experienced developers with complex data warehousing tasks.
  • Ensure stability of source target application.
  • Follow up with customers to ensure the data warehouse is meeting their specific demands in terms of analysis, content, presentation, and ease-of-use.

REPORTING RELATIONSHIP:

Reports to: Data Warehouse Technologies Manager

Subordinates: None  

Qualifications

Knowledge

  • Comprehensive understanding and working knowledge in Data Warehouse loading, tuning and maintenance.
  • Advanced understanding of Informatica, SQL, Oracle and/or similar tools.
  • Working knowledge of loading techniques for RDBMS.

Skills

  • Good oral and written communication skills.
  • Advanced analytical skills.
  • Should be proficient with Informatica or related tools, with an ability to write moderately complex SQL database queries.
  • Must have the ability to multi-task and organize projects.
  • IDQ, Big Data experience and/or hand coding experience in Java or similar language is a plus.
  • Ability to work independently.

Experience

  • Bachelor’s degree in Information Systems, Computer Science or equivalent work experience required.
  • Five or more years overall experience in Data Warehousing extracting, transforming and loading.        

 

WORK CONDITION:

Professional office environment. Position requires occasional overtime, travel, carrying a pager and some evening work.

Options

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.
Share on your newsfeed

Need help finding the right job?

We can recommend jobs specifically for you! Click here to get started.