Etl Informatica Developer

Job description,

Hiring for ETL Informatica developer with experience range 5 years & above

Mandatory Skills: Network Engineer-F5 Load balancer

Education: BE/B.Tech/MCA/M.Tech/MSc./MS

Responsibilities

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.