Informatica ETL Developer (Heads Up)
Herndon, VA

Job Description

Informatica ETL Developer

Location: Herndon, VA

Duration: 1 year with possible extension

Description:

Provides technical direction in the maintenance and development of the extract transform and load (ETL) aspects of the data warehouse. Maintains an understanding of the inputs received from the data source providers. Performs analysis, design, development, and implementation of new ETL requirements. Recommends changes to enhance the data warehouse data cleansing, and conversion processes. Supports testing and validation of the new data conversion processes. Responsible for planning, and monitoring schedule milestone and deliverables for assignments. Possesses strong SDLC experience and manages appropriate levels of systems documentation as required.

Required Skills:

8 years of Experience with Informatica PowerCenter

8 years of Experience with Informatica Data Quality

4 Years of Experience with Informatica Power Exchange (change data capture)

Design, Develop, Test, Implement and troubleshoot ETL mappings and workflows in a large Data Warehouse environment

Strong experience developing and maintaining Informatica mappings/workflows in a data warehouse environment

Strong experience optimizing Informatica mappings, sessions and workflows

Experienced writing complex SQL's, PL/SQL and Performance tuning is a plus

Strong database experience, data analysis and analytical skills

Experience creating ETL design documentation and maintaining overall design document and deliverables

Strong working experience with XML Data

Strong written and oral communication skills

Good understanding of dimensional modeling and ETL designs for loading Star Schemas.

Call Notes:

Scope of project/Team:This role is for Data division of Multifamily. They are seeking for senior (level 4) hands on ETL Informatica Developer.

Skills required:

* Recent hands on experience with Informatica PowerCenter (currently working on PowerCenter 10.61)
* Recent hands on experience with Informatica Data quality
* Previous experience in building Datawarehouses and data marts in complex environments.
* Worked on complicated xml hierarchies with Informatica
* Experience on building applications and not just managing applications.
* Should be technically very strong
* Completely development and no administration involved.
* Experience on Power Exchange is a plus.
* Knowledge of UNIX scripting
* SQL knowledge
* Should be able to work with complex datasets and complex environments.