Etl Informatica Developer

Job Description 

 Responsible for all activities related to the development, implementation, administration, and
support of ETL processes for large scale data warehouses using Informatica Power Centre
 Having Good SQL knowledge, worked on Netezza & Yellow brick would be good
 Having Basic UNIX shell scripting knowledge
 In-depth understanding of fundamental Data-Warehousing concepts such as Dimensional
Modelling, Star and Snowflake Schemas, Data marts, Security and deployment, FACT and
Dimensional tables, Logical and Physical data modelling.
Strong skills in Data Analysis, Data Requirement Analysis and Data Mapping for ETL
processes.
 Hands on experience in tuning mappings, identifying and resolving performance bottlenecks
in various levels like sources, targets, mappings and sessions.
 Extensive experience in ETL design, development and maintenance using SQL Server SQL,
PL/SQL, SQL Loader
 Well versed in developing the complex SQL queries, unions and multiple tables joins and
experience with Views.
 Experience in database programming in PL/SQL (Stored Procedures, Triggers and Packages).
 Well versed in UNIX shell scripting.

Desirable Skills  

ETL
UNIX
Netezza & Yellow brick