ETL Developer

Zoe Staffing

Columbus (OH)

On-site

USD 80,000 - 100,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Zoe Staffing is seeking an experienced ETL Developer for a custom development position in Columbus, OH. This full-time role involves developing ETL processes and working closely with architects and stakeholders to analyze and design the new platform.

The ideal candidate will have over five years of experience in ETL development, strong skills in Korn Shell Scripting, SQL, and experience with Teradata. Excellent interpersonal skills are essential, as collaboration is key to success in this role.

Qualifications

  • Five or more years of experience in ETL process development.
  • Strong interpersonal and communication skills.
  • Understanding of data warehouse architectures.

Responsibilities

  • Develop and refine technical design for ETL processes.
  • Analyze and enhance ETL processes.
  • Develop, test, and implement ETL processes for the new platform.

Skills

Korn Shell Scripting
SQL
Linux / Unix
Teradata
Oracle
PL/SQL
Data modeling
Data cleansing
Performance tuning
ETL processes

Job description

DESCRIPTION: Our client is a leading retailer based in central Ohio with an enterprise initiative to overhaul their data warehouse, business intelligence, and analytic platform.

Job Description

ETL Developer - Custom Development
Full Time Permanent Position in Columbus OH

The business driver for this initiative is to enable the enterprise to make effective decisions based on data, thus reducing risk for the business and enabling agility in the business. This multi-year program involves a new architecture, tools, and processes to build and implement this environment. It also involves conversion from the existing platform.

The manager for the team is seeking a strong developer to build ETL programs and processes for the new platform. This role will involve working with architects, business stakeholders, and team members to analyze the design, and do the detailed technical design and development for new ETL programs. The architecture and design for the ETL environment is custom development using Korn Shell Scripting (KSH), SQL, and related tools. The data warehouse environment is Teradata.

While a high degree of technical expertise is needed, this is not a “heads down” coding position. The successful candidate will have strong interpersonal and communication skills, coupled with five or more years’ experience focused on the development of ETL processes. Technical expertise will focus on KSH, SQL, Linux / Unix, and related skills.

Responsibilities
  • As part of the ETL team, develop, review, and refine technical design for ETL processes.
  • Learn and support the data model and architecture for the new environment.
  • Analyze and enhance ETL processes to determine data sources and destinations.
  • Develop, test, and implement ETL process for new platform.
  • Support the current data warehouse environment as required.
  • Work with business and technology stakeholders to understand business requirements and technology needs.
Qualifications
  • Strong written and oral communication skills. Ability to adapt communications for various audiences.
  • The ability to work as a collaborative team member yet be self-managed and directed as needed. Initiative to take action towards objectives when faced with ambiguity.
  • Exceptional skills developing with Korn Shell Scripting, SQL, and related Unix / Linux tools.
  • Strong database experience with Teradata, Oracle, PL/SQL, and relational and multi-dimensional designs.
  • Typically, four to seven years’ experience working in a data warehouse / BI environment, specifically in custom development of ETL processes.
  • Proven ability to build ETL packages / scripts from scratch. Strong testing skills.
  • Understanding of data warehouse architectures and designs including Star Schemas, Snowflake Schemas, Slowly Changing Dimensions, and Aggregation Techniques.
  • Data cleansing, data modeling, and other data related experience.
  • Performance tuning and optimization experience.
  • Additional experience in Oracle OD / RA, SSIS, MicroStrategy BI, and Message Based integration is a plus.
Additional Information

All your information will be kept confidential according to EEO guidelines.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior ETL Developer - Data Warehouse & BI Platform
Senior ETL Developer - Data Warehouse & BI Platform

Zoe Staffing • Columbus (OH)

On-site
USD 80,000 - 100,000
ETL Developer
ETL Developer

Quantum Technologies LLC • Charlotte (NC)

On-site
USD 90,000 - 120,000
ETL Developer DBA
ETL Developer DBA

BinTech Group • Nashville (TN)

Hybrid
USD 95,000 - 125,000
ETL Developer
ETL Developer

JSM Consulting Inc. • New York (NY)

Hybrid
USD 125,000 - 170,000
ETL Developer / Data Engineer
ETL Developer / Data Engineer

Veriipro • Dallas (TX)

On-site
USD 100,000 - 150,000
Senior ETL Architect
Senior ETL Architect

PSG Global Solutions • Woodbridge Township (NJ)

On-site
USD 110,000 - 140,000
Senior ETL Developer / ETL Architect
Senior ETL Developer / ETL Architect

Global Business Ser. 4u Inc. • Chicago (IL)

On-site
USD 110,000 - 160,000
ETL Developer - 1 year contract - 60/hr Remote
ETL Developer - 1 year contract - 60/hr Remote

ContractStaffingRecruiters.com • Branford (CT)

Remote
USD 90,000 - 120,000
ETL Manager
ETL Manager

Godshall Recruiting • Greenville (SC)

On-site
USD 120,000 - 140,000
Basic Life Insurance
Medical, Dental, & Vision
Annual Bonus
+5
ETL Developer
ETL Developer

Integrated Resources Inc. • Wilmington (NC)

On-site
USD 80,000 - 110,000