 |
back to listings
search our database
 EMPLOYERS
please contact us |
|
|
|
|
|
| |
| |
Job ID# |
LJCITETL000776 |
| |
Job Location |
New York, New York |
| |
Job Title |
Senior ETL Engineer
|
| |
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. Gather requirements from different application groups and business analysts to design metadata standards and collection process.
Create Ab Initio Enterprise Metadata repository and related web interface to store and deliver metadata information. Manage and administrate metadata access and security requirements for the repository. Manage ETL test/staging environment and metadata promotion to production environment as the Release Manager.
Design extract, transform and load (ETL) components and process flow using ETL tool Ab Initio to upload and download metadata from various applications. 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. Work independently in the development, testing, implementation and maintenance of systems of moderate-to-large size and complexity.
Document metadata standards and designs, data quality control processes and production release procedures. Provide detailed analysis of problems and recommends solutions to the team developers regarding ETL development standards and best practices. Competitive compensation package.
Comprehensive benefits package. |
| |
Qualifications |
Experience with ETL development using Ab Initio, Informatica or Data Stage. Experience in designing, implementing and creating custom schema using Ab Initio EME.
Experience in loading and unloading metadata components in Ab Initio EME or metadata with other ETL and BI tools.
Minimum 5+ years of programming experience working with UNIX environment. Solid programming experience with shell scripts and/or Perl. 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. Any experience in SAS is a plus.
Experienced with formal software development life cycle. With strong analytical and problem solving skills. With the ability to work effectively with other team members. |
| |
Skillsets |
Abinitio, Business Object, Data Architect, Data Modeler, Data Warehouse, DB2, Engineer, ETL, Oracle, RDBMS |
| |
Company
Description |
Leading global provider of consumer marketing research.
|
| |
Contact Email |
|
|
 |
|
|
|
|
|
client
services
