Job Description

ETL Developer in Metro Oakland, CA

Location:

OaklandCalifornia

Date Posted:

11/12/2019

Employment Type:

Consulting

Recruiter:

Anna Wu

Recruiter Email:

anna.wu@avidtr.com

Job ID:

JN -112019-13743

Job Description

Using the Informatica - PowerCenter development tool and SQL, to develop a large enterprise data warehouse which will be used for Payroll reporting, employee planning, and other new initiatives. This position performs a senior developer role in the development and support of large/complex data warehouse solutions. This position will work with a variety of functional and report developer roles as well as Solution Architects. 

The individual must possess strong communication and analytical skills so that they can communicate effectively with different Competency Centers. A complete understanding and proficiency of Informatica - PowerCenter 9.x is mandatory as well as a strong working knowledge of SQL (Structured Query Language) for data analysis. 

Has strong technical expertise and provides scoping, estimating, planning, design, development, and support services to a project. Performs other duties as assigned.  
Qualifications: 
-5 or more years of hands-on experience developing ETL with Informatica PowerCenter. 

-5 or more years of experience in analyzing, designing, coding, testing, implementation, documentation and maintaining complex ETL routines. 

-3 or more years of experience in developing PL/SQL procedures. 

-3 or more years of experience with Unix shell scripting. 

-SQL performance tuning experience is required. 

-Experience in Data Quality, Source Systems Analysis, Business Rules Validation. 

-Target Mapping Design and High Volume Data Loads. 

-Experience with Data Warehouse development. 

-Experience with Oracle. 
Preferred  
-Experience in Higher Education is a plus. 

-Experience in HR, Payroll and Financial enterprise systems data structures such as PeopleSoft is desirable. 

-Experience with Agile development is preferred.
Apply for this job