Data Warehouse ETL Developer Lead
The Great Atlantic & Pacific Tea Company - Montvale, NJ

This job posting is no longer available on Indeed.


DEPARTMENT: Information Technology

POSITION TITLE: Data Warehouse ETL Developer Lead

POSITION REPORTS TO: Business Intelligence / Data Warehouse Manager

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.
In this role, you will be responsible to:

  • Code, test, modify, debug, document, and implement Ab Initio Graphs utilizing the GDE environment
  • Develop scripts to automate the execution of Ab Initio graphs using shell scripts under Linux environment
  • 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


  • Must have strong demonstrated track record in Ab-Initio coding of large scale ETL applications
  • Broad-based cross-functional IT experience in application design and development is essential in this role using Ab-Initio ETL toolset
  • Must have 3 - 5 years of experience in the design and delivery of ETL solutions in building out of components using Ab-Initio
  • Must have proven track record in implementation and delivery of ETL application delivery
  • Experience in UNIX/Linux/AIX operating environments is required
  • Strong experience in Oracle database and SQL
  • Ability to communicate at all levels of management and with customers. 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:
 Proficient in AbInitio GDE 1.15 or better
 Oracle 11g with strong SQL experience
 Unix / Linux K-shell scripting experience
 Data Warehousing experience
 TOAD or similar database tools