Informatica Power Center Developer in , United States

Job TitleRequired Skills:5-12 years (min 5 years in Informatica Power Center + DWH Development)IICS basic development/mig skills is a plus.ETL development project for data warehouse program with a strong SQL and data analysis skills in either of ANSI db (Teradata, Oracle, SQL server etc) with onsite coordination experience with offshore and customer interfacing role. Banking domain is a plusETL skills: strategies, adept in writing complex SQL queries and understanding queries as well.He/She should be able to understand the data warehousing, concepts such as schema types, dimensions, facts, SCD concepts and basic data modelling/data architecture concepts, pushdown optimization, partitioning. Understand the properties and uses of various transformations and functions available for use in Informatica as well as SQL.Should have knowledge of basic data cleansing, load balancing, performance tuning, parameterization as well as data integration from various types of sources.DB skills: relational database management systems basic knowledge is a must, along with the capacity to create logics to perform various functions in an efficient and error free manner, should at least know how to create algorithms to perform specific functions which could later be translated in any required programming .Knowledge of any other programming like Python, APIs, stored procedure development, data marts, data visualization tools, KPI extraction, scheduling tools, Unix or batch scripting and other BI reporting tools is a plus point.