+1 844 678 44 27


Company : Optghar
Req/job Title : Salesforce Consultant with Informatica ETL Expert
Job Ref No : 5535
Post Date : 08/21/2018
Country : USA
Job State/Province : Kentucky
Job City : Louisville, 6+ Months
PrimarySkill : SALESFORCE.COM Jobs
Experience : 9 - 11
OtherSkill : Experience in functional, system, regression, user acceptance (UAT), integration and stress/load testing. · Experience working in agile environment and waterfall methodologies. · Strong analytical, logical and problem solving skill
Subject : Salesforce Consultant with Informatica ETL Expert
Description :

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.