Informatica Powercenter Developer

Data Privacy Specialist Bengaluru, Karnataka, India

Profile
Contacts

Summary

Having 4.5 years experience in Oracle 10g/11g ,Data Warehousing using Informatica Powercenter 8.6/9.1/9.5/9.6/10.2.
Possess expertise in Database as well as Data warehousing concepts, skilled at progressing from problem statement to well documented design.
Good Knowledge in Unix Which is Required for informatica.
Experience in working with Informatica Powercenter.
Experience in working with complex mappings using Mapplets, expressions, routers, lookups, aggregators, filters, updatestatergy, SQL, joiners and union transformations in Informatica.
Excellent knowledge and experience in Data Warehouse Development life cycle, Dimensional Modeling, Repository Management and Administration, Implementation of STAR, Snowflake Schemas and Slowly Changing Dimensions.
Knowledge in OLAP Function, Materialized views and Hierarchical query.
Worked on Oracle Views, Joins, queries, sub queries, correlated sub queries.
Expertise in preparation of test cases.
Possess expertise in implementation of SCD type1, SCD Type2, SCD type3 and Informatica job control table.
Good in writing complex SQL queries according to business rules.
Knowledge used in different type of indexes depending on the situation (Unique Index, B-Tree index, Bitmap Index).

Expectations

Seeking a career with an appropriate position in the reputed organization where I can fully utilize my diverse skills in computer engineering, functional experience and management skills to our mutual benefit