Request ID: 82767-1
Informatica Developer (Netezza, SCD, star schema/snowflake schema)
Plano, TX 75024
24 Months
Must Have Skills:
Extensively worked on ETL Informatica transformations effectively including Source Qualifier, Connected Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
Experience in Netezza database (SQL with Stored Proc).
Should have good knowledge in Unix.
Detailed Job Description:
Extensively worked on ETL Informatica transformations effectively including– Source Qualifier, Connected - Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
Familiar with design and implementation of the Data Warehouse life cycle and excellent knowledge on entity-relationship/multidimensional modeling (star schema, snowflake schema), Slowly Changing Dimensions (SCD Type 1, Type 2, and Type 3).
Experience in Netezza database (SQL with Stored Proc).
Should have good knowledge in Unix.
Experience in Snowflake is an added advantage.
Top 3 responsibilities you would expect the Subcon to shoulder and execute:
Extensively worked on ETL Informatica transformations effectively including Source Qualifier, Connected Unconnected Lookup, Filter, Expression, Router, Union, Normalizer, Joiner, Update, Rank, Aggregator, Stored Procedure, Sorter and Sequence Generator and created complex mappings.
Experience in Netezza database SQL with Stored Proc.
Should have good knowledge in Unix.