Senior ETL (Ab Initio) Developer

The NPD Group, ( http://www.npd.com/) founded in 1967, provides global consumer and retail information that helps manufacturers and retailers make more informed, fact based decisions in order to optimize their business. Many of the world’s most successful companies rely on us for insight on what is selling, where and why so that they can understand and leverage the latest trends.

NPD products and services deliver unique market perspectives by combining consumer information with point-of-sale data collected from retailers and other distribution channels. The result is market intelligence with both strategic and tactical advantages: comprehensive information on key retail channels and consumer demographics, plus granular detail on specific products, features and pricing.

Our clients encompass more than 1,400 businesses, including many Fortune 500 companies. NPD has approximately 600 Retailer Partners, representing over 120,000 doors worldwide. Our worldwide offices and partnerships span more than 60 countries.

Job Description:

 

This position will be part of our dynamic and fast paced development team, and mainly responsible for metadata collection and delivery, data quality control process and release management for the ETL team.

 

Major Responsibilities:

 

q Gather requirements from different application groups and business analysts to design metadata standards and collection process.

q Create Ab Initio Enterprise Metadata repository and related web interface to store and deliver metadata information.

q Manage and administrate metadata access and security requirements for the repository.

q Manage ETL test/staging environment and metadata promotion to production environment as the Release Manager.

q Design extract, transform and load (ETL) components and process flow using ETL tool Ab Initio to upload and download metadata from various applications.

q Develop, test and automate metadata upload/download, data quality control applications, release procedures using various technologies available, including Abinitio, Oracle SQL and PL/SQL, Unix Shell Scripts, and Perl.

q Work independently in the development, testing, implementation and maintenance of systems of moderate-to-large size and complexity.

q Document metadata standards and designs, data quality control processes and production release procedures.

q Provide detailed analysis of problems and recommends solutions to the team developers regarding ETL development standards and best practices.

 

Educational Requirements:

 

BS in Computer Science, Engineering, Management Information Systems, or related fields.

 

Required Skills or Experience

 

q Experience with ETL development using Ab Initio.

q Experience in designing, implementing and creating custom schema using Ab Initio EME.

q Experience in loading and unloading metadata components in Ab Initio EME.

q Minimum 5+ years of programming experience working with UNIX environment

q Solid programming experience with shell scripts and/or Perl.

q Familiar with DBMS table design, loading and tuning principles, and experienced in SQL and stored procedures.  RDBM can be Oracle, MS SQL Server, DB2 or Sybase.

q Any experience in SAS is a plus.

q Experienced with formal software development life cycle. 

q With strong analytical and problem solving skills

q With the ability to work effectively with other team members.