advertisement
NEW YORK & COMPANY logo
Organization
Job Title
DATA WAREHOUSE ETL UNIX DEVELOPER
Location
New York, New York
Country
United States
Region
NY Metro
Reference Number
483
Position type
Permanent
Category
Retail
Job Function
Information Technology
Experience level
Mid to Senior Level

DATA WAREHOUSE ETL UNIX DEVELOPER

DEPARTMENT:

Information Technology

REPORTS TO:

Business Intelligence & Customer Analytics Director

OVERVIEW:

The candidate must be self-motivated with a strong background in technology with a proven ability to translate business needs into data rich, enabled applications and interfaces. Technical and intellectual curiosity is required, along with the ability to pick up concepts and techniques quickly in order to execute projects and solutions. Technical debugging and problem resolution are important components of the position. As we work with diverse datasets, deep understanding of data architecture, ETL, and query optimization is required. While this role is primarily as an ETL developer, it will require performance and understanding across all aspects of project lifecycle.

RESPONSIBILITIES:

  • Proficiency in writing advance SQL and shell scripting under AIX and Linux environments
  • Code, test, modify, debug, document, and implement shell scripts
  • Develop technical specification documents
  • Assist in developing test cases/plans to complete the unit testing and support System testing
  • Participate in design reviews / code reviews and ensure that all solutions are aligned to pre-defined architectural specifications; identify/troubleshoot application code-related issues; and review and provide feedback to the final user documentation.
  • Adhere to deployment code migration strategies from one environment to another
  • Strong analytical and problem solving skills with production support experience.
  • Assume ownership and accountability for the assigned deliverables thru all phases of the development lifecycle

REQUIREMENTS:

  • Must have strong demonstrated track record in SQL coding of large scale ETL applications
  • Broad-based cross-functional IT experience in application design and development is essential in this role
  • Must have 3 years of experience in the design and delivery of ETL solutions in building out of components using Kshell scripts
  • Must have proven track record in implementation and delivery of ETL application delivery
  • Experience in UNIX/Linux/AIX operating environments is required
  • Experience in Teradata/Oracle/SQLServer databases
  • Ability to communicate at all levels of management and with peer associates. Demonstrated skills both written and oral are required
  • Experience in the development of retail business solutions is a strong plus

Ideal Candidate Attributes

  • Self-starter with a strong work ethic
  • Exhibits leadership
  • Possesses advanced analytical and problem solving skills
  • Strong organizational and prioritizing skills
  • Ability to multi-task and handle multiple priorities
  • Embraces team-based approach
  • Proactive, strong, clear communication skills
  • Strives for Continuous Improvement

Skills / SoftwareRequired:

  • Teradata 15.x with strong SQL experience, as well as Oracle/SQLServer experience
  • Unix / Linux K-shell scripting experience
  • Data Warehousing experience
  • Familiarity with database tools ( SQL Assistant / TOAD / /SQL Workbench)
  • Familiarity with SSIS ETL Tool (a plus)
  • Familiarity with Control-M job scheduler (a plus)

 

advertisement
advertisement