Skip navigation
ETL Developer

ETL Developer

Job Description

Large retail organization with locations nationwide has a position of ETL Developer. This position requires working knowledge of SQL Server 2008, SSIS, and data warehousing.
Competitive salary and a comprehensive benefit program. Details of this position are:


Summary

Primary focus of this position is to provide ETL support to the Business Intelligence team. Day to day activities will include, but not be limited to…migrating source data into the data warehouse, designing and deploying consolidation and summary tables, systematic auditing of load processes, creating batch process automation, and analyzing source data from various applications for business intelligence initiatives. Prefer knowledge of or ability to learn Netezza.

This position will be responsible for the operational tracking of automated batch load and reporting processes, and will act as the backup SQL Server DBA.

Essential Duties and Responsibilities (include the following, other duties not listed may be assigned)
  • Identify and extract appropriate tables from source applications. 
  • Automate load and audit processing.
  • Assess existing data loads for efficiency and streamlining opportunities.
  • Act as backup for the SQL Server DBA. 
  • Provide operational monitoring of the automated load/report processing.
  • Research, design, develop, and deploy load processes for the migration of data from source applications into the data warehousing environment.
  • Design and deploy consolidation and summary tables within the data warehousing environment. 
  • Perform periodic performance assessments of the automated load processes. 
  • Documentation and standardization of deliverables.

Job Requirements

Education and/or Experience
  • Degree in Computer Science, Information Technology or combination of work experience.
  • Experience with SQL Server and related tools, particularly SSIS…within a data warehousing environment.
  • Experience with SQL Server, ETL Development, and Windows Servers.
  • Experience with SQL creation, troubleshooting, and tuning.
  • Experience in performance tuning within both the ETL process(SSIS) and the database(SQL Server).
  • Ability to conduct analysis of source data sets to achieve target data set objectives.

Experience would include a minimum of 4 CONTIGUOUS years of the following skills:
  • SSIS based ETL design, development, tuning.
  • SQL Server database design, development, tuning.
  • Windows server environment, scripting, operating at command line.
  • STRONG VERBAL COMMUNICATION is a MUST. Interacting with business community/users is a core requirement of the role.

Additional requirements:
  • Candidate MUST possess a strong initiative and requires minimal supervision.
  • Retail experience is a plus.
  • Netezza experience is a plus.
  • Experience in the migration of data from SQL server into a data warehouse appliance (Netezza, Teradata) is a strong plus.
  • Experience with Microstrategy is a plus.
  • A candidate with experience working with terabyte sized data warehouses and complex ETL mappings that process 50+ million records per day is preferable.
  • Experience deploying STAR schemas is a plus.

Language / Writing Skills
  • Strong, concise and grammatical oral and written communication skills.
  • Mathematical Skills
  • Basic math skills
  • Reasoning / Analytical Ability
  • Complex problem solving skills
  • Initiative to develop efficiencies and process improvements
  • Documentation

Job Snapshot

Employment Type Full-Time
Job Type Retail
Education Not Specified
Experience Not Specified
Manages Others Not Specified
Industry Retail
Required Travel Not Specified
Job ID 165
CareerBuilder Tip:
For your privacy and protection, when applying to a job online, never give your social security number to a prospective employer, provide credit card or bank account information, or perform any sort of monetary transaction. Learn more.

By applying to a job using CareerBuilder.com you are agreeing to comply with and be subject to the CareerBuilder.com Terms and Conditions for use of our website. To use our website, you must agree with the Terms and Conditions and both meet and comply with their provisions.

ETL Developer


Enter notes about this job:

Cancel