ETL Developer

California  ‐ Onsite
This project has been archived and is not accepting more applications.
Browse open projects on our job board.

Keywords

Description

BB28365

Oakland, CA 94612

3months +

ETL Developer

This ETL Developer position is responsible for development and support of Datawarehouse and Business Intelligence applications using Informatica, Oracle and BI tools.This role will require to closely work with both IT and business users to understand requirements and design the system.

Experience Level: 6+ Years.

Term: 3 months Contract to Hire. Permanent Residents Only.

Responsibilities:
Design and develop ETL jobs in Informatica against Relational databases and Flat files.
Gathering business requirements and creating technical specifications and ETL mapping documents.
Work closely with Datamodelling team and DBAs.
Develop Unix Shell Scripts for jobs automation.
Develop error handling capabilities and Performance tuning.
Develop and execute Unit test plan and support SIT/UAT testing.
Troubleshoot & analyze production issues and provide support (including off-hours at times)
Required Skills/Experience:
6+ years of Datawarehouse and Business Intelligence design and development
5+ years of experience in ETL Development, using Informatica. Informatica 8.6.1 would be plus
Troubleshoot ETL failures, defects and remediate them. Experience in resolving ETL performance issues.
Strong Unix and Windows Scripting skills.
Strong SQL skills and experience with Oracle 10g or later, with a proven ability to perform thorough analysis. Teradata experience a plus.
Knowledge of software development life cycle for Datawarehouse and Business Intelligence projects.
Excellent written and verbal communication skills.
Ability to work independently or on a team with high motivation and quick learning.
Excellent analytical, technical aptitude and proven ability to solve problems and the ability to engage effectively with business and technical teams.
BS degree preferred Associates Degree required

Start date
n.a
Duration
3months +
(extension possible)
From
Enclipse Corp.
Published at
31.08.2012
Project ID:
414205
Contract type
Freelance
To apply to this project you must log in.
Register