Job Description:
· 9+ years of experience in Informatica Developer with strong background in ETL Data warehousing experience using Informatica PowerCenter 10.x/9.x
· Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables), OLAP.
· Experience in designing Small to Mid-level Data Warehouse Systems involving Star Schema and Snowflake for Major RDBMS systems like Oracle
· Experience in analyzing Business Requirement Document (BRD), Functional Requirement Specification (FRS).
· Extensive experience in developing complex mappings from varied transformations like Source Qualifier, Connected and Unconnected lookups, Router, Filter, Sorter, Expression, Aggregator, Joiner, Union, Update Strategy, Sequence Generator etc.
· Experience in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
· Experience in RDBMS-
· Work with various SQL Editors such as SQL DEV, TOAD, SQL Plus, and Query Analyzer
· Write Server-side Stored Procedures and Triggers, Optimizing Query Plan, Performance Tuning.
· Experience in Unix shell scripting
· Basic Knowledge of salesforce concepts like custom/standard Object, field, SOOL,SOQL
· Required knowledge in Integration of Salesforce with Informatica.